Hi Joe-
ORACLE_HOME environment variable is used to locate the Oracle Network
configuration files (tnsnames.ora spercifically)
e.g.if ORACLE_HOME = C:\Oracle\Ora10G then location of tnsnames.ora would be
located at
C:\Oracle\Ora10G\NETWORK\ADMIN\tnsnames.ora
http://www.oracle.com/technology/tech/oci/instantclient/ic-faq.html
but you CAN have multiple Databases (tnsnames) defined in your tnsname.ora
Martin--
This email message and any files transmitted with it contain confidential
information intended only for the person(s) to whom this email message is
addressed. If you have received this email message in error, please notify
the sender immediately by telephone or email and destroy the original
message without making a copy. Thank you.
----- Original Message -----
From: "joe bayer" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, April 06, 2007 1:32 PM
Subject: Change Oracle Home
Dear group,
I just upgrade my Oracle to 10g to a new Oracle HOME. How could I change
the pointer of DBI and DBD::oracle to this new home before I remove the
old home?
Is there a way I can let DBI point to two Oracle HOMEs?
Thanks very much for your help.
Joe
---------------------------------
The fish are biting.
Get more visitors on your site using Yahoo! Search Marketing.
