Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

Re: windows database service not shutting down database on reboot

Joe Armstrong-Champ

2006-06-06

Replies:

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


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.