Re: Oracle 9i behind a NAT w/SSH

"Mike Pontillo" <mike_pontillo_at_hotmail.com> schrieb im Newsbeitrag 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
>
>

Note 125021.1 on Oracle Metalink provides several solutions for that problem.

Klaus Received on Thu Sep 26 2002 - 18:01:07 CDT