Friday, March 24, 2017

Oracle SQL Developer: setup tunnel session via gataway server

Problem:
You need to setup Oracle SQL Developer to have GUI interface for database development. Unfortunately, you don't have direct access to the Oracle database due to security restrictions. Instead, you are confined using a gateway machine to access Oracle database indirectly. 
Connection credentials: 
  • Gateway server IP:           10.5.99.199
  • Gateway server SSH:           mysshuser
  • Oracle database user:           myoracleuser
  • Oracle TNS connect string:  (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.200)(PORT=1521))(CONNECT_DATA=(SID=mycorpdb))))

Required result

Seamlessly use Oracle SQL Developer from you personal laptop accessing Oracle database via middle man gateway server. 


Oracle SQL Developer setup steps:

  1. In the main menu follow View -> SSH:  adding new SSH host

  1. Enter hosts credentials:


  1. Set Database connection. Reference newly created SSH host with Port Forwarding:

No comments:

Post a Comment