- 论坛徽章:
- 0
|
把问题描述清楚一点。
操作系统为:AIX5.3, oracle 用户下一脚本单独手工执行没有问题,如果放到crontab里则执行不成功,请大侠指点一下问题在哪里?谢谢。
以用步骤在oracle用户下完成。
1.
shell脚本内容:
$ cat load_data.sh
#!/bin/ksh
ls -l /u05/home/erp/ftp/in |grep csv$ |awk '{print $NF}' >/u05/home/erp/ftp/in/csv.list
while read file_name
do
sqlplus -s erpapp/erpapp@ERPDB <<EOF
exec load_data('$file_name');
quit
EOF
done < /u05/home/erp/ftp/in/csv.list
$
2.
命令行下手工执行,执行成功。
$ sh /u05/home/erp/ftp/in/load_data.sh
PL/SQL procedure successfully completed.
3.
放到crontab里执行,则报如下错误,观察结果发现调用sqlplus出错
$ crontab -l
* * * * * /u05/home/erp/ftp/in/load_data.sh
# tail -10 /var/adm/cron/log
oracle : CMD ( /u05/home/erp/ftp/in/load_data.sh ) : PID ( 9662506 ) : Thu Aug 30 17:14:00 2012
Cron Job with pid: 9662506 Failed
oracle : CMD ( /u05/home/erp/ftp/in/load_data.sh ) : PID ( 9527432 ) : Thu Aug 30 17:15:00 2012
Cron Job with pid: 9527432 Failed
oracle : CMD ( /u05/home/erp/ftp/in/load_data.sh ) : PID ( 9441422 ) : Thu Aug 30 17:16:00 2012
Cron Job with pid: 9441422 Failed
oracle : CMD ( /u05/home/erp/ftp/in/load_data.sh ) : PID ( 9392258 ) : Thu Aug 30 17:17:00 2012
Cron Job with pid: 9392258 Failed
oracle : CMD ( /u05/home/erp/ftp/in/load_data.sh ) : PID ( 9633942 ) : Thu Aug 30 17:18:00 2012
Cron Job with pid: 9633942 Failed
|
|