It looks like something is wrong with your installation, i.e. the DBD::Oracle module is installed in a system directory but not its libclntsh.so.11.1 dependency. That's something for the sysadmin to fix---link the library to a dir in the standard library path, extend the path in /etc/profile or something.

As a workaround, you can specify a full shell command line including variable setting in a crontab as well. Or do something evil like (untested, prone to DOSing the system if something goes wrong, and hopefully unnecessary anyway)

eval "use DBD::Oracle;";
if($@) {
   $ENV{LD_LIBRARY_PATH} = '/where/ever/the/hell';
   exec $0 @ARGV;
}
[download]

LD_LIBRARY_PATH must be set before you launch perl

So if you want to set LD_LIBRARY_PATH from inside perl, you have to relaunch your script

See Re^5: replicating the command 'unset LIBPATH' in perl

#!/usr/bin/perl -l

BEGIN {
    $ENV{ORACLE_HOME}=$ORACLE_HOME;
    $ENV{PATH}="$ORACLE_HOME/bin:$PATH";
    $ENV{LD_LIBRARY_PATH}="$ORACLE_HOME/lib";
}

use strict;
use warnings;
use DBD::Oracle;

print "$DBD::Oracle::VERSION";
[download]

I can't think of anything to try this with right now but it's unlikely to work. Dynamically loaded modules use dlopen(3) to open libraries, whose Linux manpage says:

o   If, at the time that the program was started, the environment vari
+able
    LD_LIBRARY_PATH was defined to contain a colon-separated list of d
+irectories, then
    these are searched.
[download]

Note the "at the time that the program was started" bit, which means the binary i.e. the Perl interpreter here.

That's what I thought, too. But as I understand it now, it's unlikely to work if you set ENV after you load the modules, but it likely will work if set before you load the modules.

but it likely will work if set before you load the modules.

Won't, it has to be set before you run perl

Of course, another solution would be to write a shell wrapper for your script that sets LD_LIBRARY_PATH to the correct value before launching your script.

Whow, there's a reference to this thread that describes this exact problem. Seems Orrable has been doing it like this since the last millennium ...

I disagree. LD_LIBRARY_PATH should not have to be set at all, but if it must be set, then just set it in as localized a place as possible to run what you need to run.

Any response will be very much appreciated.

Please use

<code>