Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: windows database service not shutting down database on reboot
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-lReceived on Tue Jun 06 2006 - 16:01:06 CDT