Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Shutdown Immediate Hanging

Shutdown Immediate Hanging

From: Steve Perry <>
Date: Wed, 21 Aug 2002 19:13:19 -0800
Message-ID: <>

MessageI hope somebody can help me with this shutdown problem. There's 2 questions unless: how to troubleshoot a stalled shutdown and the best way to deal with it.

#1 - Database hangs during shutdown
We have several instances running on Win2k and continue to have intermittent shutdown problems. The shutdown never completes.
Here's are the steps used to stop the database

1.) Stop the application servers
1.) run a kill session script to kill all remaining sessions except the one running the script 
2.) issue shutdown immediate and hope it shuts down.

At this point, the database closes but it never dismounts. We never receive the "Completed: ALTER DATABASE DISMOUNT"

Is there anything I can do to diagnose the problem at this point?

After 15 minutes, Arcserve backs up the files to tape (delay field in arcserve job). After the backup is complete, the database startup script is run. The alert log says the startup is normal, but no connections are allowed into the database.

I either have to do a shutdown abort or stop the service and then I can start the database. I wrote a script to detect the shutdown hangs that will page me, do a shutdown abort, startup and then shutdown immediate (before the backup job starts) There's not much I can do when it stalls and I don't mind running the script if it won't corrupt my database. Is there a better way to handle this?

I checked metalink and opened a tar.
Oracle said it was a security dll issue with MS and that I should change the scripts to shutdown the service instead of using svrmgrl or sqlplus. That was fine until I realized that stopping the service will do a shutdown immediate. If the database doesn't complete before the ora_<SID>_shutdown_timeout value, it does a shutdown abort (or equivalent).



Please see the official ORACLE-L FAQ:

Author: Steve Perry

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message to: (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Aug 21 2002 - 22:13:19 CDT

Original text of this message