Home » RDBMS Server » Server Administration » Oracle not available
Oracle not available [message #64035] Wed, 08 December 2004 04:58 Go to next message
Arvind Singh
Messages: 1
Registered: December 2004
Junior Member
Hello Everybody,

I face this problem sometimes. When we start the server and try to connect to Oracle server using sql*Plus message comes: Oracle Not Available. And we are not able to login.

We have to reinstall the oracle twice. As we don't know what actually should be done to login to the oracle without reinstalling the Oracle server.

Please help me.

 

 
Re: Oracle not available [message #64037 is a reply to message #64035] Wed, 08 December 2004 05:46 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Seems your oracle is not started automatically after a reboot.
in case of windows, goto control panel/services and check the services for oracle< sid >instance and listener.
Look into the properties and make sure the are automically started.
If NO such services exist, create one using oradim.exe.
in case of UNIX, edit oratab file and use dbstart in your rc.d scripts.
Previous Topic: Random ORA-01403: no data found error
Next Topic: What's a Hybrid database
Goto Forum:
  


Current Time: Thu Jan 09 22:24:46 CST 2025