Oracle troubleshooting ORA-01089
After sending the shutdown immediate command to the test database today, observe the log and find the following content:
Tue May 12 09:52:45 2015
SHUTDOWN: Active processes prevent shutdown operation
Shutdown is blocked by the active process. Ctrl + C cannot interrupt the current session, quit the reconnection server, and open a new session:
[Oracle @ 021Y-SH-BKAP ~] $ Sqlplus/as sysdba
SQL * Plus: Release 11.2.0.1.0 Production on Tue May 12 09:54:17 2015
Copyright (c) 1982,200 9, Oracle. All rights reserved.
Connected.
SQL> shutdown immediate
The ORA-24324: service handle not initialized.
ORA-24323: value not allowed
ORA-01089: immediate shutdown in progress-no operations are permitted
SQL> startup abort
ORA-01031: insufficient privileges
View error message
[Oracle @ 021Y-SH-BKAP ~] $ Oerr ora 1, 01089
01089,000 00, "immediate shutdown in progress-no operations are permitted"
// * Cause: The shutdown immediate command was used to shut down
// A running ORACLE instance, so your operations have been
// Terminated.
// * Action: Wait for the instance to be restarted, or contact your DBA.
Disconnect session and try again
SQL> exit
Disconnected
[Oracle @ 021Y-SH-BKAP ~] $ Sqlplus/as sysdba
SQL * Plus: Release 11.2.0.1.0 Production on Tue May 12 09:57:24 2015
Copyright (c) 1982,200 9, Oracle. All rights reserved.
Connected.
SQL> shutdown abort
ORACLE instance shut down.