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
|
Title: Message
- Re: Shutdown Immediate Hanging Steve Perry
- Re: Shutdown Immediate Hanging Connor McDonald
- RE: Shutdown Immediate Hanging Muqthar Ahmed