I want to open the Oracle database instance at startup -- I have Oracle8i on a Windows 2000 server. The Oracle database service is already at the startup and it is starting automatically, but the database I have to open manually from the db-studio instance. Why is it not starting the database when the Oracle service is starting automatically?

    Requires Free Membership to View

    Login

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 re-create the service with the oradim utility (after shutting down your database). You can use the command: 

oradim –edit –sid  –startmode auto

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. To see a list of options that can be used with oradim, use the command: 

oradim –help

This was first published in May 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top