Wednesday, July 28, 2010

Tunneling Oracle For Port 1521 From Other Server

This set up is that, I cannot open the 1521 if I do directly from the outside host to my SQLDeveloper, so what I did, I tunnel to port 1521 by opening port 1525 to forward it to 1521 to that host I wanted to logged in. Basically, I can login to that system with my ssh account. So the command I did was:

ssh -L 1525:localhost:1521 username@your-host.com

Where 1525 is your local port to open and 1521 is the port you're going to tunnel, which is the default port for Oracle.
For some ways, you can also port forwarding like to port 80, port 110, or IRC ports like 6667-6669.

Hope this helps.