Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Ashish Kr MahantaApr 13 2021 — edited Apr 13 2021

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)
)
)
[oracle@AALEDWLDBUAT01 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##mahantaa@tstpuat
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

Comments

Post Details

Added on Apr 13 2021
3 comments
1,493 views