Environment variable problem?

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
samhoover@xxxxxxxxxxx
Cell: 864.633.7499
Office: 864.656.3567

Relevant Pages

  • Oracle Shared memory
    ... I am in the process of migrating an Oracle DB to a new Server, a SunFire ... someone point me on how to configure the shared memory? ... If I allocate more then 8GB RAM to Oracle in the oracle.ini the DBA ...
    (SunManagers)
  • Re: ANNOUNCE: DBD:Oracle 1.18
    ... Well a warning in one compiler is better than and error in an other so I ... This might be a problem more with the older oracle OCI in your client. ... perl -Mblib t/26exe_array.t ...
    (perl.dbi.users)
  • Re: DBD Oracle 1.20 ORA-24334 Error
    ... On the premise instant client and also tried to run perl Makefile.PL -V ... the status after having connected to Oracle ... Failed 2/33 tests, 93.94% okay ...
    (perl.dbi.users)
  • Re: float bug? perl 5.8, DBI and oracle 10.2.0
    ... If you want to store high precision numbers in oracle, you've got 38 decimal digits to play with, and with minimal coaxing perl will handle them as strings at the appropriate points so that the exact values go in and come out. ... I haven't done any numerical work in 10 years or so, but I seem to recall that one can reasonably expect 6 or so decimal significant digits from a 32 bit floating point number - I'll go out on a limb and hazard that one can expect 12 or so digits from a 64 bit floating point number - at any rate I'd be very surprised to get 18 significant digits. ...
    (perl.dbi.users)
  • RE: Memory fault(coredump) with two DBD type connections
    ... I get a core dump ... all the libraries are the same threaded model(single threaded perl uses ... I am running Perl 5.8.8 with DBD-Oracle 1.19 compiled against Oracle ... when I try to connect to the same Oracle database AND same DB2 database ...
    (perl.dbi.users)