Re: Trouble with SSH and Oracle SQL Plus Connections

> I am connecting to the DB box with the following SSH command line:
> 'ssh2 -L 9901::1521 oracle_at_'. I changed my tnsnames.ora file to point
> to port=9901 and host=localhost. According to everything I have read
> this should work. However, when I try to connect to the DB with
> SQLPLUS I get the error 'ORA-12547: TNS:lost contact'

As I see it, you are forwarding local port 9901 to remote port 1521. This connection is probably going through just fine. The listener on your Solaris box creates a dedicated server process on some other port (I dont know, say, 3331) and hands over the client connection to this server process. Now you are communicating with the server process on port 3331. Outgoing connections from the server on port 3331 (or any arbitrary port the server process is on) may be blocked by your firewall, which is why your client is telling you "it lost contact". You SHOULD be able to see this process in your Net 8 trace file on the server. One way around this is to set up the connection manager, which acts as a port forwarder on the Server.

Murali Received on Mon Nov 19 2001 - 19:58:33 CET