关于SHELL编程

willy2003

文件cpu_loader.sh中的内容如下

/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)

单独执行没有错误，但放在CRONTAB中有错
/dba/u01/oracle/admin/cpu_loader.sh

produced the following output:

Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 21
00 not found; No message file for product=RDBMS, facility=UL


我设置的执行间隔是5分钟，怎么解决这个错误啊

2,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
set ORACLE_SID=sfdb
set ORACLE_HOME=/dba/u01/oracle/9.2.0
/dba/u01/oracle/9.2.0/bin/sqlldr USERID=WXC/happy2003 CONTROL=/dba/u01/oracle/ad
min/cpustat.ctl LOG=/dba/u01/oracle/admin/cpustat.log SILENT=\(ALL\)

还是这个错误：
oracle@exp4db1$tail -20 /var/mail/oracle
        by exp4db1 (8.12.9+Sun/8.12.9) with ESMTP id i1Q6J12h011134
        for <oracle@exp4db1>;; Thu, 26 Feb 2004 14:19:01 +0800 (CST)
Received: (from oracle@localhost)
        by exp4db1 (8.12.9+Sun/8.12.9/Submit) id i1Q6J1gi011125
        for oracle; Thu, 26 Feb 2004 14:19:01 +0800 (CST)
Date: Thu, 26 Feb 2004 14:19:01 +0800 (CST)
From: oracle@exp4db1
Message-Id: <200402260619.i1Q6J1gi011125@exp4db1>;
To: oracle@exp4db1
Subject: Output from "cron" command
Content-Type: text
Content-Length: 236

Your "cron" job on exp4db1
/dba/u01/oracle/admin/cpu_loader.sh

produced the following output:

Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 21
00 not found; No message file for product=RDBMS, facility=UL

sqwen

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