Re: Type of shutdown

Hi,

With regards to stop the database via windows services, I set the ORACLE_sid_SHUTDOWNTYPE to n (normal).
Then I stop the database via windows services but it performs the shutdown (abort) as I checked in alert log.

The values of ORA_sid_SHUTDOWN is TRUE and ORA_sid_SHUTDOWN_TIMEOUT is(30) in my registry.
Could someone please check that matter?
Why it didn’t work after setting the values in registry.

Thanks

Marjina

empete2000_at_yahoo.com (Pete's) wrote in message news:<6724a51f.0408160433.4370c41f_at_posting.google.com>...
> marjina98_at_hotmail.com wrote in message news:<24bfee06.0408152254.1e97f8b6_at_posting.google.com>...
> > 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
>
>
> Check your alert log, it should have something like the following:
>
> Mon Aug 16 04:36:11 2004
> Shutting down instance (abort)
>
> or
>
> Shutting down instance: further logons disabled
> Shutting down instance (immediate)
>
> HTH,
> Pete's
Received on Tue Aug 17 2004 - 01:51:54 CDT