I 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
