Serguei wrote:
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.
I'm going through a migration now and had to recompile DBD-Oracle
against the new ORACLE_HOME.
I wanted to leave the old DBD-Oracle install in tact during my testing
so I did not do a 'make install' after
compilation. I took my test scripts, etc and added an appropriate
PERL5LIB setting;
ie.
PERL5LIB=/u99/testing/DBD-Oracle-1.23/blib/lib:/u99/testing/DBD-Oracle-1.23/blib/arch;
so could would work while the old processes are able to use the current
DBD-Oracle install.
