Re: automated shutdown in NT/2000

Glen A Stromquist wrote:

> 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...

1. apply a recent patchset to any release (e.g. 8.1.7.3.0)
2. adjust the value for

HKEY_LOCAL_MACHINE\SYSTEM\CurrentContolSet\Control\

        WaitToKillServiceTimeout was 20000 now 300000

You can use oradim to set the timeout for each service

hth,

Paul Received on Mon Mar 18 2002 - 21:55:38 CST