FAQ
Objective - execute perl modules from apache that access an oracle database

Oracle database - 10gr2, SUSE SLES9 linux
Apache server - RHAS 4.0, oracle 10gr2 instant client

Perl Version
perl -v
This is perl, v5.8.5 built for i386-linux-thread-multi

Apache Version
apachectl -v
Server version: Apache/2.0.55
Server built: Feb 28 2006 10:15:42

mod_perl, DBI, DBD versions

mod_perl -2.0.2
DBI-1.50
DBD-Oracle 1.17
Apache DBI-0.9901

Error when running perl module from apache error_log file

[Sat Apr 22 20:48:04 2006] emahni.pl: install_driver(Oracle) failed:
Can't load
'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so'
for module DBD::Oracle: libnnz10.so: cannot open shared object file: No
such file or directory at
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.

ORACLE_HOME, LD_LIBRARY_PATH ($ORACLE_HOME/lib), TWO_TASK, and
LD_RUN_PATH($ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib) set in httpd.conf

Running the script from the command line connects to the database and
returns correct results.

I've googled using the following:
module DBD::Oracle: libnnz10.so

The third and fourth google entries look as though they may be helpful
but i'm receiving a "server busy" message.

Anyone got an idea what is on these pages or experienced the same
problem and would like to share a resolution?

Thanks.

Search Discussions

  • Kevin Moore at Apr 23, 2006 at 5:05 am
    One more thing - all perl makefile.pl, make, make test, & make install,
    were successful for mod_perl, DBI, & DBD

    Kevin Moore wrote:
    Objective - execute perl modules from apache that access an oracle
    database

    Oracle database - 10gr2, SUSE SLES9 linux
    Apache server - RHAS 4.0, oracle 10gr2 instant client

    Perl Version
    perl -v
    This is perl, v5.8.5 built for i386-linux-thread-multi

    Apache Version
    apachectl -v
    Server version: Apache/2.0.55
    Server built: Feb 28 2006 10:15:42

    mod_perl, DBI, DBD versions

    mod_perl -2.0.2
    DBI-1.50
    DBD-Oracle 1.17
    Apache DBI-0.9901

    Error when running perl module from apache error_log file

    [Sat Apr 22 20:48:04 2006] emahni.pl: install_driver(Oracle) failed:
    Can't load
    '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so'
    for module DBD::Oracle: libnnz10.so: cannot open shared object file:
    No such file or directory at
    /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.

    ORACLE_HOME, LD_LIBRARY_PATH ($ORACLE_HOME/lib), TWO_TASK, and
    LD_RUN_PATH($ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib) set in httpd.conf

    Running the script from the command line connects to the database and
    returns correct results.

    I've googled using the following:
    module DBD::Oracle: libnnz10.so

    The third and fourth google entries look as though they may be helpful
    but i'm receiving a "server busy" message.

    Anyone got an idea what is on these pages or experienced the same
    problem and would like to share a resolution?

    Thanks.


  • Garrett, Philip \(MAN-Corporate\) at Apr 23, 2006 at 6:02 am

    ---------------------------------------------------------------------
    From: Kevin Moore
    Sent: Sun 4/23/2006 12:15 AM
    To: [email protected]
    Subject: DBD module loading problem


    Objective - execute perl modules from apache that access an oracle
    database

    Oracle database - 10gr2, SUSE SLES9 linux
    Apache server - RHAS 4.0, oracle 10gr2 instant client

    Perl Version
    perl -v
    This is perl, v5.8.5 built for i386-linux-thread-multi

    Apache Version
    apachectl -v
    Server version: Apache/2.0.55
    Server built: Feb 28 2006 10:15:42

    mod_perl, DBI, DBD versions

    mod_perl -2.0.2
    DBI-1.50
    DBD-Oracle 1.17
    Apache DBI-0.9901

    Error when running perl module from apache error_log file

    [Sat Apr 22 20:48:04 2006] emahni.pl: install_driver(Oracle) failed:
    Can't load '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-
    multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libnnz10.so:
    cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-
    multi/DynaLoader.pm line 230.

    ORACLE_HOME, LD_LIBRARY_PATH ($ORACLE_HOME/lib), TWO_TASK, and
    LD_RUN_PATH($ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib) set in httpd.conf
    Have you added PassEnv and PerlPassEnv directives for all of these
    variables?

    You'll need them for things to work right. See:
    http://tinyurl.com/kunxp [httpd.apache.org]
    http://tinyurl.com/jr7dw [perl.apache.org]

    hth,
    Philip

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdbi-users @
categoriesperl
postedApr 23, '06 at 4:19a
activeApr 23, '06 at 6:02a
posts3
users2
websitedbi.perl.org

People

Translate

site design / logo © 2023 Grokbase