Oracle 9i behind a NAT w/SSH

Greetings,

   To make a long story short, I need to find a way to access an Oracle 9i database from behind a firewall. (To make matters worse, over an SSH tunnel.)

   We have an Oracle 9 DB server connected behind a Linksys broadband router using NAT. We've got an SSH daemon running on the server, and what we planned to do was use SSH to forward the ports we needed to make database connections. I've forwarded port 1521 from the server to local port 1521 on my client machine. However, I still get a "TNS: No listener" error back from Oracle.

   After doing some searching on google, I found out that the listener makes a connection back to the client computer on a port that is essentially random. I need to know if there is a way to make this fixed per client, so that I can know which ports to forward back from the remote machine, to the local machine. Does anyone know if this is possible?

Regards,
Mike Pontillo Received on Thu Sep 26 2002 - 17:27:21 CDT