Oracle DBA Scripts

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

SQL Performance

• sql.LongRunning.sql
• sql.sql_id.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
• installOraPkgs.sh (Linux 8 - 19c)

Misc

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