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 09 01:36

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

On Thu, 8 Apr 2004, Richard Crawford wrote:

> On Thu, 2004-04-08 at 13:58, MB wrote:
> > 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
> Thanks, Mark.
> I tried connecting to the remote database from home, but TOra could not
> find an environment variable called ORACLE_HOME.

I am not a regular user of Oracle, but I think part of configuring your
client computer to communicate with the server includes setting up a
directory that contains the configuration files, binaries, and library
files that support your connection.

In this case, you will be setting up the ssh connection, and then
pretending the server tcp port is localhost:1521.  You'll have to Read The
Fine Manual to find out how your ORACLE_HOME should be set up.

Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil@dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...2k

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:
Appahost Applications
For a significant contribution towards our projector, and a generous donation to allow us to continue meeting at the Davis Library.