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:

Loading xml file data to oracle table using python

Sample xml file (test.xml): <?xml version="1.0"?> <data>     <customer name="Ravi" >     ...