Xref: alice comp.databases.oracle.misc:56712
Path: alice!news-feed.fnsi.net!news.idt.net!howland.erols.net!pants.skycache.com.MISMATCH!triton.skycache.com!cyclone1.gnilink.net!typhoon2.gnilink.net.POSTED!not-for-mail
From: "Thomas J. Clancy" <tjclancy@bellatlantic.net>
Newsgroups: comp.databases.oracle.misc
Subject: Oracle environment vars
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <X3wG4.251$KJ3.19157@typhoon2.gnilink.net>
Date: Wed, 05 Apr 2000 00:48:55 GMT
X-Trace: typhoon2.gnilink.net 954895735 151.201.238.164 (Tue, 04 Apr 2000 20:48:55 EDT)
NNTP-Posting-Date: Tue, 04 Apr 2000 20:48:55 EDT

Hey All,

I have installed Oracle as best I could.  Basically I need it for Java
connectivity to an external Oracle instance.  Anyway, I am running Apache
under Linux and am writing servlets.  What I need to know is how do I set up
the environment variables such as ORACLE_HOME and LD_LIBRARY_PATH such that
Apache and ApacheJServ can see and use these when launching the JVM.

My servlet is having problems with the JDBC connectivity because it can't
find the shared libraries that the Oracle java classes need, and it cannot,
obviousl, find the tnsnames.ora file to resolve the remote machine/oracle
database instance.

tom


