Oracle DBA Scripts

ASM

• asm.space_usage.sql
• asm2os.sh | os2asm.sh
• asm2os.arclogs.sh
• dir2asm.sh

BASH

• BASH Scripting Cheatsheet
• BASH Script Conventions
• BASH Script Template 1
• BASH Script Template 2
• BASH FD: stdin, stdout, stderr
• BASH Script PartitionDisks.sh

• FindIt.sh

Database

• startup.sh
• shutdown.sh
• privs_update.sh
• oractl.bat
• tables.MostAccessed.sql
• ts.size.sql

Data Guard

• setDGParams.primary.sql

Data Pump

• runDPScript.sh
• dp_status.sql
• packages.RefreshFromExport.sql
• ts.createResizeCmds.sql
• vcSnapshot.sh

.par

• expTable.par | impTable.par
• expSchema.par | impSchema.par
• expDB.par | impDB.par

TTS

• tts_export.bat | tts_import.bat

Prep Linux System for Oracle\GI

• initLnxOra<ver>.sh: 19.3 | 18.3 | 12.2 | 12.1

Misc

• DataGuard - PostCR.sql
• hugepages_settings.sh
• Indexes.toRebuild.sql
• RandomString.sql
• rman.status.sql
• RandomString.sql
• session.getKillInfo.sql
• testdata.create.sql
• users.drop.sql