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
[email protected] Tel: +44 1223 334506, Fax: +44 1223 334679
