SSH tunnel to Oracle database

Some companies have a strict security policy to connect with a database. Mostly the acceptance or production databases are accessable trough the specific hosts and ports, but not with your client.
So, if you can connect to such host trough SSH and you are running Linux, the command below could help you:

Linux users

ssh -L 7100:dbserver:1521 user@host

dbserver => The database server where the shema’s reside.
user => The linux user which has access to the linuxhost.
host => The host which had a firewall rule to connect to the databaseserver.
7100 => Your port on your localhost machine to connect to the database. (user ports => 1024-49151)
1521 => The database server connection port.

Now you could connect your client with the database by using:
dbserver = localhost
port = 7100

Poor Micr$s$ft users

You could use Putty to create a tunnel:

putty_tunnel

 

 

 

Advertisements
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: