Q
Problem solve Get help with specific problems with your technologies, process and projects.

Why won't the mount and open happen automatically?

I have installed Oracle 8.1.7 Server on Windows 2003 and created a database. I have the database service and listener service set to start automatically, and both do after a reboot. However, after reboot I get an error when attempting to connect with SQL*PLus (locally or remotely). 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 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.
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
This was last published in October 2005

Dig Deeper on Oracle database installation, upgrades and patches

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close