Configure Oracle SQL Developer to Connect to Database Cloud Service Using SSH

In the previous blog post, I have shown on how to create a new Oracle Database Cloud Service (DBCS) using Oracle Cloud Infrastructure Classic environment.

In this blog post, I will show on how to configure Oracle SQL Developer tool to get connected to the DBCS service in the cloud.

By default the DBCS listener port (default value is 1521) is not exposed to the outside world so tools like SQL Developer cannot be used to get connected to the Database Cloud Service.

So how do we get connected to the Database to perform the usual basic activities such as creating tables etc?

Create Database Cloud Service (DBCS) using Oracle Cloud Infrastructure Classic

Most of the applications do require a Relational Database to store and retrieve data.  With the introduction of Cloud based database by various Cloud vendors enable organisations to pay a subscription fee to own a database which would be fully managed by the Cloud provider.

All the major software vendors such as Oracle, Amazon, Google and Microsoft do have options to subscribe to a Database Cloud Service.

This blog post shows how quickly and easily an Oracle Database can be provisioned in the Oracle Cloud Infrastructure Classic (OCI Classic) environment.  Please note that OCI Classic was previously known as Oracle Public Cloud (OPC).