topic Scripts is not working in cron in Operating System - HP-UX

Scripts is not working in cron

DhamoThulasi — Thu, 05 Jul 2007 09:26:39 GMT

Hi experts ,

I am running the bellow scripts in cron job its not working but when i ran in normal its working fine , can you pls help me to get resolve it.

$ more chkorainst
#!/bin/ksh
# Check for PGGPDM_D1.world Oracle instance
#echo "Timestamp: `date` STATUS: `tnsping PGGPDM_D1.world | tail -1`" >> /opt/ma
trix/admin_scripts/chkorainst.output 2>&1
echo "Timestamp: `date` STATUS: " >> /opt/matrix/admin_scripts/chkorainst.output
2>&1
exit
$ ./chkorainst
$ ls
chkorainst filesystemmonitor rbtmtr rbtwas rbtwas_old
chkorainst.output finalwarn rbtmtr.txt rbtwas.txt warn
$ more chkorainst.output
Timestamp: Thu Jul 5 10:05:35 EDT 2007 STATUS:
$ ./chkorainst
$ more chkorainst.output
Timestamp: Thu Jul 5 10:05:35 EDT 2007 STATUS:
Timestamp: Thu Jul 5 10:09:48 EDT 2007 STATUS:

Re: Scripts is not working in cron

Geoff Wild — Thu, 05 Jul 2007 09:45:37 GMT

Specify full path to any programs....like /usr/bin/echo, tnsping, etc...

Most cases this is attributed to environment variables - like PATH....

Rgds...Geoff

Re: Scripts is not working in cron

Basheer_2 — Thu, 05 Jul 2007 09:56:14 GMT

Hi Thulasi

The most common cause for this not being able to run from cron is bcoz of the PATH.

edit the script and add the profiile, if user oracle is running this script, then

. /home/oracle/.profile

(absolute path of the user who is running the script )

this will provide all the needed PATH and ENV variables.

Re: Scripts is not working in cron

Dennis Handly — Thu, 05 Jul 2007 10:03:32 GMT

>Geoff: Specify full path to any programs like /usr/bin/echo

Since echo is a shell builtin, that's not needed for it.
You are correct about the other causes.

Re: Scripts is not working in cron

Hein van den Heuvel — Thu, 05 Jul 2007 10:06:37 GMT

As Geoff indicates cron jobs start out with limited environment set up. Your first step shoudl proabbly be to run a .profile or such to set up $PATH, $ORACLE_SID and so on.

There are many, many prior questions and answer about this in this very forum
To find those. Google: +cron +oracle +site:itrc.hp.com
For example:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=31119

If those answers fail to provide you with the help you need, then please be sure to re-reply with an exact description of why you think your job failed. Any particular error message? Can you cron a write with 'echo hello world'? Can you con a script to show the environement setup?

Hope this helps some,
Hein van den Heuvel (at gmail dot com)
HvdH Performance Consulting