Re: automated shutdown in NT/2000

I don't mean to offend, but you did substitute your SID for "SID", right?

E.g., ORA_ORCL_SHUTDOWN

"Glen A Stromquist" <gstromquist_at_nospamyahoo.com> wrote in message news:MGul8.24436$S57.694924_at_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 - 18:32:06 CST