RE: ACCESING ORACLE DATABASE USING SQL DEVELOPER WHEN BASHION SERVERS ARE USED
Date: Fri, 8 Apr 2016 16:10:08 +0000
Message-ID: <041f988e3da342449d0bba9c8b463e8a_at_544124-OEXCH02.ror-uc.rackspace.com>
I have ssh tunnel set up from laptop to bashion server already... looking in to,do directly same for sql developer as well, Following JEFF for now...
Thanks,
Balwanth(Bob)
Oracle Database Administrator
[1]
Balwanth.bobilli_at_rackspace.com<mailto:Balwanth.bobilli_at_rackspace.com>
1-512-874-1764
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Upendra nerilla
Sent: Friday, April 08, 2016 11:05 AM
To: jeff.d.smith_at_oracle.com; fuzzy.graybeard_at_gmail.com; Oracle-L <oracle-l_at_freelists.org>
Subject: RE: ACCESING ORACLE DATABASE USING SQL DEVELOPER WHEN BASHION SERVERS ARE USED
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_at_oracle.com<mailto:jeff.d.smith_at_oracle.com> To: fuzzy.graybeard_at_gmail.com<mailto:fuzzy.graybeard_at_gmail.com>; oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> 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_at_gmail.com]
Sent: Friday, April 08, 2016 11:20 AM
To: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>
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...
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 08 2016 - 18:10:08 CEST