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:

SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...