topic Re: crontab in Operating System - Linux

crontab

Tonatiuh — Thu, 27 Sep 2007 13:31:10 GMT

Red Hat Enterprise Linux AS 3U6

I have a crontab for oracle user and everithing seems to be well but it does not execute.

I can execute manually the script, but it is never execute by the crontab.

Any ideas abot what to check?

Re: crontab

Steven E. Protter — Thu, 27 Sep 2007 13:36:13 GMT

Shalom,

cron has a limited environment. The most common problem is the PATH variable is not the same.

From command line:

env > /tmp/env.txt

Some environment variable in that file is missing when cron runs.

SEP

Re: crontab

Tonatiuh — Thu, 27 Sep 2007 13:40:28 GMT

This is mis script:

export ORACLE_SID=lcprod01n1
export ORACLE_HOME=/opt/oracle/rdbms/9.2.0
echo "Inicia "$ORACLE_SID": "$(date +"%Y-%m-%d %H:%M.%S") >> /home/oracle/runstat.log
$ORACLE_HOME/bin/sqlplus /nolog @/home/oracle/scripts/runstat.sql
echo "Termina "$ORACLE_SID": "$(date +"%Y-%m-%d %H:%M.%S") >> /home/oracle/runstat.log

If the problem would be the envirnoment, at least the line where I log the "inicia (start)" should be executed, but does not.

Re: crontab

Steven E. Protter — Thu, 27 Sep 2007 14:30:24 GMT

Shalom,

90% of the time its the PATH variable.

SEP

Re: crontab

Ivan Ferreira — Thu, 27 Sep 2007 14:33:33 GMT

Can you post the crontab entry? Let's see what may be wrong.

Re: crontab

Tonatiuh — Thu, 27 Sep 2007 14:53:36 GMT

$ crontab -l
58 20 * * * /home/oracle/scripts/runstat.sh

Re: crontab

Ivan Ferreira — Thu, 27 Sep 2007 14:59:38 GMT

Please change to:

$ crontab -l
58 20 * * * /home/oracle/scripts/runstat.sh > /tmp/runstat.log 2>&1

Set the time execute right now and then post the /tmp/runstat.log file.

Re: crontab

Tonatiuh — Thu, 27 Sep 2007 15:42:37 GMT

Ivan,

The /tmp/runstat.log was not generated. The script was never executed.

Re: crontab

Ivan Ferreira — Thu, 27 Sep 2007 15:57:27 GMT

Wow, please post the output of:

service crond status

tail /var/log/cron

Or check in /var/log/cron what happened with your job.

Re: crontab

Tonatiuh — Thu, 27 Sep 2007 16:02:34 GMT

[root@ita1 mail]# service crond status
crond (pid 12343) is running...
[root@ita1 mail]# tail /var/log/cron
Sep 27 21:40:06 ita1 crontab[12805]: (oracle) REPLACE (oracle)
Sep 27 21:40:06 ita1 crontab[12805]: (oracle) END EDIT (oracle)
Sep 27 21:41:01 ita1 crond[12343]: (oracle) RELOAD (cron/oracle)
Sep 27 22:01:01 ita1 crond[13006]: (root) CMD (run-parts /etc/cron.hourly)
Sep 27 22:25:44 ita1 crontab[13222]: (oracle) BEGIN EDIT (oracle)
Sep 27 22:26:02 ita1 crontab[13222]: (oracle) END EDIT (oracle)
Sep 27 22:26:09 ita1 crontab[13225]: (oracle) BEGIN EDIT (oracle)
Sep 27 22:26:29 ita1 crontab[13225]: (oracle) REPLACE (oracle)
Sep 27 22:26:29 ita1 crontab[13225]: (oracle) END EDIT (oracle)
Sep 27 22:27:01 ita1 crond[12343]: (oracle) RELOAD (cron/oracle)

Re: crontab

Ivan Ferreira — Thu, 27 Sep 2007 16:20:25 GMT

Is your system time correct? Have you recently changed your timezone or something? What was the time for the job to be executed, as in the log shows, it never run.

If you changed the timezone or something, restart the cron service, may not be using the right date time.

Re: crontab

Tonatiuh — Thu, 27 Sep 2007 16:35:33 GMT

The timezone is correct. This server has just been installed recently.

I check que date of the system just before to set the new time for the cron everytime I perform a new test.

Re: crontab

Arturo Galbiati — Tue, 02 Oct 2007 02:58:25 GMT

Hi,
is it your script executable?
how you run it manually?
put at the first line
#!/usr/bin/sh
HTH,
Art

Re: crontab

Arturo Galbiati — Tue, 02 Oct 2007 03:00:11 GMT

Hi,
look at the crontab log file to see what's the error. MAybe you have reached the maximun number of process available.
Just my .02$
HTH,
Art