ORA-12505: TNS:listener does not currently know

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

Hi,

DB 11.2.0.4 on AIX

I connect to mydb from client 19.3.0.0.0 on a Linux

$tnsping mydb

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = server.com) (PORT = 1533))) (CONNECT_DATA = (SID = mydb)))

OK (10 msec)

But when :

$sqlplus user/pass@mydb

I receive:

ERROR:

ORA-12505: TNS:listener does not currently know of SID given in connect

descriptor

Thanks.