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

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

This proves that your tns entry is okay..
Probably, sqlplus is reading the TNS entry from wrong tnsnames.ora.. sqlplus reaches "a" listener, but that listener doesn't listen for the SID that your sqlplus provides.. You may also be reaching the wrong listener..

1)send me strace output for sqlplus (from the sqlplus (Linux node))  -> "strace sqlplus apps/apps@mydb"

2)from the sqlplus (Linux node) send me the output of "find /db-xxxx-dev/product -name tnsnames.ora"

3)From the db node -> ps -ef |grep inh

--Upload your outputs as files.. Don't copy paste the outputs directly.. The outputs may be very long..