My recommendation #1 would be not to shutdown at all. Oracle spent all that time and money devising wonderfully complex memory management (which they pass on to us as license dollars) so shutting down is like throwing money in the toilet..
My recommendation #2 is (for those rare times when you need to shutdown) to not use shutdown immediate - because they got the name wrong :-) If you need to shutdown, I'd just do: alter system checkpoint; shutdown abort hth connor --- Steve Perry <[EMAIL PROTECTED]> wrote: > 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 8.1.7.3 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). > > Thanks, > Steve > ===== Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "Remember amateurs built the ark - Professionals built the Titanic" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
