[vox] Connecting to a remote Oracle database

Ryan vox@lists.lugod.org
Fri, 9 Apr 2004 11:54:13 -0700


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Friday 09 April 2004 07:19 am, Richard Crawford rscrawford-at-mossroot.c=
om=20
|lugod| wrote:
> Ryan said:
> > On Thursday 08 April 2004 06:06 pm, Richard Crawford
> >
> > rscrawford-at-mossroot.com |lugod| 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.
> >
> > On a system at work we run an oracle client on, ORACLE_HOME is set to
> > $HOME/OraHome1
> >
> > Do you have an OraHome1 directory on your system?
> >
> > Also, I have to use `export ORACLE_HOME=3D$HOME/OraHome1` to make it wo=
rk.
>
> Er... I have no Oracle software installed on my computer at home, other
> than TOra.  I was just hoping to connect to the remote database, using
> TOra as a thin client.  Do I need more than that?
>
> Richard, feeling stupid...

I had to install the Oracle Devkit.

- --=20
PGP/GPG Fingerprint: 3B30 C6BE B1C6 9526 7A90  34E7 11DF 44F3 7217 7BC7
On pgp.mit.edu, import with `gpg --keyserver pgp.mit.edu --recv-key 72177BC=
7`
Also available at http://www.XXXXXXX/~ryan/ryan_at_mother_dot_com.asc
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQFAdvFfEd9E83IXe8cRAiQOAKC0hABv1AY42Lpwl8os1EINlCgcnACeIVuU
FrXyngnQi2sqjfQ9RY8I8Qs=3D
=3DCPyg
-----END PGP SIGNATURE-----