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

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

Hi,
Thank you.

Let me informe you that 2 servers are concerned (1: AIX server on which is mydb , 2: Linux server client side)
1)send me the lsnrctl status output (for the related listener)(on DB server AIX)

Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCmydb)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1533)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "mydb" has 1 instance(s).
  Instance "mydb", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


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

mydb =
 (DESCRIPTION =
  (ADDRESS_LIST =
   (ADDRESS =
    (PROTOCOL = TCP)
 
     (HOST = 10.14.2.23)
    (PORT = 1533)
   )
  )
  (CONNECT_DATA =
   (SID = mydb)
 )
)


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
/server/product/oracle/distrib/193000/client/bin/sqlplus
$ echo $ORACLE_HOME
/server/product/oracle/distrib/193000/client
 echo $TNS_ADMIN
/server/product/oracle/distrib/193000/client/network/admin

the location of your tnsnames.ora file..

/server/product/oracle/distrib/193000/client/network/admin

4)Is the database that you are try to connect to, a pluggable database? It is in 11.2.0.4 then plugable is not applied.

Regrads.