Connect to Oracle DB 9i using SSH TUNNEL via putty I am trying to connect to an Oracle database behind NAT. Therefore I create an ssh tunnel using putty.

This is the network  information:


global IP example: 122.54.34.12
LAN IP example: 192.168.3.103
Oracle database port : 1521


and this is a snapshot of the putty ssh tunnel settings 



After I have opened an ssh session  to the global IP with putty,
I try to connect to the Oracle database with SQL console through the ssh tunnel  but get the following error message: 

sql &gt; connect username/password@127.0.0.1/service-name
ERROR:
ORA-12170:TNS Connect timeout occurred
If the global IP is the NAT running the ssh server and the LAN IP is the one with the Oracle server on it, then you need to use the LAN IP as the destination in the tunnel.