RE: Failed DBD oracle module

2013-09-24 Thread John Scoles
No time to look at it today but these two sites might help

 

http://coding.derkeiler.com/Archive/Perl/perl.dbi.users/2006-12/msg00029.html 

 

or

 

http://www.pythian.com/blog/fixing-the-dreaded-unable-to-locate-an-oracle-mk-proc-mk-or-other-suitable-mk-error-in-dbdoracle-insalls/
 

 From: john...@pharmacy.arizona.edu
 CC: dbi-users@perl.org
 Subject: Re: Failed DBD oracle module
 Date: Mon, 23 Sep 2013 21:09:34 +
 
 
 On Sep 23, 2013, at 2:02 PM, Bruce Johnson john...@pharmacy.arizona.edu 
 wrote:
 
  This can happen if you have 32-bit oracle db installed on the system, but 
  use the 64-bit Oracle Instant Client to compile DBD::Oracle. 
 
 Or Vice-versa, of course, which might be what your problem is.
 
 -- 
 Bruce Johnson
 University of Arizona
 College of Pharmacy
 Information Technology Group
 
 Institutions do not have opinions, merely customs
 
 
  

Re: Failed DBD oracle module

2013-09-23 Thread Bruce Johnson

On Sep 20, 2013, at 8:57 AM, Lieng, Gia gia.li...@au.fujitsu.com wrote:

  
 $ perl perl_test.script
 Can't load 
 '/usr/local/lib/perl5/site_perl/5.18.1/sun4-solaris/auto/DBD/Oracle/Oracle.so'
  for module DBD::Oracle: ld.so.1: perl: fatal:
 /opt/oracle/10.2.0.3/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at 
 /usr/local/lib/perl5/5.18.1/sun4-solaris/DynaLoader.pm line 190.
 at perl_test.script line 4.
 Compilation failed in require at perl_test.script line 4.
 BEGIN failed--compilation aborted at perl_test.script line 4.
  
  

I think that 'Wrong ELF class' error means you have a mismatch in bit-ness 
between either Perl and Oracle or DBD and Oracle; I think this one means you 
have the 64-bit Oracle libraries installed on a system expecting 32-bits?

Perhaps you don't have the correct ORACLE_HOME and LD_LIBRARY_PATH environment 
variables set? This can happen if you have 32-bit oracle db installed on the 
system, but use the 64-bit Oracle Instant Client to compile DBD::Oracle. You 
can run a 32-bit Oracle DB and use a 64-Bit oracle client on the same system, 
you just need to know which set of libraries and ORACLE_HOME to look at.


-- 
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group

Institutions do not have opinions, merely customs




Re: Failed DBD oracle module

2013-09-23 Thread Bruce Johnson

On Sep 23, 2013, at 2:02 PM, Bruce Johnson john...@pharmacy.arizona.edu wrote:

 This can happen if you have 32-bit oracle db installed on the system, but use 
 the 64-bit Oracle Instant Client to compile DBD::Oracle. 

Or Vice-versa, of course, which might be what your problem is.

-- 
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group

Institutions do not have opinions, merely customs