I'm running Red Hat AS 4 on a Sunfire X4200 with 4 GB RAM, 2.6.9-67.ELsmp #1 SMP Wed Nov 7 13:58:04 EST 2007 i686 athlon i386 GNU/Linux Perl 5.8.5 installed with DBI 1.601 and DBD::Oracle 1.19, and the Oracle 10.2.0.1 client at /usr/lib/oracle/10.2.0.1/client ORACLE_HOME=/usr/lib/oracle/10.2.0.1/client LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.1/client/lib
I have a lot of Perl scripts that connect to an Oracle DB that work fine from the command line when run as root, and fail from crontab or with sudo when not run as root directly. I've tried including the ORACLE_HOME and LD_LIBRARY_PATH environment variables in my crontab file, but they still fail. This fixed a problem that I had seen previously with Java, that was fixed when I included JAVA_HOME in my crontab, so I was surprised when it failed with Oracle DBD. The error message that I get is install_driver(Oracle) failed: Can't load '/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libclntsh.so.10.1: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-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 /usr/local/include/BbStatistics.pm line 73 This is false, the shared library does exist at the specified location, with proper permissions. -r-xr-xr-x 1 root root 183768 May 21 2007 /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so All of my scripts worked in previous environment, Red Hat AS 3 on a Sunfire X4200 with 8 GB of RAM, 2.6.9-55.ELsmp #1 SMP Fri Apr 20 17:03:35 EDT 2007 i686 athlon i386 GNU/Linux perl 5.8.5, with DBD::Oracle 1.19 and DBI 1.601 and Oracle 8.1.7 LD_LIBRARY_PATH=/usr/oracle/product/8.1.7/lib ORACLE_HOME=/usr/oracle/product/8.1.7 I had to load the following RPMs with --nodeps option to get DBD::Oracle installed on my new machines, but presumed that all was well when scripts worked from command line. Perhaps this is part of the problem? libsqlora8-2.3.3-2.el4.i386.rpm php-squale-0.1.9-1.el4.i386.rpm libsqlora8-debuginfo-2.3.3-2.el4.i386.rpm php-squale-debuginfo-0.1.9-1.el4.i386.rpm libsqlora8-devel-2.3.3-2.el4.i386.rpm python-squale-0.1.10-0.2.el4.i386.rpm perl-DBD-Oracle-1.19-1.el4.i386.rpm squale-0.1.10-0.2.el4.i386.rpm perl-DBD-Oracle-debuginfo-1.19-1.el4.i386.rpm squale-debuginfo-0.1.10-0.2.el4.i386.rpm php-modules-debuginfo-4.3.9-3.el4.i386.rpm squale-devel-0.1.10-0.2.el4.i386.rpm php-oci8-4.3.9-3.el4.i386.rpm I'm in a time crunch to get these new servers online before Christmas, so all help is GREATLY appreciated. :) -- Sam Hoover CSO, CCIT Clemson University, Clemson, SC [EMAIL PROTECTED] Cell: 864.633.7499 Office: 864.656.3567