Re: Type of shutdown

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Mon, 16 Aug 2004 18:04:01 +1000
Message-ID: <41206a92$0$16377$afc38c87@news.optusnet.com.au>

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 Received on Mon Aug 16 2004 - 03:04:01 CDT