Oracle not available [message #64035] |
Wed, 08 December 2004 04:58 |
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 |
|
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.
|
|
|