Home » RDBMS Server » Networking and Gateways » Oracle 9i on Windows2003 and tunnel with Client SSH
Oracle 9i on Windows2003 and tunnel with Client SSH [message #317308] Wed, 30 April 2008 07:48
Messages: 4
Registered: September 2006
Location: italy
Junior Member

Hi all,
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).

In detail.
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 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version - 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


where is my client IP and 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 !


Previous Topic: Problem with Listener in DB10g on Linux
Next Topic: cant connect with OCI8 using php5.2.5
Goto Forum:

Current Time: Thu Feb 22 02:55:56 CST 2024