crontab问题

混沌之光

oracle 用户下
echo $ORACLE_HOME
/home/oracle/app/oracle/product/8.1.7

root 用户下
echo $ORACLE_HOME
/home/oracle/app/oracle/product/8.1.7

vi /etc/crontab
SHELL=/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin
ORACLE_HOME=/home/oracle/app/oracle/product/8.1.7
MAILTO=root
HOME=/

# run-parts
01 * * * * root run-parts /etc/cron.hourly
02 4 * * * root run-parts /etc/cron.daily
22 4 * * 0 root run-parts /etc/cron.weekly
42 4 1 * * root run-parts /etc/cron.monthly

======================================
错误描述：(系统mail)
From root  Sun Dec 26 01:00:01 2004
Date: Sun, 26 Dec 2004 01:00:01 +0800
From: root@**(Cron Daemon)
To: root@**
Subject: Cron <root@**>; /home/oracle/MysqlToOracle.pl
X-Cron-Env: <SHELL=/bin/sh>;
X-Cron-Env: <HOME=/root>;
X-Cron-Env: <ATH=/usr/bin:/bin>;
X-Cron-Env: <LOGNAME=root>;

ORACLE_HOME environment variable not set!
DBI->;connect(orcl) failed: Error while trying to retrieve text for error ORA-12154 (DBD ERROR: OCIServerAttach) at /home/oracle/MysqlToOracle.pl line 65
Can't call method "prepare" on an undefined value at /home/oracle/MysqlToOracle.pl line 87.
select * from radacct where acctstoptime >;='2004-12-25' and acctstoptime < '2004-12-26'

脚本为MysqlToOracle.pl，链接oracle数据库。可在终端模式下运行，crontab出错。


求助，谢谢！

liusn2000

使用oracle执行此定时任务，
使用root执行得不到oracle的相关环境变量

混沌之光

开始用的是oracle用户不行，后来才改为root用户，今天改回oracle用户错误如下：
[oracle@** oracle]$ mail
Mail version 8.1 6/6/93.  Type ? for help.
"/var/spool/mail/oracle": 1 message 1 new
>;N  1 root@**  Tue Dec 28 10:00  20/933   "Cron <oracle@**>; /home/oracle/MysqlToOracle.pl"
& 1
Message 1:
From oracle  Tue Dec 28 10:00:00 2004
Date: Tue, 28 Dec 2004 10:00:00 +0800
From: root@** (Cron Daemon)
To: oracle@**
Subject: Cron <oracle@**>; /home/oracle/MysqlToOracle.pl
X-Cron-Env: <SHELL=/bin/sh>;
X-Cron-Env: <HOME=/home/oracle>;
X-Cron-Env: <ATH=/usr/bin:/bin>;
X-Cron-Env: <LOGNAME=oracle>;

ORACLE_HOME environment variable not set!
DBI->;connect(orcl) failed: Error while trying to retrieve text for error ORA-12154 (DBD ERROR: OCIServerAttach) at /home/oracle/MysqlToOracle.pl line 65
Can't call method "prepare" on an undefined value at /home/oracle/MysqlToOracle.pl line 87.
select * from radacct where acctstoptime >;='2004-12-27' and acctstoptime < '2004-12-28'

求助，谢谢！！！

混沌之光

X-Cron-Env: <SHELL=/bin/sh>;
X-Cron-Env: <HOME=/home/oracle>;
X-Cron-Env: <ATH=/usr/bin:/bin>;
X-Cron-Env: <LOGNAME=oracle>;
各位大虾注意到没有。是因为环境变量设置没有生效！！！为什么呢？
crond的服务已经重启过了。

vi /etc/crontab
SHELL=/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin
ORACLE_HOME=/home/oracle/app/oracle/product/8.1.7
MAILTO=root
HOME=/

郁闷呀。。。