I've created several new 10.2 databases on Windows 2003. The services are all set to Automatic, however after rebooting the machine, each of the instances are idle. I can start them without any issue, but was wondering if there was a way to set these to start without any manual intervention.
I mainly work with Unix servers but I have a Windows 2003 server running 10.2 and it starts up fine if the service is set to automatic. It installed straight out the box with no install issues. I don't remember taking any additional steps for automatic startup - the Installer appeared to do it all for me.
I would check the alert log for failed startup attempts, or the Windows Event Log for any system errors.
Since there are no alert logs, that mean the database is not even finding the init file (or spfile) or even trying to startup. Check the eventlog to see if there are any indications. Other things I would look for are the directory structures proper. Where is the INIT file located? the default is oracle_home\database ... If you are setup for the database to start automatically, then ensure the init file is in the proper place. Check your registry to see where Oracle is expecting to find the init file