INSTALLATION DOCUMENTS BY RAVI

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...