in reply to Errors testing DBD::Oracle

Couple of things for future reference:

First of all, use HTML tags to present your question in an easier to read way.

Secondly, questions like this should go into the Seekers of Perl Wisdom section.

Zenon Zabinski | zdog | zdog7@hotmail.com

Replies are listed 'Best First'.
RE: (zdog) RE: Errors testing DBD::Oracle
by Anonymous Monk on Aug 30, 2000 at 06:50 UTC
    Thanks zdog.

    The least you could do after ripping someone is to offer the answer. I've actually hit a similar problem:
    Note, USERID, and SID are I believe set correctly

    # env ORACLE_SID=oraclesid ORACLE_USERID=user/pass ORACLE_HOME=/u01/app/oracle/product/816/ make test
    PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/perl5/5.00503/i86pc-solaris -I/usr/perl5/5.00503 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
    t/base..............FAILED tests 4-5
    Failed 2/5 tests, 60.00% okay
    t/general...........install_driver(Oracle) failed: Can't load 'blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1: /usr/bin/perl: fatal: libclntsh.so.8.0: open failed: No such file or directory at /usr/perl5/5.00503/i86pc-solaris/DynaLoader.pm line 169.

    at (eval 1) line 3
    Perhaps a required shared library or dll isn't installed where expected
    at t/general.t line 20
    dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/long..............Can't load 'blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1: /usr/bin/perl: fatal: libclntsh.so.8.0: open failed: No such file or directory at /usr/perl5/5.00503/i86pc-solaris/DynaLoader.pm line 169.
    at t/long.t line 4
    BEGIN failed--compilation aborted at t/long.t line 4.
    dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/plsql.............Can't load 'blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1: /usr/bin/perl: fatal: libclntsh.so.8.0: open failed: No such file or directory at /usr/perl5/5.00503/i86pc-solaris/DynaLoader.pm line 169.
    at t/plsql.t line 17
    BEGIN failed--compilation aborted at t/plsql.t line 17.
    dubious
    Test returned status 255 (wstat 65280, 0xff00)
    t/reauth............skipping test on this platform
    Failed Test Status Wstat Total Fail Failed List of failed -------------------------------------------------------------------------------
    t/base.t 5 2 40.00% 4-5
    t/general.t 255 65280 ?? ?? % ??
    t/long.t 255 65280 ?? ?? % ??
    t/plsql.t 255 65280 ?? ?? % ??
    1 test skipped.
    Failed 4/5 test scripts, 20.00% okay. 2/5 subtests failed, 60.00% okay.
    *** Error code 29
    make: Fatal error: Command failed for target `test_dynamic'

      ldd -s blib/arch/auto/DBD/Oracle/Oracle.so

      you'll probably find that its looking in /usr/lib for libclntsh.so.8.0 and since its probably in $ORACLE_HOME/lib you're getting that error.