Re: ORA-12505: TNS:listener does not currently know

Posted by ErmanArslansOracleBlog on Jan 30, 2021; 7:51am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ORA-12505-TNS-listener-does-not-currently-know-tp9289p9290.html

1)send me the lsnrctl status output (for the related listener)

2)send me the tns entry named mydb (mask the sensitive info befor doing a copy/paste to here..for security reasons..)

3)send me the following outputs;

Connect to the serve where your run sqlplus and try to connect to the database (with the related OS user)

which sqlplus
echo $ORACLE_HOME
echo $TNS_ADMIN
the location of your tnsnames.ora file..

4)Is the database that you are try to connect to, a pluggable database?