[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.