Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Oracle crashes on Windows shutdown
Just curious if any of you have ever had a problem with Oracle coming back up after a \
"crash" forced by a normal Windows shutdown (i.e. no disk or other hardware problems - \
just a reboot)?
I know there are various registry settings to determine if Oracle shuts down, how it shuts \ down (normal/immediate/abort), and how long Windows should wait. And I know that Oracle \ Support's canned response on the subject is:
"If the entry's are not set, stopping an service will do WORSE then an shutdown abort. \
Windows NT / 2000 will just "clean" the memory. This could be compared by a kill -9 on \
unix. This is likely to make any cold backup useless. "
And the Oracle Admin doc says:
"If ORA_SHUTDOWN or ORA_SID_SHUTDOWN is set to false, then shutting down OracleServiceSID \
will still shut down Oracle9i database. But it will be an abnormal shutdown, and Oracle \
Corporation does not recommend it."
But, has anyone ever actually seen it cause a problem in real life? I've seen Windows \ shutdowns force thousands of Oracle crashes over the years and not once have I seen it \ cause any trouble for Oracle on startup - other than a little crash recovery of course.
Thanks,
Brandon
Privileged/Confidential Information may be contained in this message or attachments \ hereto. Please advise immediately if you or your employer do not consent to Internet email \ for messages of this kind. Opinions, conclusions and other information in this message \ that do not relate to the official business of this company shall be understood as neither \ given nor endorsed by it. Received on Wed Dec 21 2005 - 22:04:51 CST
![]() |
![]() |