Hi Bruce,
Am 17.02.2014 um 19:30 schrieb Bruce Johnson <john...@pharmacy.arizona.edu>: > 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 rehs...@gmail.com
