On 6/6/06, Joe Armstrong-Champ <joseph.armstrong-champ@xxxxxxxxx> wrote:
We have about 10 windows servers, some w2k, some w2003 with 9i and 10g databases on them. When the server gets rebooted the database services don't get stopped and the instances crash. They always recover on startup and we have put a work-around in place but I'm curious about whether anyone else has experienced this problem. The following message appears in the oradim.log file when the problem happens:
ORA-12638: Credential retrieval failed
My guess is that a process which the database uses to authenticate itself has stopped before the oracle service and that is why the authentication fails.
I have opened an sr but they are telling me to recreate the service using oradim locally, not remotely. I did this but when it didn't work they told me to apply the latest patchset and do it again. Since this is happening across different oracle and windows versions I have a feeling that it has nothing to do with the version.
Has anyone else experienced this?
Thanks. Joe -- //www.freelists.org/webpage/oracle-l
Joe,
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)