Re: I have a weird issue with a script running under cron

Hi Bruce,


Am 17.02.2014 um 19:30 schrieb Bruce Johnson <[email protected]>:

> I get the following error:
> 
> install_driver(Oracle) failed: Can't load '/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libocci.so.11.1: cannot open shared object file: No such file or directory at /usr/lib64/perl5/DynaLoader.pm line 200, <DATA> line 749.
> at (eval 10) line 3
> Compilation failed in require at (eval 10) line 3, <DATA> line 749.
> Perhaps a required shared library or dll isn't installed where expected
> at /home/allwebfiles/perl/kfs/kfsupdate.pl line 21
> 
> The script runs just fine when run interactively in a shell.
> 
> This normally means an issue with Oracle environment variables, but I wrote another script that simply lists %ENV. When run in the same crontab I get:
> 
> Environment variables 
> HOME = /root
> LD_LIBRARY_PATH = /usr/lib/oracle/11.2/client64/lib
> LOGNAME = root
> ORACLE_HOME = /usr/lib/oracle/11.2/client64
> ORACLE_SID = phmweb
> PATH = /usr/bin:/bin
> PWD = /root
> SHELL = /bin/sh
> SHLVL = 1
> USER = root
> _ = /home/allwebfiles/perl/kfs/showenvcron.pl
> 
> These are the correct values.
> 
> So what am I missing?

try an ldd on /usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so and any dependent
library beside standard library paths to see what might be missing. Optionally
a locate for libocci.so.11.1 might be helpful.

Cheers
-- 
Jens Rehsack
[email protected]