Login  Register

Cannot connect to PDB

Posted by big on Sep 11, 2022; 3:16pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Cannot-connect-to-PDB-tp11068.html

Hi,

On R12.2.9 DB 19c on AIX (PDB is our e-business database)

On DB server cannot connect to PDB:

sqlplus system@PDB
ORA-12154: TNS:could not resolve the connect identifier specified

tnsping PDB
TNS-03505: Failed to resolve name
Some facts:
SQL> SELECT name, open_mode from v$pdbs;
NAME         OPEN_MODE
-------------------- ------------------------------
PDB$SEED       READ ONLY
PDB       READ WRITE
grep PDB /u01/product/oracle/distrib/ora19300/db/network/admin/tnsnames.ora

PDB=
                (SERVICE_NAME=ebs_PDB)
PDB_FO=
                (SERVICE_NAME=ebs_PDB)
PDB_BALANCE=
                (SERVICE_NAME=ebs_PDB)
PDB_REMOTE=
             (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCPDB))

But on Application server node we can connect to PDB:
sqlplus system@PDB
password:
Connected.
What is your diagnosis?

Thanks.