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
