You can do this nice little Perl trick:
BEGIN
{
if ($ENV{LD_LIBRARY_PATH} !~ /oracle.*lib/)
{
$ENV{LD_LIBRARY_PATH} = '/oracle/8.0.5/lib';
exec($^X, $0, @ARGV);
}
}
or something similar (e.g., we use a package that appends
to LD_LIBRARY_PATH if the value isn't already in it).
The exec piece executes your Perl script exactly as you did,
using the same Perl interpreter.
----
Steve Sapovits
Global Sports Interactive
Work Email: [EMAIL PROTECTED]
Home Email: [EMAIL PROTECTED]
Work Phone: 610-491-7087
Cell: 610-574-7706
Pager: 877-239-4003
> -----Original Message-----
> From: Scott T. Hildreth [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, July 02, 2001 2:44 PM
> To: Scott T. Hildreth
> Cc: [EMAIL PROTECTED]
> Subject: RE: Problems Running from crontab.
>
>
> I fixed it by setting the 'SHELL=/usr/local/bin/zsh' so
> the LD_LIBRARY_PATH is getting set before Perl is executed.
> I'm not sure why the behavior changed, but it works :-)
>
> On 02-Jul-01 Scott T. Hildreth wrote:
> >
> > I wonder if anyone has run into this problem. I upgrade on of our
> > production servers to perl5.6.1, DBI-1.18, and using DBD::Oracle 1.06.
> > I was using DBD::Oracle 1.07, but I went back to 1.06 to see if that
> > is the problem. Anyway I have jobs that run in cron, in the past if
> > I set the %ENV Vars, everything ran okay. since I update the Perl and
> > DBI the following error occurs,
> >
> > install_driver(Oracle) failed: Can't load
> >
> '/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBD/Oracle/Oracle.so
> '
> > for
> > module DBD::Oracle: libclntsh.so.1.0: cannot open shared object file: No
> such
> > file or directory at /usr/local/lib/perl5/5.6.1/i686-linux/DynaLoader.pm
> line
> > 206.
> >
> > ..It will run from command line, because it is getting the env from the
> > shell,
> > but not cron.
> >
> > The %ENV vars are set as,
> >
> > $ENV{ORACLE_SID} = $ARGV[0];
> > $ENV{ORACLE_HOME} = '/oracle/8.0.5';
> > $ENV{LD_LIBRARY_PATH} = '/oracle/8.0.5/lib';
> >
> > which worked until the updates. Does anyone know if this a problem with
>
> > Perl5.6.1 or DBI-1.18?
> >
> > Thanks,
> > STH
> >
> > ----------------------------------
> > E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
> > Date: 02-Jul-01
> > Time: 12:14:12
> > ----------------------------------
>
> ----------------------------------
> E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
> Date: 02-Jul-01
> Time: 13:40:59
> ----------------------------------