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.
No comments:
Post a Comment