Oracle instance not starting after reboot
Hello,
We've been seeing an issue lately with Oracle not starting correctly when the server is rebooted. This has been reported on Data Guard Standby systems but I think it is a general issue.
I've been able to reproduce the issue locally and I think it comes down to if a user logs into the system before Oracle is up then the instance does not start. We see the following in the oradim log:
Fri Mar 08 15:36:16 2013
\Oracle\product\11g\bin\oradim.exe -startup -sid amr -usrpwd * -log oradim.log -nocheck 0
Fri Mar 08 15:36:28 2013
ORA-01017: invalid username/password; logon denied
Oracle 11g on Windows 2008 Server
I've been able to reproduce the issue locally and I think it comes down to if a user logs into the system before Oracle is up then the instance does not start. We see the following in the oradim log:
Fri Mar 08 15:36:16 2013
\Oracle\product\11g\bin\oradim.exe -startup -sid amr -usrpwd * -log oradim.log -nocheck 0
Fri Mar 08 15:36:28 2013
ORA-01017: invalid username/password; logon denied
0