Migration from Oracle 9i to Oracle 11g

[email protected] (Serguei)
Newsgroups perl.dbi.users
Organization http://groups.google.com
Message-ID <7052e988-5067-4ab2-8767-07a7780c47c3@v36g2000vbs.googlegroups.com>
   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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.