Sid in tnsnames.ora is of container db and able to connect to pdbs through sql developer

Ashish Kr Mahanta

Hi Team,

This is new project for me and I am little bit confused about the connections, which are made. SID in connecting strings are referring to Container db instead of pdbs. I am unable to connect to pdbs while connecting through putty (i.e @pdbs). But when connecting through sql developer, I can able to connect to pdbs.

Tns details -

TSTCUAT_STB =

 (DESCRIPTION =

   (ADDRESS = (PROTOCOL = TCP)(HOST = *******)(PORT = 1521))

   (CONNECT_DATA =

     (SERVER = DEDICATED)

     (SID = TSTCUAT)

   )

 )

[[email protected] admin]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 13 16:37:40 2021

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

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

PDB name is TSTPUAT

$ sqlplus

SQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 13 16:35:40 2021

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

Enter user-name: c##[email protected]

Enter password:

ERROR:

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

descriptor

I dont know how sql-developer connecting through PDB's. Please help me to clarify the doubts.

Regards,

Ashish Kumar Mahanta

Ashish Kr Mahanta

One more thing to tell, if I will connect through mentioned connecting string, it will connect but no pdbs appear on query - "select name from v$pdbs".

cormaco

I dont know how sql-developer connecting through PDB's. Please help me to clarify the doubts.

Show us the connection dialog of Sql Developer for the working connection.

JohnWatson2

You'll need to add

USE_SID_AS_SERVICE_listener=on

to your listener.ora file.