一个crontab文件不能执行的问题,求各位诊断一下!! 在线等

jack7527

crontab 文件

12 20 * * * /bin/sh /export/home/as52app/OUT/wld.sh

表示每天的12点20分执行一个导数据的文件

wld.sh这个文件在export/home/as52app/OUT下直接运行可以成功,但用crontab按时自动执行后就不能成功


下面这段是它的出错报告:
From uas52adm Fri May 7 12:20:00 2004
Return-Path: <uas52adm>;
Received: (from uas52adm@localhost)
by prince.hk.newworldtel.com (8.11.7+Sun/8.11.7) id i474K0h20879
for uas52adm; Fri, 7 May 2004 12:20:00 +0800 (CST)
Date: Fri, 7 May 2004 12:20:00 +0800 (CST)
From: "BORLAND APP SERVER 5.2 ADMINISTRATOR ACCOUNT" <uas52adm>;
Message-Id: <200405070420.i474K0h20879@prince.hk.newworldtel.com>;
To: uas52adm
Subject: Output from "cron" command
Content-Type: text
Content-Length: 152

Your "cron" job on prince
/bin/sh /export/home/as52app/OUT/wld.sh

produced the following output:

/export/home/as52app/OUT/wld.sh: sqlldr: not found



wld.sh内容
#!/bin/csh -f
sqlldr userid=tpas_user/tpas_user control=import.ctl log=`date +%Y%m%d` skip=1


import.ctl内容


load data
infile 'current_28-apr-2004.csv'
infile 'current_228-apr-2004.csv'
append into table CIN_CAPACITY_INFORMATION_new
FIELDS TERMINATED BY ','
TRAILING NULLCOLS
(
capacity_info_id "MY_DB_SEQUENCE.nextval",
car_carrier_cd "get_car(:car_carrier_cd)",
CIN_DATE "to_date(:CIN_DATE,'yyyy-mm-dd')",
HOUR "to_number(:HOUR)",
OUT_TRAFFIC "to_number(:OUT_TRAFFIC)",
IN_TRAFFIC "to_number(:IN_TRAFFIC)",
field1 filler,
upd_cnt CONSTANT '0',
MAX_CAPACITY "to_number(:MAX_CAPACITY)",
CREATED_BY CONSTANT '2654',
LAST_UPD_BY CONSTANT '2654',
CREATION_DATE "to_date(sysdate, 'dd-mon-rr')",
LAST_UP_DATE "to_date(sysdate, 'dd-mon-rr')"
)

lc7888

环境变量没有带进去吧？

crazygod

12 20 * * * /bin/sh /export/home/as52app/OUT/wld.sh
改为：
12 20 * * * /export/home/as52app/OUT/wld.sh

try again

lgqdcs

在你的sh加ORACLE的环境变量

jack7527

lgqdcs :
   您好,请问
在sh加哪些ORACLE的环境变量呢,你能说详细一点吗? 谢谢

lgqdcs

你可以用ORACLE用户登陆，有env查看ORAACLE的环境变量，然后，将所有的内容拷贝到你的SH中，即可解决。因为cron是系统调用，不知道你用户的环境变量

lgqdcs

ORACLE_BASE=/u01/app/oracle                   ;export ORACLE_BASE
ORACLE_HOME=/u01/app/oracle/product/8.0.5     ;export ORACLE_HOME
ORACLE_SID=cckf                               ;export ORACLE_SID
ORACLE_TERM=vt100                             ;export ORACLE_TERM
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libORACLE_HOME/rdbms/lib    ;export LD_LIBRARY_PATH
SHLIB_PATH=$ORACLE_HOME/libORACLE_HOME/rdbms/lib                        ;export SHLIB_PATH
PATH=$ORACLE_HOME/binPATH:.:                                           ;export PATH
NLS_LANG=AMERICAN_AMERICA.zhs16cgb231280                                 ;export NLS_LANG
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data                           ;export ORA_NLS33
export TMPDIR=/tmp
umask 022

jack7527

下面是我用env查的oracle的环境变量,比较多,不知对不对呢?  你能点评一下吗?谢谢


_=/usr/bin/env
MANPATH=/usr/share/man:/opt/SUNWexplo/man:/usr/local/man
_INIT_UTS_RELEASE=5.8
HZ=100
LC_MONETARY=en_US.ISO8859-1
_INIT_UTS_MACHINE=sun4u
LC_TIME=en_US.ISO8859-1
ADMN=/ue21/as52app/var/servers/uat2bes52/adm/properties/partitions/NamingServer
PATH=/oracle/orahome/app/oracle92/product/9.2.0.1.0/bin:/ue21/as52app:/usr/local
/bin:/ue21/as52app/OptimizeitSuiteDemo/lib:/ue21/as52app/bin:/usr/bin::/usr/bin:
/usr/ucb:/oracle/orahome/app/oracle92/product/9.2.0.1.0/bin
NLS_LANG=AMERICAN_AMERICA.UTF8
_INIT_UTS_VERSION=Generic_108528-20
ORACLE_BASE=/oracle/orahome/app/oracle92
OSAGENT_PORT=35102
LIB=/ue21/as52app/var/servers/uat2bes52/partitions/lib
P1=/ue21/as52app/var/servers/uat2bes52/partitions/standard
P2=/ue21/as52app/var/servers/uat2bes52/partitions/standard2
SRV_NAME=uat2bes52
LOG=/ue21/as52app/var/servers/uat2bes52/adm/logs/partitions/standard
EDITOR=vi
_INIT_RUN_NPREV=0
CLASSPATH=/ue21/as52app/lib:/ue21/as52app/jdk/java1.4.1/bin:/oracle/orahome/app/
oracle92/product/9.2.0.1.0/jdbc/lib/classes12.zip:/oracle/orahome/app/oracle92/p
roduct/9.2.0.1.0/jdbc/lib/nls_charset12.zip:/ue21/as52app/jdk/java1.4.1/jre/lib/
rt.jar
_INIT_NET_STRATEGY=none
LOGNAME=uas52adm
_INIT_UTS_NODENAME=prince
_INIT_UTS_ISA=sparc
MAIL=/usr/mail/uas52adm
ORACLE_SID=tpasdev
PS1=$PWD>;
LOG2=/ue21/as52app/var/servers/uat2bes52/adm/logs/partitions/standard2
_INIT_PREV_LEVEL=S
LOG1=/ue21/as52app/var/servers/uat2bes52/adm/logs/partitions/standard
LOGN=/ue21/as52app/var/servers/uat2bes52/adm/logs/partitions/NamingServer
LC_MESSAGES=C
APPHOME=/ue21/as52app
LC_CTYPE=en_US.ISO8859-1
DISPLAY=192.168.41.23:0.0
JAR2=/ue21/as52app/var/servers/uat2bes52/partitions/standard2/ejb_jars
SHELL=/bin/ksh
JAR1=/ue21/as52app/var/servers/uat2bes52/partitions/standard/ejb_jars
PN=/ue21/as52app/var/servers/uat2bes52/partitions/NamingServer
HOME=/ue21/as52app
_INIT_UTS_SYSNAME=SunOS
LC_COLLATE=en_US.ISO8859-1
LC_NUMERIC=en_US.ISO8859-1
TERM=vt100
ORACLE_HOME=/oracle/orahome/app/oracle92/product/9.2.0.1.0
PWD=/ue21/as52app
ADM2=/ue21/as52app/var/servers/uat2bes52/adm/properties/partitions/standard2
ADM1=/ue21/as52app/var/servers/uat2bes52/adm/properties/partitions/standard
TZ=Hongkong
_INIT_RUN_LEVEL=3
_INIT_UTS_PLATFORM=SUNW,Ultra-60

lgqdcs

你按照我上面的给的，你修改一下试试，应该可以，因为我曾经也遇到和你相同的问题。

netzh

12 20 * * * /bin/sh /export/home/as52app/OUT/wld.sh
把环境变量加入wld.sh中，比如PATH
另外你写的好像有问题，它应该会在20:12分执行