Martin,
Thanks for your reply.
I rename the old oracle home to /OHOME_to_be_deleted, all my scripts give the
following errors:
==========================================
install_driver(Oracle) failed: Can't load
'/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so'
for module DBD::Oracle: libclntsh.so.9.0: cannot open shared object file: No
such file or directory at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
at (eval 5)[/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBI.pm:709]
line 3
Compilation failed in require at (eval
5)[/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBI.pm:709] line 3.
Perhaps a required shared library or dll isn't installed where expected
at test.pl line 8
DBI::install_driver('DBI','Oracle') called at
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBI.pm line 573
=============================================
I need to move /OHOME_to_be_deleted back to /OHOME in order for my script to
work.
This /OHOME needs to be deleted, but DBI is still pointing at it, which file
should I change so that DBI knows /OHOME is not used any more, use /OHOME_NEW
instead.
Or, do you recommend me to re-install DBD::Oracle?
Thanks
Martin Gainty <[EMAIL PROTECTED]> wrote: 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"
To:
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.
---------------------------------
Expecting? Get great news right away with email Auto-Check.
Try the Yahoo! Mail Beta.
