Thanks, yes, actually I am expecting it to run as root. (I know bad karma to follow)
But I am just trying to get it working. I have tried forcing the loading of .bash_profile and have also tried adding the following to the script: export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/client_1 export LD_LIBRARY_PATH=$ORACLE_HOME/lib But I still get this error: 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/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 /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/SearchBuilder/Handle/Oracle.pm line 6. BEGIN failed--compilation aborted at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/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. - Stark -----Original Message----- From: John BORIS [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 11, 2007 3:43 PM To: RT-Users@lists.bestpractical.com; [EMAIL PROTECTED]; Jeff Stark Subject: Re: RE: [rt-users] Cron Issues.... This might be trivial but make sure the job is running the job as the user you expect. If cron.hourly is being executed as root then it may be reading the wrong files to setup the environment. John J. Boris, Sr. JEN-A-SyS Administrator Archdiocese of Philadelphia 222 North 17th Street Philadelphia, Pa. 19103 Tel: 215-965-1714 Fax: 215-587-3525 "Remember! That light at the end of the tunnel Just might be the headlight of an oncoming train!" _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com