Why does my Oracle Database (8i) not start automatically when my server (2003 enterprise) starts up? I have to execute the
command to start my database each time when I start my server.
On the Windows platform, an Oracle database can be started automatically on server startup via the service. The most common cause of this problem is when the STARTMODE of the service is set to manual. When the service for the database is created with the oradim utility, you have the option to specify a STARTMODE as either AUTO or MANUAL. It's possible that the service was created with the STARTMODE as MANUAL, in which case your database would not start up automatically when the server reboots or starts up. To change this, you can recreate the service with the oradim utility (after shutting down your database). You can use the command:
oradim –edit –sid
It is also possible that the service is starting up but not the database. In this case, it is possible that the STARTTYPE was set to SRVC rather than INST. This would start the Windows service but not the database itself. This, too, can be modified with the oradim utility.