Tags

, , , , , , , , , , , , ,

Pre-requisite:

How to setup SSH connection in SQL Developer

After doing above, Goto “Connections” -> Right Click “New Connection”

sqldeveloper-newconIt will open below screen where connection details will be supplied.

sqldeveloper-newcon1In the above image, specify properties as given below,

Connection Name – Specify any logical name.

User Name – It is the Administrator User Name specified while setting-up Oracle Cloud Database Service. e.g. SYS.

Password – Password which was specified for the Administrator user.

Select Connection Type – SSH

Role – SYSDBA

Port Forward – When you select Connection Type = “SSH” Port forward will list down “SSH Host Name” created by you. Select SSH Host Name setup in previous blog.

Specify SID – Generally it is ORCL unless you have changed.

Click “Test” button. It will say “Success”.

Click “Save” to save this connection and use it just like another DB connection.

Advertisements