[vox] Connecting to a remote Oracle database

[MB]

Richard,

Oracle normally runs on port 1521, so you will need to open port 1521
on the oracle server ONLY to your home ip address.

That should get you enough access.  If you would rather encrypt the
channel, you can create a SSH tunnel having only port 22 open on the
oracle server something like:

ssh -l Myusername -L 1521:oracle.business.com:1521 oracle.business.com

Mark

--- Richard Crawford <rscrawford@mossroot.com> wrote:
> I'm having a devil of a time trying to find out how to connect to a
> remote
> Oracle database from my Linux computer.  Specifically...
> 
> 1.  The Oracle database that I work with is located on a Solaris
> server
>     here in Sacramento, but I live in Dixon.
> 
> 2.  Tomorrow I need to work at home to await the arrival of an
> important
>     package that FedEx won't leave without a signature.
> 
> 3.  My computer at home runs Fedora Core 1.  I have Tora installed,
> and
>     would like to connect to my work database from home so I can do
> some
>     stored procedure programming using something besides Telnet to
> log in
>     to the server to use SQL*Plus.
> 
> Anyone know where I can find the information that I need to set this
> up,
> including firewall settings, etc.?
> 
> 
> -- 
> Sláinte,
> Richard S. Crawford (AIM: Buffalo2K)
> http://www.mossroot.com   http://www.stonegoose.com/catseyeview
> "It is only with our heart that we can see clearly.  What is
> essential is
> invisible to the eye."  --Antoine de Saint Exupery
> 
> 
> _______________________________________________
> vox mailing list
> vox@lists.lugod.org
> http://lists.lugod.org/mailman/listinfo/vox