Oracle won’t start

oraclesqlplusstartup

While it was working fine, I had to stop the server once. When trying to start Oracle using a script we have, I got the following error:

SQL> Connected to an idle instance.
SQL> ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> Disconnected

Also when trying to start SQL Plus manually AS SYSDBA I get:

ERROR:
ORA-12162: TNS:net service name is incorrectly specified

Using SQL Plus with other users, I get:

ERROR:
ORA-12537: TNS:connection closed

Any help appreciated …

Best Answer

  • 1st check contents of the ORACLE_SID and ORACLE_HOME variables. Even a trailing slash at the ORACLE_HOME path makes difference

  • Locate files "alert_${ORACLE_SID}.log" and "listener.log", there you will find more information

Related Question