|Oracle 9i on Windows2003 and tunnel with Client SSH [message #317308]
||Wed, 30 April 2008 07:48
Registered: September 2006
I'm newbie in this forum and sorry for my english.
I would like to reach Oracle9i (W2003) using TOAD doing a connection using ssh protocol (through tunnel).
Machine (called DBserver) with Oracle9i that is protect by firewall.
There is a policy where olny a machine (called Application) can reach it on port 1521 (listener).
So, using the ssh protocol (putty client) I can connect to Application and I configurated a tunnel in that way:
localhost:1560 redirect to DBserver:1521.
After established a connection from my computer to Application, from prompt (my computer) the telnet command works fine:
telnet localhost:1560 ----> works fine.
After configured tnsnames.ora (on my computer), if i try to connect using Toad, I caught the following error (sqlnet.log)
Fatal NI connect error 12170.
TNS for 32-bit Windows: Version 10.2.0.3.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.3.0 - Production
Time: 30-APR-2008 11:08:46
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS: timeout dell'operazione
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Timeout dell'operazione
nt secondary err code: 60
nt OS err code: 0
Client address: <unknown>
Using the following command:
netstat -an -p tcp, this is the promtp receveid
TCP 10.50.52.64:1537 10.50.32.97:1450 SYN_SENT
where 10.50.52.64 is my client IP and 10.50.32.97 is the oracle machine (DBserver).
The problem is that DBserver waits for a SYS_SENT from my IP.
This is impossible.....
Seeking for the solution on the net i discovered that exists a regedit key called USE_SHARED_SOCKET to put ugual TRUE on <LOCAL MACHINE><SOFTWARE><ORACLE><ORACLE HOME> .... but nothing happen.
I hope you understand what I want to tell !