l i n u x - u s e r s - g r o u p - o f - d a v i s
Next Meeting:
July 7: Social gathering
Next Installfest:
Latest News:
Jun. 14: June LUGOD meeting cancelled
Page last updated:
2004 Apr 08 18:07

The following is an archive of a post made to our 'vox mailing list' by one of its subscribers.

Report this post as spam:

(Enter your email address)
Re: [vox] Connecting to a remote Oracle database
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [vox] Connecting to a remote Oracle database


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


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

vox mailing list

LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
LUGOD Group on Facebook
'Like' LUGOD on Facebook:

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
PO Box 2082, Davis, CA 95617
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.

Sponsored in part by:
EDGE Tech Corp.
For donating some give-aways for our meetings.