Oracle error
ORA-01089
ORA-01089: immediate shutdown or close in progress - no operations are permitted
What usually causes it
A SHUTDOWN IMMEDIATE or PDB close is under way.
What to check first
Wait for it to finish. If the shutdown hangs, the alert log shows whether it's waiting on sessions or on a large rollback.
Scripts that help
- Alert log errors in the last 24 hoursORA- and TNS- errors plus checkpoint warnings from the alert log, read through SQL. It can be slow when the alert log is very large.
- Open transactions and the undo they holdEvery open transaction with its session, undo size and start time. An old transaction from an idle session is usually someone who forgot to commit.