[vox] Connecting to a remote Oracle database

[Richard Crawford]

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.