Showing posts with label sqldeveloper. Show all posts
Showing posts with label sqldeveloper. Show all posts

Friday, November 13, 2015

Connecting Oracle PDB on Cloud using SQL Developer

In this post we will see how we can connect to Pluggable Database which is hosted on Oracle PaaS Cloud : Database as a Service.

As we know Pluggable databases is a new features in Oracle 12c Database so we will be using Oracle 12c Database on Oracle Database Cloud.

Pre Requisites :


  • Oracle Public Cloud environment Access.
  • Oracle Database as a Service subscription.
  • Oracle 12c Database Instance created on OPC.
  • Combination of Public key(required to create 12 instance in above step) and private key to access 12c DB instance using client - Putty and SQL Developer.
  • Passcode of keys.
  • Putty
  • SQL Developer.

Once we have all the information available we are all set to make a connection to PDB on cloud from local SQL Developer.


To connect to PDB, first we need to have a user created if not created already which has access to PDB.

For this connect to DCS cloud environment using putty. 

Enter the public IP in the putty.