Re: Oracle 9i behind a NAT w/SSH

Mike Pontillo wrote:

> 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
> >
> >

Another solution is iSQL*Plus.

Daniel Morgan Received on Fri Sep 27 2002 - 10:27:53 CDT