为什么我的oracle帐户不能执行crontab中的定时任务？？

Question

1. Mail version 8.1 6/6/93.  Type ? for help.
2. "/var/spool/mail/oracle": 1 message 1 new
3. >;N  1 root@localhost.local  Wed May 19 17:30  20/838   "Cron <oracle@OUT>; hot"
4. & 1
5. Message 1:
6. From oracle@localhost.localdomain  Wed May 19 17:30:00 2004
7. Date: Wed, 19 May 2004 17:30:00 +0800
8. From: root@localhost.localdomain (Cron Daemon)
9. To: oracle@localhost.localdomain
10. Subject: Cron <oracle@OUT>; hotbak.sh
11. X-Cron-Env: <SHELL=/bin/sh>;
12. X-Cron-Env: <HOME=/home/oracle>;
13. X-Cron-Env: <PATH=/usr/bin:/bin>;
14. X-Cron-Env: <LOGNAME=oracle>;
16. /bin/sh: line 1: hotbak.sh: command not found
18. &

复制代码

我在脚本里面是加了环境变量的？？？

Answer 1

[oracle@OUT oracle]$ more hotbak.sh
#!/bin/bash
export HOME=/home/oracle
export LOGNAME=oracle
export SHELL=/bin/bash
ORACLE_HOME=/opt/oracle9i/product/9.2.0
export ORACLE_HOME
PATH=PATH=$PATH:/bin:/usr/binORACLE_HOME/bin:/usr/sbin:/home/oracle
export PATH
export ORACLE_SID=KCGX
export ORACLE_TERM=xterm
sqlplus -s /nolog<<EOF
..........