[Oracle] How to Resolve ORA-12505, TNS:listener does not currently know of SID given in connect descriptor Error

Tadashi Shigeoka ·  Thu, December 15, 2011

When using Oracle DB, the following error occurred, so I researched the solution and am sharing it here.

This time, the error disappeared after restarting the DB.

ORA-12505 Error Details

ORA-12505: TNS:listener does not currently know of SID given in connect descriptor  tips
ORA-12505: TNS: リスナーは接続記述子で指定されたSIDを現在認識していません

The listener on the server side was running, but the instance was not running.

How to Resolve ORA-12505 Error

Startup and shutdown procedures for each service

Starting and stopping the listener (TNSListener)

lsnrctl start
lsnrctl stop

Starting and stopping the instance (OracleService)

sqlplus system/***** as sysdba
SQL> startup
SQL> shutdown

Starting and stopping Database Console (port 5500)

set ORACLE_SID=winora10
emctl start dbconsole
emctl stop dbconsole

Starting and stopping iSQL*Plus (port 5560)

isqlplusctl start
isqlplusctl stop

That’s all from the Gemba.

Reference Information