RE: Migration from Oracle 9i to Oracle 11g

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: [email protected]
> From: [email protected]
> 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