But beware that setting ORACLE_HOME to a different version to the one
that's supplying the Oracle client library (via LD_LIBRARY_PATH etc)
is likely to cause problems, like not being able to get the text of an
error message, or worse.
Tim.
On Wed, Sep 18, 2002 at 01:28:20PM -0400, [EMAIL
I am pretty sure this is supposed to reside in /etc. I know that on
our HP-UX boxes the tnsnames.ora is in /etc and we use Perl for some
database access.
-Original Message-
From: Sridhar Saragu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 8:24 AM
To: [EMAIL
on the Tru64 unix box we are using it is found at :
/usr/app/oracle/product/7.3.4/network/admin/tnsnames.ora
hope this helps
cheers
Edd
Sridhar Saragu [EMAIL PROTECTED] 09/18/02 14:21 PM
Hi,
Can somebody tell me where the Perl exactly look for tnsnames.ora while
connecting to Oracle ?
The Oracle client looks for tnsnames.ora in the
$ORACLE_HOME/network/admin directory. We typically set the Perl
variable $ENV{ORACLE_HOME} to the location of the Oracle installation in
our database connection modules prior to any attempt to open a database
connection.
-dpf-
On Wed, Sep 18, 2002 at 06:54:13PM +0530, Sridhar Saragu wrote:
Hi,
Can somebody tell me where the Perl exactly look for tnsnames.ora while
connecting to Oracle ? (like home, oracle_home, tns_admin etc ...). I want
to
know the order in which it looks the directories ?
To quote