Q

"Oracle not available" error after restart

I have a problem installing Oracle8i. After installation I am able to log in to SQL*Plus using default usernames and passwords. But once I restart it gives me an error: "Oracle not available." I am not able to locate DBA options in the installed program files.

I have a problem installing Oracle8i (8.1.5). After installation I am able to log in to SQL*Plus using default usernames and passwords. But once I restart it gives me an error: "Oracle not available." I am not able to locate DBA options in the installed program files. Please help me with this.
Since you are encountering this problem after a server reboot, check to see that the instance has started and the database is open. 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 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.
This was first published in February 2006

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close