Toad World® Forums

How to access a PDB in oracle cloud using Toad?

Hi,

I am trying to access a database(PDB) in oracle cloud using Toad? Can someone help me the procedure to configure this connection?

Regards.

Syed

No special configuration should be needed. Just treat it like any other database in your tnsnames.ora and Toad should be able to connect.

Hi John,

Thanks for the quick response. I used the connect string for the PDB and updated the local tnsnames.ora file with the public hostname for server in cloud but the connection doesnt go through.

Regards.

Shaffat

Maybe something is blocking it in your network? I don’t think this is a Toad issue. If you can get it to connect for sql*plus, it should connect for Toad too.

I don’t have an active cloud database to test with right now, but when I did, I didn’t have to do anything special to connect.

Hi John,

I am able to connect now. Thanks for your help. The issue was related to the connect string for the PDB. When I change the service name to the PDB instead of CDB:port/PDB, it works.

Regards.

Syed

Please refer
www.toadworld.com/…/using-oracle-database-12c-service-pdbs-on-oracle-cloud-platform-with-toad-for-oracle-part-i

www.toadworld.com/…/using-oracle-database-12c-service-pdbs-on-oracle-cloud-platform-with-toad-for-oracle-part-ii