Oracle DBA Runbooks

# Fix it fast.
Understand it deeply.

Eight production-tested runbooks for Oracle's most common emergencies. Written from 20+ years of real incidents — not documentation rewrites.

About these runbooks: Each one is verified against Oracle 12c, 19c, 23ai, and EBS 12.2 environments. Commands include diagnostic queries first, then fixes, then post-fix verification. Root cause sections explain why each problem happens so you can prevent recurrence.
🗄️ Storage
Tablespace Full Recovery
ORA-01653 or ORA-01688 bringing down your DB? Step-by-step: identify the culprit, add datafiles, set AUTOEXTEND, and verify the fix. Covers SYSTEM, SYSAUX, UNDO, TEMP, and user tablespaces.
⏱ 10–30 min recovery Oracle 12c / 19c / EBS
Read runbook →
📦 Archive Log
Archive Log Destination Full
ORA-19809 or ORA-00257: archiver error — the database has stopped accepting transactions. Immediate RMAN cleanup, space reclaim, and archivelog retention policy fixes.
⏱ 5–20 min recovery ARCHIVELOG mode DBs
Read runbook →
⚙️ EBS / OPP
OPP Tuning for Oracle EBS
Output Post Processor queue backlog, deadlocked OPP workers, or post-processing failures causing output file unavailability. Diagnose, clear, and tune OPP thread counts.
⏱ 15–45 min EBS 12.1 / 12.2
Read runbook →
📧 Workflow
Workflow Mailer SMTP Recovery
Oracle Workflow Mailer has stopped sending notifications. SMTP authentication errors, connection timeouts, stuck deferred queue. Full diagnosis and restart sequence for EBS 12.2.
⏱ 20–60 min EBS 12.1 / 12.2
Read runbook →
💾 Backup
RMAN Backup Failure Triage
RMAN job failed — but why? Systematic triage covering ORA-19566, ORA-27030, ORA-19809, channel errors, catalog issues, expired backups, and crosscheck/recovery validation.
⏱ 30–90 min Oracle 11g / 12c / 19c
Read runbook →
🔄 ADOP
ADOP Cutover & Rollback
ADOP cutover stalled, cleanup phase failed, or you need to roll back a patch cycle. Covers stuck phases, abandoned sessions, filesystem cleanup, and emergency adop cleanup commands.
⏱ 30–120 min EBS 12.2 only
Read runbook →
⬆️ Database Upgrade
Oracle Database Upgrade Triage
Upgrade failed? Systematic triage for preupgrade.jar errors, catctl.pl restarts, invalid objects post-upgrade, timezone file mismatches, component failures (APEX, JVM, Spatial), and rollback via Guaranteed Restore Point. Covers 12c→19c and 19c→23ai.
⏱ 1–8 hrs 12c → 19c / 23ai
Read runbook →
🏗️ EBS Upgrade
EBS Upgrade Triage
EBS upgrade or tech stack upgrade stalled? Covers 12.1→12.2 path, ADOP phase failures (prepare/apply/finalize/cutover/cleanup), AutoConfig errors, WebLogic/OHS failures, Concurrent Manager not starting, AD-A-01022, ADZDCLN, and OUI-67076 errors.
⏱ 2–24 hrs EBS 12.1 / 12.2
Read runbook →
⚙️ EBS Ops LIVE
Concurrent Manager Status & Bounce
Live: runs adcmctl.sh status over SSH, shows ICM PID, queue managers, target vs actual processes. One-click bounce with confirmation gate — stop → verify → start. Requires apps_tier SSH profile.
⚡ Real-time EBS 12.2 · Agent required
Open live runbook →
🔴 Alert Log LIVE
Oracle Alert Log — Live Tail
Live: streams the Oracle alert log via SSH (db_host profile). ORA-NNN lines highlighted in red. Filter by error code. Save last 200 lines as a snippet. Auto-discovers alert log path from v$diag_info.
⚡ Real-time stream Oracle DB · Agent required
Open live runbook →
🔧 ADOP LIVE
ADOP Phase Status
Live: runs adop -status via SSH, renders current phase, session ID, abandoned flag, and node-by-node status (prepare/apply/finalize/cutover/cleanup). Falls back to AD_ADOP_SESSIONS query if SSH unavailable.
⚡ On-demand EBS 12.2 · Read-only
Open live runbook →