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

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

tnsping doesn't prove anything about this..
It doesn't produce any errors even if the SID is not known by the listener.

tnsping doesn't check if the listener know the SID or not..

*Send me the contents of your "listener.ora". (again mask your IP info!)
*also check with sqlplus easy connect -- using that tns in the command line:

sqlplus user/password@' (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =(PROTOCOL = TCP)
(HOST = your_ip_address) (PORT = 1533) )) (CONNECT_DATA =(SID = mydb)))

Does it work?

Example:

[applmgr@ebstestdb admin]$ sqlplus apps/apps'@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebstestdb)(PORT=1530))(CONNECT_DATA=(SID=TEST)))'

SQL*Plus: Release 10.1.0.5.0 - Production on Sat Jan 30 12:11:55 2021

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>