One Script Every Oracle DBA Needs for Instant PDB Access & Health Checks

In today’s Oracle environments—CDB/PDB, RAC, Data Guard, Exadata, Hybrid Cloud—a DBA’s biggest enemy is not complexity.
It’s time.

Time wasted on:

• Manually setting ORACLE_HOME and ORACLE_SID
• Remembering the correct PDB service name
• Running the same “first 15 checks” on every incident
• Logging into the wrong container (again)

This is exactly why oradbabuddy.sh was built.

🚀 What is Oracle DBA Buddy?

Oracle DBA Buddy is an interactive, menu-driven Bash utility that allows DBAs to:

✅ Instantly discover running Oracle instances
✅ Automatically map CDBs and PDBs
✅ Connect to any PDB in seconds
✅ Perform SYSDBA, DBA, and Application DBA checks
✅ Avoid manual SQL scripts, guesswork, and human error

All from one single script.

Think of it as a Swiss Army knife for Oracle DBAs.

🎯 Why This Script Matters in Real Life

Typical DBA workflow (without DBA Buddy):

ps -ef | grep pmon
vi /etc/oratab
export ORACLE_HOME=...
export ORACLE_SID=...
sqlplus / as sysdba
show pdbs
alter session set container=...
run multiple scripts manually

With oradbabuddy.sh:

./oradbabuddy.sh
→ Select Mode
→ Select CDB/PDB
→ Select Database Service to connect to:

1. CDB$ROOT   - CDB (Root) (Instance: prod1)
2. HRPDB      - PDB        (Instance: prod1)
3. FINPDB     - PDB        (Instance: prod1)
4. REPORTPDB  - PDB        (Instance: prod2)
→ Run checks

⏱️ Time saved per incident: 10–30 minutes
🧠 Mental load reduced: massive

Download the Script

👉 GitHub Repository (Download & Contribute): https://github.com/snarani7/oradbabuddy