FAQ
New script I'm working on gets this error when I try to connect:

imap:/home/oracle/scripts # ./process_vacnotices.pl
install_driver(Oracle) failed: Can't load '/usr/lib/perl5/site_perl/
5.8.8/i586-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module
DBD::Oracle: libnnz11.so: cannot open shared object file: No such file
or directory at /usr/lib/perl5/5.8.8/i586-linux-thread-multi/
DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at ./process_vacnotices.pl line 14

Line 14: "$lda = DBI->connect("dbi:Oracle:$dbname", $login, $dbpass);"

However, libnnz11.so is right there:

imap:/home/oracle/scripts # find / -name libnnz11.so -print
/usr/local/lib/oracle/instantclient/libnnz11.so

And the env vars are Properly set:

imap:/home/oracle/scripts # set | grep ORA
ORACLE_HOME=/usr/local/lib/oracle/instantclient
ORACLE_SID=phmweb
imap:/home/oracle/scripts # set | grep LD_LIB
LD_LIBRARY_PATH=/usr/local/lib/oracle/instantclient/lib

Other scripts running on this system are running fine. (although
they're using the old ora_perl connect syntax: $lda =
&ora_login($dbname,$login,$dbpass); substituting 'use Oraperl;' and
using the old connection command produces the same error.)

$dbname is of the format:

"host=host-name.pharmacy.arizona.edu;sid=actual-sid"

I'm sure it's something obvious I'm missing...

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

Institutions do not have opinions, merely customs

Search Discussions

  • Charles Jardine at Oct 26, 2009 at 5:57 pm

    On 26/10/09 17:39, Bruce Johnson wrote:
    New script I'm working on gets this error when I try to connect:

    imap:/home/oracle/scripts # ./process_vacnotices.pl
    install_driver(Oracle) failed: Can't load
    '/usr/lib/perl5/site_perl/5.8.8/i586-linux-thread-multi/auto/DBD/Oracle/Oracle.so'
    for module DBD::Oracle: libnnz11.so: cannot open shared object file: No
    such file or directory at
    /usr/lib/perl5/5.8.8/i586-linux-thread-multi/DynaLoader.pm line 230.
    at (eval 3) line 3
    Compilation failed in require at (eval 3) line 3.
    Perhaps a required shared library or dll isn't installed where expected
    at ./process_vacnotices.pl line 14

    Line 14: "$lda = DBI->connect("dbi:Oracle:$dbname", $login, $dbpass);"

    However, libnnz11.so is right there:

    imap:/home/oracle/scripts # find / -name libnnz11.so -print
    /usr/local/lib/oracle/instantclient/libnnz11.so
    Note, libnnz11.so is in .../instantclient/ not .../instantclient/lib
    So ...
    And the env vars are Properly set:

    imap:/home/oracle/scripts # set | grep ORA
    ORACLE_HOME=/usr/local/lib/oracle/instantclient
    ORACLE_SID=phmweb
    imap:/home/oracle/scripts # set | grep LD_LIB
    LD_LIBRARY_PATH=/usr/local/lib/oracle/instantclient/lib
    ... the above is wrong. Lose the final '/lib'

    --
    Charles Jardine - Computing Service, University of Cambridge
    cj10@cam.ac.uk Tel: +44 1223 334506, Fax: +44 1223 334679
  • Bruce Johnson at Oct 26, 2009 at 7:04 pm

    On Oct 26, 2009, at 10:57 AM, Charles Jardine wrote:

    And the env vars are Properly set:
    imap:/home/oracle/scripts # set | grep ORA
    ORACLE_HOME=/usr/local/lib/oracle/instantclient
    ORACLE_SID=phmweb
    imap:/home/oracle/scripts # set | grep LD_LIB
    LD_LIBRARY_PATH=/usr/local/lib/oracle/instantclient/lib
    ... the above is wrong. Lose the final '/lib'
    Knew it was something blindingly obvious I missed.

    Thanks!


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

    Institutions do not have opinions, merely customs
  • John Scoles at Oct 26, 2009 at 6:06 pm
    Check you environment settings. It looks like DBD::Oracle can no longer
    find the ORACLE_HOME directory.

    This means one of two things

    1) the ORACLE_HOME is no longer set in the environment or
    2) someone has removed/moved/changed files in said directory

    cheers
    John Scoles

    Bruce Johnson wrote:
    New script I'm working on gets this error when I try to connect:

    imap:/home/oracle/scripts # ./process_vacnotices.pl
    install_driver(Oracle) failed: Can't load
    '/usr/lib/perl5/site_perl/5.8.8/i586-linux-thread-multi/auto/DBD/Oracle/Oracle.so'
    for module DBD::Oracle: libnnz11.so: cannot open shared object file:
    No such file or directory at
    /usr/lib/perl5/5.8.8/i586-linux-thread-multi/DynaLoader.pm line 230.
    at (eval 3) line 3
    Compilation failed in require at (eval 3) line 3.
    Perhaps a required shared library or dll isn't installed where expected
    at ./process_vacnotices.pl line 14

    Line 14: "$lda = DBI->connect("dbi:Oracle:$dbname", $login, $dbpass);"

    However, libnnz11.so is right there:

    imap:/home/oracle/scripts # find / -name libnnz11.so -print
    /usr/local/lib/oracle/instantclient/libnnz11.so

    And the env vars are Properly set:

    imap:/home/oracle/scripts # set | grep ORA
    ORACLE_HOME=/usr/local/lib/oracle/instantclient
    ORACLE_SID=phmweb
    imap:/home/oracle/scripts # set | grep LD_LIB
    LD_LIBRARY_PATH=/usr/local/lib/oracle/instantclient/lib

    Other scripts running on this system are running fine. (although
    they're using the old ora_perl connect syntax: $lda =
    &ora_login($dbname,$login,$dbpass); substituting 'use Oraperl;' and
    using the old connection command produces the same error.)

    $dbname is of the format:

    "host=host-name.pharmacy.arizona.edu;sid=actual-sid"

    I'm sure it's something obvious I'm missing...

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdbi-users @
categoriesperl
postedOct 26, '09 at 5:39p
activeOct 26, '09 at 7:04p
posts4
users3
websitedbi.perl.org

People

Translate

site design / logo © 2022 Grokbase