Oracle/Database/Oracle - Why won't the mount and open happen automatically

From Omnia
Jump to navigation Jump to search

Why won't the mount and open happen automatically? http://searchoracle.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid41_gci1136892_tax301702,00.html

QUESTION POSED ON: 25 October 2005 I have installed Oracle 8.1.7 Server on Windows 2003 and created a database (I did not create a default db when installing Oracle). I have the database service and listener service set to start automatically, and both do after a reboot. However, after reboot I get the following error when attempting to connect with SQL*Plus (locally or remotely):

ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist

I need to manually mount and open the database using svrmgrl in order for it to work. Any suggestions on why the mount and open do not happen automatically? I know 8.1.7 is "not supported" on Windows 2003 but I need this for a conversion project. Thanks.

> EXPERT RESPONSE 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 –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

keywords

oracle