Ssh – connect-to-oracle-db-9i server-using-ssh-tunnel-via-putty

configurationoracle9issh

I am trying to connect ORACLE DB behind NAT so i choose SSH TUNNEL via putty so here is the information

Global i p example: 122.54.34.12

LAN i p example : 192.168.3.103

ORACLE DB_PORT : 1521

and here is putty ssh tunnel settings

L1521     122.54.34.12:1521

so i connected to global IP ssh session and every thing is ok tell now , but when i want to connect ORACLE DB via SQL console after ssh tunnel

sql > connect username/password@127.0.0.1/service-name
ERROR:
ORA-12170:TNS Connect timeout occurred 

Best Answer

Your settings must be:

L1521 127.0.0.1:1521