Database doesn't start automatically on boot of server.
494389Feb 28 2006 — edited Feb 9 2007I am having a problem similar to what some other people appear to have seen. I haven't seen anyone come up with a solution yet. My database does not automatically start/open when the server is booted. I've checked all of the settings and everything seems fine. Has anyone figured out a way to solve this problem yet?
Thanks!
Here are some notes on the issue:
1) I'm using Windows Server 2003 w/SP1. The version of Oracle is 10.2.0.1.0.
2) The oracle instance service is set to automatically start at boot. I have confirmed that this works. The listener service also starts automatically.
3) The ORA_SID_AUTOSTART value is set to true.
4) I can open the database manually through enterprise manager or by issuing the STARTUP SQL command.
5) The alert_SID.log file (found under [Oracle Home]\admin\SID\bdump) is not logged to during system boot. I deleted the file and rebooted and a new one wasn't created. But if I go into enterprise manager and start/open the database manually it creates a new alert log file with no issues listed.
6) Someone in another post said that this was a known bug in earlier releases. Is this indeed a bug and if so, has it been fixed in 10.2?