DBA runbooks

Ordered checklists of scripts for the situations DBAs face most, each downloadable as one SQL*Plus file.

• Morning health checkThe daily pass: instance state, space, FRA, last night's backups, alert log, failed jobs, invalid objects and accounts about to expire. Read-only and…
• The database is slowWork from the outside in: overall load, what sessions are waiting on, who is blocking, and which sessions and statements are burning the most.…
• Space emergencyFor ORA-01653, ORA-01652 and a filling FRA: find what's full, what's growing and what can be reclaimed before you add storage.
• After patchingConfirm datapatch ran, every component is VALID, nothing was left invalid or unusable, PDBs opened cleanly and the alert log is quiet.
• Data Guard checkTransport on the primary, then lag, apply processes and gaps on the standby. Each script is labeled with the side it belongs on.
• Users can't connectFor ORA-12514, ORA-12519, ORA-01017 and friends, from a local SYSDBA session: is the instance open, is the PDB open, is the service registered, are…
• Set up CMU with Active DirectoryCentrally managed users on your own Oracle 19c server, so people log in with their Active Directory password and get access through AD groups. Each…