Tunneling

You need to have putty installed.

For following scenario you are connected to Client Computer and the database server have to going through SSH server, following is the example how you accomplished that

At your Client type following command and leave the session open while you are working.





The syntax is as follow

plink -ssh -l {sshusername} -L {lhost}:{lport}:{dbhost}:{dbport} {sshhost}

plink -ssh -l edba -L 127.0.0.1:1525:10.10.10.10:1525 10.99.99.99


After you have the connection ready, open new Client session to test the connection

c:\> tnsping "(description=(Address=(protocol=tcp)(host=127.0.0.1)(port=1525))(connect_data=(SID=SID)))"

After you have successful tnsping result, you can add the above connection string to your tnsnames file.