automated shutdown in NT/2000

From: Glen A Stromquist <gstromquist_at_nospamyahoo.com>
Date: Mon, 18 Mar 2002 23:24:28 GMT
Message-ID: <MGul8.24436$S57.694924@news1.telusplanet.net>

According to whatever I can find to read on this, setting the ORA_SID_SHUTDOWN to "TRUE" and the ORA_SID_SHUTDOWN_TIMEOUT to 90 (or whatever) in the registry will gracefully bring down the DB on shutdown of the OS.

Since I always have done this manually, I decided to try it on a test DB and see what happened. Looking at the alert log after just bouncing the OS without bringing the DB down manually showed that the database did a crash recovery when it autostarted, so it did a shutdown abort instead of immediate (ORA_SID_SHUTDOWNTYPE is also set to i). Changing the timeout param to 90 from the default 30 to give it more time did nothing.

I have tried this on 816 and 817 with the same results, from what I can find on metalink there is a patchset to fix this, but the link I got from Oracle was dead and they havent gotten back to me yet.

Anyone else heard of this patch?, what version etc..? I'd like to put this in place as sometimes our network admins *don't always* remember to run the shutdown scripts... Received on Mon Mar 18 2002 - 17:24:28 CST