Re: Windows SCM means crash recovery everytime

skapitza_at_volcanomail.com (s.kapitza) wrote in message news:<26703915.0306120136.5c348cde_at_posting.google.com>...
> hi,
>
> you could try the reg key ORA_<SID>_SHUTDOWN_TIMEOUT.
> don't know if this works. Its set by default to 30 secs.
>
> if you dont need the agent, disable the service.
> (could sometimes be a problem)
>
> also check google for shutdown problems with oracle
>
> regards
>
> s.kapitza
>
> timbedford_at_hotmail.com (Tim Bedford) wrote in message news:<a411bafb.0306110724.cdb254e_at_posting.google.com>...
> > Hi,
> > I've got an Oracle (8.1.7) dbase running on Windows 2000. When I
> > shutdown the OS it appears that the SCM doesn't give the instance
> > service enough time to finish tidying up. Consequently the alert log
> > shows that every time the dbase is re-opened a crash recovery takes
> > place.
> > Are there ways to get Oracle to shutdown faster?
> > thanks,
> > Tim

Tim,

Besides the ORA_<SID>_SHUTDOWN_TIMEOUT entry mentioned above you'll also need to change the registry entry for:

HKLM\System\CurrentControlSet\Control
WaitToKillServiceTimeout = 300000

that translates to 300 seconds which should be adequate unless you have a very large SGA.

hth.

Paul Received on Thu Jun 12 2003 - 08:22:03 CDT