About RDS's oracle cdb issue

Question

Hi all,

Is it possible to connect rds' oracle cdn through oracle sql developer as mentioned in following post:

[Managing Pluggable Databases (PDBs) using Oracle SQL Developer](https://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/12c_sqldev/pdb/12cPDB01.html)

I can access particular PDB through sql developer but fail to do so on CDB level.

Thanks.

Accepted Answer

Hello,

You cannot connect to a CDB in RDS for Oracle. You always connect to the tenant database (PDB) rather than the CDB.

Please refer to [Limitations of RDS for Oracle CDBs](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Oracle.Concepts.CDBs.html#Oracle.Concepts.single-tenant-limitations) as RDS for Oracle supports a subset of features available in an on-premises CDB.

Answer

Hello,

Please note, You can’t connect to a CDB. You always connect to the tenant database (PDB) rather than the CDB. Specify the endpoint for the PDB just as for a non-CDB. The only difference is that you specify pdb_name for the database name, where pdb_name is the name you chose for your PDB.

To confirm, it is expected behavior of failed connection at CDC level as per limitations [1].
Reference

[1] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Oracle.Concepts.CDBs.html#Oracle.Concepts.single-tenant-limitations : Overview of RDS for Oracle CDBs - Limitations of RDS for Oracle CDBs

About RDS's oracle cdb issue

Relevant content