Re: windows database service not shutting down database on reboot

Try Metalink Note:231495.1. Seems like winders never gets the chance to actually shutdown oracle strange as that may seem. Applying this note makes the test instance on my laptop running xp pro shutdown cleanly every time.

john

Joe Armstrong-Champ <joseph.armstrong-champ_at_tufts.edu> wrote: Paul,

I haven't tried increasing the timeout. Seems like the credentials failure wouldn't be helped by that, but I may try it.

The service is running under local system. I think I'll change it to a user that's in ora_dba.

Thanks.

> Did you do any mucking about in the registry regarding
>
> HKLM\SYSTEM\CurrentControlSet\Control\WaitToKillServiceTimeout
>
> The default value is only 20 seconds (20000), which was likely fine for
> a 7.3.4 database using say 128 MB of physical memory and perhaps a
> single job queue process.
>
> A 10g R1 database instance using say 1.7 GB of physical memory may take
> quite awhile to shutdown cleanly from a shutdown immediate. Perhaps the
> following would help:
>
> oradim -edit -sid mydb -shutmode a
>
> or if you don't want to go the route of shutdown abort when the serivce
> is stopped:
>
> oradim -edit -sid mydb -timeout 600
>
> This won't help in the case of a hard shutdown (power-off by BOFH, ups
> runs out of juice, etc).
> It also won't help with your current symptoms.
>
> The re-create the serivce and apply the latest patchset are probably the
> first 2 lines off of their script for this issue.
>
> What credentials is the OS service running under? (localsystem, service
> account with membership in the local OS ORA_DBA group, service account
> with membership in the local OS ORA_MYDB_DBA group, etc)
>
> Paul

--
http://www.freelists.org/webpage/oracle-l




 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
--
http://www.freelists.org/webpage/oracle-l