Forum Stats

  • 3,727,123 Users
  • 2,245,325 Discussions
  • 7,852,604 Comments

Discussions

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

Ashish Kr Mahanta
Ashish Kr Mahanta Member Posts: 193 Blue Ribbon

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

Answers

Sign In or Register to comment.