You'll need to set up an AT script to shutdown the databases gracefully.
Otherwise NT will just shut down and you'll have the equiavlent of a
shutdown abort on the databases.
Hop Pham <pham_hop_at_bah.com> wrote in message
news:7rbjhu$cth$1_at_news.bah.com...
> I implemented various NT registry settings to enable Oracle immediate
> shutdown on NT, but Oracle still does a shutdown abort whenever NT shuts
> down. For the default sid ORCL, I set Oracle shutdown immediate timeout
to
> 60 sec., and NT service shutdown timeout to 10 min:
>
> [HKEY_LOCAL_MACHINE]\software\oracle\
> ORA_ORCL_SHUTDOWN:REG_EXPAND_SZ:TRUE
> ORA_ORCL_SHUTDOWN_TIMEOUT:REG_EXPAND_SZ:60
>
> [HKEY_LOCAL_MACHINE]\system\currentcontrolset\control\
> WaitToKillServiceTimeout:REG_SZ:600000
>
> And rebooted NT for the registry settings to take effect. When I
re-started
> NT again, Oracle alert log did not show any immediate shutdown, and
> indicated crash recovery at startup (nothing unusual showed in NT event
> log). However, if I manually stop NT's OracleServiceORCL service, Oracle
> alert log will indicate immediate shutdown.
>
> Any ideas, folks? The environment is Oracle 8.0.5 on NT server w/sp 3.
> Thanks in advance for any assistance.
>
> Hop Pham
> pham_hop_at_bah.com
>
>
Received on Sun Sep 12 1999 - 14:27:38 CDT
