Apache -Perl-DBD-Oracle Module Issue - Regd.



Hi,

We have upgraded the Apache with SSL enabled along with Perl and compiled with DBI and DBD-Oracle Modules.. We have following versions installed..

Apache - Apache/2.2.4 (Unix)
Solaris - 8
Perl - v5.8.8
DBI - DBI-1.56
DBD-Oracle - 1.19
Oracle client - 10.2.0.1

We were able to get the Apache with SSL enabled with a sample perl and tested it successfully.. We were also able to compile the DBI & DBD-Oracle versions respectively with Apache without any issues/errors..

However when we tried to query/access the Oracle database with Perl DB module, we are getting following errors..

We have tried several ways by updating the PATH and LD_LIBRARY_PATH with "$ORACLE_HOME/lib32 & $ORACLE_HOME/lib & /usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBD/Oracle/Oracle.so" and restarted the Apache.. Still the same issue persists with below errors..

[Mon Jul 23 16:44:29 2007] [error] [client 169.188.205.211] install_driver(Oracle) failed: Can't load '/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBD/Oracle/Oracle..so' for module DBD::Oracle: ld.so.1: dbtest.pl: fatal: /data01/oracle/product/10.2.0.1/db_1/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /usr/local/lib/perl5/5.8.8/sun4-solaris/DynaLoader.pm line 230.
[Mon Jul 23 16:44:29 2007] [error] [client 169.188.205.211] at (eval 3) line 3
[Mon Jul 23 16:44:29 2007] [error] [client 169.188.205.211] Compilation failed in require at (eval 3) line 3.
[Mon Jul 23 16:44:29 2007] [error] [client 169.188.205.211] Perhaps a required shared library or dll isn't installed where expected
[Mon Jul 23 16:44:29 2007] [error] [client 169.188.205.211] at /usr/local/apache2/htdocs/dbtest.pl line 15
bash-2.03#

-Thanks
.



Relevant Pages

  • help with dbd-oracle
    ... I am receiving an error when DBD-ORACLE is compiling at run time. ... This is perl, v5.8.6 built for MSWin32-x86-multi-thread ... Title: DBI ...
    (perl.dbi.users)
  • DBD-Oracle 1.17 gives "install_driver(Oracle) failed"
    ... I was using Perl 5.6.x to connect to Oracle 9i. ... I have now upgraded to Perl 5.8.8 with DBI 1.50 and DBD-Oracle 1.17. ... The upgrade was necessitated by the WWW::Babelfish module. ...
    (perl.dbi.users)
  • $DBI::errstr == (no error string)
    ... Basic problem is that I can't connect to my PG database from inside Apache from my Linux box but I can from my OS X box. ... Using the same DBI abstraction layer and options, I can connect from standalone perl scripts on both boxes just fine. ... Looking at pcap's and my PG log files (debug level 5) it seems that I connect and authenticate just fine, but then the connection just shuts down. ...
    (perl.dbi.users)
  • Info needed about version compatibility
    ... Im using Perl *5.8.0*. ... I want to connect to Oracle using DBI - DBD-ORacle. ...
    (perl.dbi.users)
  • Re: Info needed about version compatibility
    ... Im using Perl *5.8.0*. ... I want to connect to Oracle using DBI - DBD-ORacle. ... Institut fuer wissenschaftliche Information e.V. ...
    (perl.dbi.users)