CentOS下cron定时运行shell脚本导出DMP文件问题!
在服务和监听都已启动后,以oracle用户运行根目录下的backupGZGA.sh没问题!但用crontab -e设置后重启无法正常运行没有反应:
错误提示信息如下:
Oct 2 20:52:18 localhost crond[4239]: (CRON) STARTUP (V5.0)
Oct 2 20:52:18 localhost crond[4239]: (*system*) BAD FILE MODE (/etc/cron.d/backupGZGA.sh)
Oct 2 20:56:18 localhost crontab[4398]: (oracle) LIST (oracle)
Oct 2 20:59:12 localhost crontab[4608]: (oracle) LIST (oracle)
Oct 2 21:01:01 localhost crond[4667]: (root) CMD (run-parts /etc/cron.hourly)
Oct 2 21:05:12 localhost crontab[4835]: (oracle) LIST (oracle)
Oct 2 21:06:06 localhost crontab[4865]: (oracle) LIST (oracle)
Oct 2 21:06:36 localhost crond[4945]: (CRON) STARTUP (V5.0)
Oct 2 21:06:36 localhost crond[4945]: (*system*) BAD FILE MODE (/etc/cron.d/backupGZGA.sh)
Oct 2 21:06:40 localhost crond[4998]: (CRON) STARTUP (V5.0)
Oct 2 21:06:40 localhost crond[4998]: (*system*) BAD FILE MODE (/etc/cron.d/backupGZGA.sh)
Oct 2 21:10:55 localhost crond[5259]: (CRON) STARTUP (V5.0)
Oct 2 21:10:55 localhost crond[5259]: (*system*) BAD FILE MODE (/etc/cron.d/backupGZGA.sh)
Oct 2 21:10:58 localhost crond[5298]: (CRON) STARTUP (V5.0)
Oct 2 21:10:58 localhost crond[5298]: (*system*) BAD FILE MODE (/etc/cron.d/backupGZGA.sh)
Oct 2 21:15:53 localhost crond[5603]: (CRON) STARTUP (V5.0)
Oct 2 21:15:53 localhost crond[5603]: (*system*) BAD FILE MODE (/etc/cron.d/backupGZGA.sh)
Oct 2 21:18:37 localhost crond[5760]: (CRON) STARTUP (V5.0)
Oct 2 21:18:37 localhost crond[5760]: (*system*) BAD FILE MODE (/etc/cron.d/backupGZGA.sh)
Oct 2 21:19:20 localhost crond[5851]: (CRON) STARTUP (V5.0)
Oct 2 21:19:20 localhost crond[5851]: (*system*) BAD FILE MODE (/etc/cron.d/backupGZGA.sh)
[oracle@localhost /]$ crontab -l
*/1**** /backupGZGA.sh
***********************************************************************************************
etc/cron.d中的backupGZGA.sh的源文件内容如下:
#!/bin/bash
source ~/.bash_profile
echo "Begin backup databases.....CentOS5.1_gzga"
export ORACLE_HOME=/u01/app/oracle/product/10.2.0.1
export ORACLE_SID=gzga
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
rq=`date +%y%m%d`
echo "导出前时间: " `date`
$ORACLE_HOME/bin/exp ksxt/1234 owner=ksxt file=/backup/exp_${rq}.dmp log=/backup/exp_${rq}.log
cp /backup/*.dmp /root/
ls -l backup
lftp -c "open 192.168.0.100;user vaio 123950;mirror -R /backup;put backupGZGA.sh"
rq=`date +%y%m%d_%H`
echo "Export mission over!"
echo "导出后时间: " `date`
***************************************************************************************
var/spool/cron/oracle的内容为:*/1**** /backupGZGA.sh
******************************************************************************************
想在CentOS和ORACLE 10G启动后以ORACLE用户让每分钟CentOS5.1自动成功运行一次backupGZGA.sh
请教上述错误原因?具体如何解决?