topic Re: cron causes script to fail in Operating System - HP-UX

cron causes script to fail

Dan Baker_3 — Fri, 05 Aug 2005 13:15:01 GMT

one of my dbas has a script that runs fine from the command line, but fails when run by cron
Here is the script:

oracle@luna:default:o cat exp.ksh
#!/usr/bin/ksh
export ORACLE_SID=EBPROD
cd /ora_backup
rm exp_EBPROD.dmp.gz
mknod node1 p
gzip < node1 > exp_EBPROD.dmp.gz &
exp / file=node1 buffer=50000000 log=/ora_backup/exp_EBPROD.log statistics=none full=y grants=none indexes=y compress=none constraints=y direct=y
rm -f pipe.file

Basically, it sets up a pipe, dumps the export to the pipe, where it is picked up by gzip and output to a file

here is the crontab entry
59 10 * * * /bin/ksh -c '. $HOME/.profile; cd /ora_backup; /ora_backup/exp.ksh;'

here is the pertinent error from Oracle:
EXP-00002: error in writing to export fileerror closing export file node1
EXP-00000: Export terminated unsuccessfully

It lloks to me like oracle is unable to write to the pipe. And yet, it is able to do so when the script is run from the command line.

Any suggestions?

Dan Baker

Re: cron causes script to fail

Alan Meyer_4 — Fri, 05 Aug 2005 13:21:49 GMT

when the script is run from command line, the user has executed an oracle env setup which is not run when the script is run from cron.

Re: cron causes script to fail

Dan Baker_3 — Fri, 05 Aug 2005 13:23:24 GMT

How is that? He is running his profile in the crontab entry.

Re: cron causes script to fail

Pete Randall — Fri, 05 Aug 2005 13:24:34 GMT

Cron has a very limited set of environmental variables available to it. You need to make sure that any variables, including path are set explicitly in your script.

Pete

Re: cron causes script to fail

Pete Randall — Fri, 05 Aug 2005 13:25:41 GMT

Or use full path names for all commands.

Pete

Re: cron causes script to fail

Alan Meyer_4 — Fri, 05 Aug 2005 13:29:55 GMT

the cron job does not execute the login profile for roacle when it executes the job. you need to include a line similiar to

. /home/oracle/.profile

at the beginning of the job to include the oracle environment.

Re: cron causes script to fail

Kent Ostby — Fri, 05 Aug 2005 13:30:07 GMT

Put a + sign in the top of the script and run some tests.

I suspect that Pete is right in that the only changes from cron to command line tend to be the environment variables.

If you have not set all the same environment variables to run or the full path names are not used, its quite possible that certain files arent being found.

Re: cron causes script to fail

Dan Baker_3 — Fri, 05 Aug 2005 13:46:32 GMT

Well,the crontab entry clearly loads the profile, but just to make sure, I added this line to the beginning of the script:

. /oravl01/oracle/.profile

Still no dice. Anyting else?

Re: cron causes script to fail

Alan Meyer_4 — Fri, 05 Aug 2005 13:49:57 GMT

I tested it some myself and retract the suggestions about the user env, but I agree with Pete about the limited amount of system environmental and path availability. Test out the script with the + like Kent said or put in some print/echo statements to check the availability of the pipe...

Re: cron causes script to fail

Alan Meyer_4 — Fri, 05 Aug 2005 13:54:47 GMT

(cont) because the system /etc/profile does not get executed by cron

Re: cron causes script to fail

A. Clay Stephenson — Fri, 05 Aug 2005 13:57:53 GMT

I suspect that what is wrong are the permissions on the pipe because the default mode is 666 but that is modified by umask which is not the same under cron. Add a chmod 666 node1 after the mknod. Also make sure that gzip starts by specifying a full pathname.

Sourcing oracles .profile is also problematic because it probably has commands like tset, stty, tabs ... which expect stdin to be a tty device. Surround all of those in .profile with
if [[ -t 0 ]]
then
tput ..
stty ..
fi

Re: cron causes script to fail

Dan Baker_3 — Fri, 05 Aug 2005 14:10:31 GMT

either sourcing the /etc/prfile or adding the chmod command fixed the problem. Thanks, guys!

Re: cron causes script to fail

Alan Meyer_4 — Fri, 05 Aug 2005 14:12:48 GMT

Hey, you might want to think of giving the other guys points too, they put in a lot of effort too...