Skip to content

Instantly share code, notes, and snippets.

@tschf

tschf/ORDS.md

Last active August 29, 2015 14:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tschf/7d573f09b7c9732b0549 to your computer and use it in GitHub Desktop.
Save tschf/7d573f09b7c9732b0549 to your computer and use it in GitHub Desktop.
Download ZIP
Using SSH Connections for ORDS Admin
Raw
ORDS.md

I set up the the SSH profile:

See: sshprofile.png

Then I can set up the connection by specifying the type as SSH, successfully:

See: ssh_connection_test.png

However, in the REST Admin, I don't get the SSH connection option:

See: rest_conn_opts.png

With having port 1521 closed by default, I am unable to validate the REST settings. I think this is just loaded from the settings on remote, so not having the SSH option makes sense, as these settings also get pushed back.

..

Solution (Linux based)?

Don't use SQL Developer's Port forwarding, and use the OS'. Linux also has an SSH tunnel manager which you could use [1]:

ssh -L 1521:localhost:1521 <user>@192.168.1.4

Then, you can just use the basic connection time and specify the host as localhost.

1: http://www.ubuntugeek.com/manage-ssh-tunnels-with-gnome-ssh-tunnel-manager.html

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment