Wednesday, July 25, 2018

Steps for Connecting Oracle cloud database from sqldeveloper

Note: Get the private key from oracle cloud database instance (privateKey)

Open sqldeveloper

Under View select SSH

Right click on SSH hosts and click on New SSH Host

Provide name, host and browse the private key file and click on ok

Test the newly created ssh host connection

Right click on the newly created ssh host connection and 
click on new local port forward

Give name, host and port and click on ok

Right click and click on connect to connect the ssh host

Now connect the oracle cloud database as below

Test the connection

Click on connect to connect the database

1 comment:

Perfect order of ODI export and import

  Smart Export / Import is the recommended way to achieve such a migration. This is the easiest way to make sure all the dependencies are ta...