关于SHELL编程

willy2003

文件cpu_loader.sh中的内容如下\r\n\r\n/dba/u01/oracle/9.2.0/bin/sqlldr USERID=WXC/happy2003 CONTROL=/dba/u01/oracle/admin/cpustat.ctl LOG=/dba/u01/oracle/admin/cpustat.log SILENT=(ALL)\r\n\r\n单独执行没有错误，但放在CRONTAB中有错\r\n/dba/u01/oracle/admin/cpu_loader.sh\r\n\r\nproduced the following output:\r\n\r\nMessage 2100 not found; No message file for product=RDBMS, facility=ULMessage 21\r\n00 not found; No message file for product=RDBMS, facility=UL\r\n\r\n\r\n我设置的执行间隔是5分钟，怎么解决这个错误啊\r\n\r\n2,7,12,17,22,27,32,37,42,47,52,57 * * * * /dba/u01/oracle/admin/cpu_loader.sh

wanahoo

检查你的环境变量加到cpu_loader.sh中

willy2003

oracle@exp4db1$more cpu_loader.sh\r\nset ORACLE_SID=sfdb\r\nset ORACLE_HOME=/dba/u01/oracle/9.2.0\r\n/dba/u01/oracle/9.2.0/bin/sqlldr USERID=WXC/happy2003 CONTROL=/dba/u01/oracle/ad\r\nmin/cpustat.ctl LOG=/dba/u01/oracle/admin/cpustat.log SILENT=\\(ALL\\)\r\n\r\n还是这个错误：\r\noracle@exp4db1$tail -20 /var/mail/oracle\r\n        by exp4db1 (8.12.9+Sun/8.12.9) with ESMTP id i1Q6J12h011134\r\n        for <oracle@exp4db1>;; Thu, 26 Feb 2004 14:19:01 +0800 (CST)\r\nReceived: (from oracle@localhost)\r\n        by exp4db1 (8.12.9+Sun/8.12.9/Submit) id i1Q6J1gi011125\r\n        for oracle; Thu, 26 Feb 2004 14:19:01 +0800 (CST)\r\nDate: Thu, 26 Feb 2004 14:19:01 +0800 (CST)\r\nFrom: oracle@exp4db1\r\nMessage-Id: <200402260619.i1Q6J1gi011125@exp4db1>;\r\nTo: oracle@exp4db1\r\nSubject: Output from \"cron\" command\r\nContent-Type: text\r\nContent-Length: 236\r\n\r\nYour \"cron\" job on exp4db1\r\n/dba/u01/oracle/admin/cpu_loader.sh\r\n\r\nproduced the following output:\r\n\r\nMessage 2100 not found; No message file for product=RDBMS, facility=ULMessage 21\r\n00 not found; No message file for product=RDBMS, facility=UL

sqwen

在cpu_loader.sh的开头先source一下profile文件试试:\r\nsource /etc/profile