[rt-users] Cron Issues....

[Stephen Turner]

At Wednesday 7/11/2007 01:07 PM, Jeff Stark wrote:
>Excellent!  Had no idea...you are correct, it is Oracle Connectivity
>that is causing the issue.
>
>Any ideas how I solve this?  I used the priority escalation script as a
>template.
>
>/etc/cron.hourly/RT-DemotePremier.cron:
>
>Unable to load DBIx::SearchBuilder database handle for 'Oracle'.
>Perhaps you've picked an invalid database type or spelled it
>incorrectly.
>Can't load
>'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Orac
>le/Oracle.so' for module DBD::Oracle: libclntsh.so.10.1: cannot open
>shared obje
>ct file: No such file or directory at
>/usr/lib/perl5/5.8.5/i386-linux-thread-mul
>ti/DynaLoader.pm line 230.
>  at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm
>line 6
>Compilation failed in require at
>/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuild
>er/Handle/Oracle.pm line 6.
>BEGIN failed--compilation aborted at
>/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchB
>uilder/Handle/Oracle.pm line 6.
>Compilation failed in require at (eval 207) line 1.
>BEGIN failed--compilation aborted at (eval 207) line 1.
>Compilation failed in require at /opt/rt3/lib/RT.pm line 201.
>

Another guess - do you have LD_LIBRARY_PATH defined? I think 
$ORACLE_HOME/lib should be included in this path.

Steve