Re: Migration from Oracle 9i to Oracle 11g

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.