Oracle will not shutdown
A shutdown command has been issued to the Oracle database, but it will not shutdown.
Shutdown normal’ has been issued to the Oracle database,
but Oracle will not shutdown.
Possible Causes and Remedies:
There are two likely causes:
Shutdown Normal’ will only shutdown Oracle when there are no remaining connections to Oracle. It is likely therefore that an application still has an active session.
- close all open sessions
- or issue a ‘
- If using Oracle Parallel Server issuing ‘
Shutdown normal’ on more than one node at a time can cause the system to hang. This is a recognised Oracle problem (Oracle 8.0.5).
- Only issue ‘
Shutdown normal’ on one node at a time, and only issue it on the next node when the previous node has completed its shutting down.
- Alternately, use ‘
shutdown immediate’ instead.
- Only issue ‘
Shutdown immediate’ has been issued to the Oracle
database, but Oracle will not shutdown.
Possible causes and remedies:
- If someone is in the login process then shutdown immediate will
not work and it will appear to hang.
Remedy: Issue ‘
Shutdown normal’ or ‘
shutdown immediate’ is preferred to ‘
shutdown abort’, because ‘
shutdown abort’ may require some recovery when the database is next started up and because ‘
shutdown abort’ is not guaranteed to free up all system resources.
- In a parallel server environment, Oracle recommends (for 8.0.5
at least) shutting down the ‘
OracleService<SID>’ in preference to using ‘
- For Oracle Parallel Server only: The database does shutdown but
the command is not seen to complete.
Remedy: Look at Task Manager. If an Oracle process is running at 100% and there has been not other noticeable activity for a while then kill the offending process. This is a known problem (for 8.0.5).
This page represents one page of many pages of notes I made whilst working with Oracle 7 through to 10i. I now no longer work with Oracle databases, but hope that these notes will continue to be of benefit to others.
About the author: Brian Cryer is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.