Re: Oracle 9i behind a NAT w/SSH

   Success!!! After combing through all the documentation, I found that Oracle Connection Manager can do this. After I installed it and reconfigured my client tnsnames file, it worked beautifully. Apparantly, it only talks on port 1630 (or whatever you configure it as), so you don't have any firewall problems. I just had to configure my service in the Net Manager to point at two addresses -- 1630 and then 1521, as described in the following section of the documentation:

http://download-west.oracle.com/otndoc/oracle9i/901_doc/network.901/a90154/c man.htm#489890

Regards,
Mike

"Mike Pontillo" <mike_pontillo_at_hotmail.com> wrote in message news:dRLk9.1143$bX.373_at_sccrnsc02...
> 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 Fri Sep 27 2002 - 01:07:14 CDT