Dear [Email Address Removed] don't mention the exact error, but the cron will run in a different environment than when you call it while logged in.

You will probably need to set some environment variables like:

ORACLE_HOME
and maybe:
LD_LIBRARY_PATH

Check what these are in your normal environment & add them to your script.

I have found that these two will solve most Oracle-via-crontab issues, but there may be more things you need to do. The main thing to remember is that the cron job uses a different run-time environment.

HTH,
Tim

> -----Original Message-----
> From: [Email Address Removed] [mailto:[Email Address Removed] Sent: Friday, October 31, 2003 10:03 AM
> To: LazyDBA.com Discussion
> Subject: crontab issue
>
>
> Hello all DBAs,
> I have a .sh that calls a script and runs perfectly, but when
> I program it
<snip>...
Oracle LazyDBA home page