Re: Oracle shutdown abort on NT

Continuing this theme....are there any undesirable consequences of using shutdown abort ????

Cheers

Steve Bright

steve.bright_at_capgemini.co.uk

Van Messner wrote in message ...
>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 Mon Sep 13 1999 - 04:45:36 CDT