Would be great if one could jsut change the oracle hole like that and have it
work.
Unfortunetly we do not live in fairy-tale land so you will have to recompile
your DBD::Oracle against your new client.
cheers
John
> To: dbi-users@perl.org
> From: serguei.goumeni...@cibc.ca
> Subject: Migration from Oracle 9i to Oracle 11g
> Date: Tue, 23 Feb 2010 10:38:17 -0800
>
> Dear Experts,
> I have a Perl application which works fine at Solaris UNIX box with
> Perl 5.6.1 and the Oracle 9i database. Now our team is moving to the
> Oracle 11g database and I have a problem. I changed $PATH,
> $ORACLE_HOME and $LD_LIBRARY_PATH variables to point to new Oracle 11g
> client installation:
>
> echo $ORACLE_HOME
> /apps/oracle/client11g
>
> echo $LD_LIBRARY_PATH
> /apps/oracle/client11g/lib32
>
> echo $PATH
> .:/export/home/etmadmin/j2sdk1.4.1_04/bin:/export/home/etmadmin/ant/
> bin:/export/apps/etm/asperl561/bin:/usr/bin:/usr/ucb:/etc:/usr/ccs/
> bin:/usr/sbin:/usr/local/bin://bin:/apps/oracle/client11g/bin
>
> I try to run my Perl program but it fails with the following message:
>
> Can't load '/export/apps/etm/etm/../asperl561/lib/site_perl/5.6.1/sun4-
> solaris-thread-multi/auto/DBD/Oracle/Oracle.so' for module
> DBD::Oracle: ld.so.1: perl: fatal: libclntsh.so.9.0: open failed: No
> such file or directory at /export/apps/etm/etm/../asperl561/lib/5.6.1/
> sun4-solaris-thread-multi/DynaLoader.pm line 206.
>
> It seems the Perl environment still points to the previous Oracle 9i
> installation. Could you please give me any hint how to fix this issue?
>
> Regards,
> Serguei.
>
_________________________________________________________________
Introducing Windows® phone.
http://go.microsoft.com/?linkid=9708122
