RE: ACCESING ORACLE DATABASE USING SQL DEVELOPER WHEN BASHION SERVERS ARE USED

Create a tunnel, then create a local port forward.  

Then use that detail to create your database connection.  

Danny Bryant has a nice blog post showing how it works.  

From: Balwanth Bobilli [mailto:Balwanth.Bobilli_at_rackspace.com] Sent: Friday, April 08, 2016 11:49 AM
To: Jeff Smith; fuzzy.graybeard_at_gmail.com; oracle-l_at_freelists.org Subject: RE: ACCESING ORACLE DATABASE USING SQL DEVELOPER WHEN BASHION SERVERS ARE USED  

I do not use any application other than putty and RDP although those are OS level access .. for putty and RDP and I can provide gateway details or ssh from the bashion itself. But not sure how to follow the same in sql developer ?  

Thanks,

Balwanth(Bob)

Oracle Database Administrator

1

HYPERLINK "mailto:Balwanth.bobilli_at_rackspace.com"Balwanth.bobilli_at_rackspace.com

1-512-874-1764  

From: HYPERLINK "mailto:oracle-l-bounce_at_freelists.org"oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeff Smith Sent: Friday, April 08, 2016 10:29 AM
To: HYPERLINK "mailto:fuzzy.graybeard_at_gmail.com"fuzzy.graybeard_at_gmail.com; HYPERLINK "mailto:oracle-l_at_freelists.org"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: HYPERLINK "mailto:oracle-l_at_freelists.org"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-l