Re: Type of shutdown

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Mon, 16 Aug 2004 11:50:17 +0200
Message-ID: <cfpvkp$tbg$1@news5.tilbu1.nb.home.nl>

Howard J. Rogers wrote:

> marjina98_at_hotmail.com wrote:
>
>

>>Hi,
>>
>>I have a following question:
>>
>>When using Windows with Oracle and stop the Oracle Instance using
>>windows Services Start/Stop the Oracle Database is shutdown.
>>
>>What kind of shutdown is performed in this case ? (Normal, Immediate,
>>Transactional or Abort )
>>
>>Thanks
>>
>>Marjina

>
>
> If memory serves, it's an immediate by default. If not that, then it's
> abort. It's definitely one or the other (I'd be more definitive if only I
> had a Windows machine to hand!)
>
> In any case, there's a registry entry that determines it and you can go and
> check it to find out (and change it if you want it to do one of the other
> types of shutdown, whatever it's originally set to).
>
> The registry key is (again, from memory, so please bear with me):
>
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0
>
> And the value you're looking for is called something like:
> ORACLE_sid_SHUTDOWNTYPE. Set it to obvious values: i for immediate, a for
> abort, t for transactional and so on.
>
> Regards
> HJR
Verified, correct.

Make sure to allow/check ORA_sid_SHUTDOWN (TRUE/FALSE, default: TRUE) and ORA_sid_SHUTDOWN_TIMEOUT (30 by default - ridiculous!)

-- 

Regards,
Frank van Bortel

Received on Mon Aug 16 2004 - 04:50:17 CDT