Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Oracle crashes on Windows shutdown

Oracle crashes on Windows shutdown

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: 2005-12-21 22:04:51
Message-id: 04DDF147ED3A0D42B48A48A18D574C4503D3FF73@NT15.oneneck.corp


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US