[Oracle] How to Resolve ORA-12505, TNS:listener does not currently know of SID given in connect descriptor Error
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: 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.
Startup and shutdown procedures for each service
lsnrctl start
lsnrctl stop
sqlplus system/***** as sysdba
SQL> startup
SQL> shutdown
set ORACLE_SID=winora10
emctl start dbconsole
emctl stop dbconsole
isqlplusctl start
isqlplusctl stop
That’s all from the Gemba.