If your environment allows it, you would have to create an SSH tunnel and
through the tunnel connect to the database server.
Another option is to run sql developer from a windows server that is in the
same network, it may be painful to connect to a remote server and use pl/sql
developer, but if the first option doesn't work and if you really need pl/sql
developer, you may have compromise your convenience..
If you have multiple bastion hosts and a variety of networks, it might be even
more painful.
Good luck.
Date: Fri, 8 Apr 2016 08:28:50 -0700
From: jeff.d.smith@xxxxxxxxxx
To: fuzzy.graybeard@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: ACCESING ORACLE DATABASE USING SQL DEVELOPER WHEN BASHION SERVERS
ARE USED
The only connectivity bits in SQL Developer that go outside of normal
JDBC/SQLNET is that we also have the ability to create a SSH tunnel for the db
connections to go through. I’ve not worked with bastion servers before, so
don’t know if that would provide an outlet or any relief for your puzzle… Jeff
From: Hans Forbrich [mailto:fuzzy.graybeard@xxxxxxxxx] ;
Sent: Friday, April 08, 2016 11:20 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: ACCESING ORACLE DATABASE USING SQL DEVELOPER WHEN BASHION SERVERS
ARE USED Do you have any other tools or applications that access the database
through those bastion servers?
If not, you will need to understand the Oracle Networking mechanism and
implications to determine the firewall impacts. I know some consultants who
could help with that.
/Hans
On 08/04/2016 8:56 AM, Balwanth Bobilli wrote:I would like to know how to
access oracle databases using SQL developer when bastion servers are used for
intermediate security…