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.

Create Oracle Database Cloud connection in SQL Developer

One of the most basic things to start working on Database Cloud Service offered by Oracle (PAAS) is to create a connection to Database Cloud service from local SQL Developer and browse through the schema and database objects.

The most important and foremost step for using cloud service is to have all the information of the cloud service instance.

Once you logon to the service dashboard by logging into cloud.oracle.com you can see all the services allocated to your account in the dashboard.