Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I would like to create an SQL Developer connection to a database through a couple of tunnels.

The steps right now are:

Connect to server A -> connect to server B -> run sqlplus against tnsname on a server that I do not have ssh access to.

Is there an easy way of using SQL Developer instead of sqlplus? I have read through >20 articles on the subject and still have no idea how to actually make the connection.

I understand that you can chain ssh -L commands to get the server connection, but I don't know how to use that connection in SQL Developer.

share|improve this question

1 Answer 1

up vote 2 down vote accepted

You can create your tunnel like so:

ssh -L 1521:server_b:1521 -N server_a

The first 1521 is the local port you want to bind to, so you can change that as you want. Then in sqldeveloper connect to localhost:1521 (where 1521 is, again, the local port you chose).

Of course if you're on Windows you can create the tunnel with PuTTY. The Session host would be server_a, and then you go to Connection → SSH → Tunnels and enter 1521 as your Source port, and the Destination is server_b:1521. Make sure you press Add after entering the info, then you can open the connection.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.