Re: windows database service not shutting down database on reboot

  • From: Joe Armstrong-Champ <joseph.armstrong-champ@xxxxxxxxx>
  • To: bdbafh@xxxxxxxxx
  • Date: Tue, 06 Jun 2006 17:01:06 -0400

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: