shell sqlplus crontab

nicolaus

写了一个shell，单独执行没有问题，正常执行。
但是使用crontab定时执行的时候除了问题，在调用sqlplus的时候报错
Print ORACLE_HOME start......
/home/ora/oracle/product/10.1.0/Db_1
Print ORACLE_HOME end  ......
/home/nicolaus/shell/executeSQL.sh: line 20: sqlplus: command not found

其中前面三行是我打印的环境变量的信息，我在网上查了一下，有人说是我环境变量的问题，shell在执行的时候找不到环境变量，于是我把环境变量打印出来
似乎我的环境变量是好的。

本人没有写过shell

凭感觉貌似，问题处在crontab上。

添付文件如下：
crontab.txt
00 08 * * * /home/nicolaus/shell/insertT_TEKIYOURATE_JOUHOU.sh 1
00 10 * * * /home/nicolaus/shell/insertT_TEKIYOURATE_JOUHOU.sh 2
00 15 * * * /home/nicolaus/shell/insertT_TEKIYOURATE_JOUHOU.sh 3

executeSQL.sh

#!/bin/bash

#Environmental parameters for Oracle Client
/home/ora/oracle/product/10.1.0/Db_1
cd /home/ora/oracle/product/10.1.0/Db_1/bin
ORACLE_HOME=/home/ora/oracle/product/10.1.0/Db_1;export ORACLE_HOME

echo "SQL=$1"

if [ $# -eq 0  ]
then
    echo "USAGE:executeSQL.sh [SQL]"
    exit 1
fi

echo "Print ORACLE_HOME start......"
echo $ORACLE_HOME
echo "Print ORACLE_HOME end  ......"

sqlplus yizq/yizq@orcl <<_EOF_
$1
commit;
quit
_EOF_

exit 0


insertT_TEKIYOURATE_JOUHOU.sh

#!/bin/bash

SYSTEMDATE=`date +%Y%m%d`

case $1 in
    '1')
        SQL_FILE=$(dirname $0)/T_TEKIYOURATE_JOUHOU_1.sql
        ;;
    '2')
        SQL_FILE=$(dirname $0)/T_TEKIYOURATE_JOUHOU_2.sql
        ;;
    '3')
        SQL_FILE=$(dirname $0)/T_TEKIYOURATE_JOUHOU_3.sql
        ;;
    *)
        echo "USAGE: insertT_TEKIYOURATE_JOUHOU.sh [1(8:00)|2(10:00)|3(15:00)]"
        exit 1
        ;;
esac


cat ${SQL_FILE} |sed "s/SYSTEMDATE/${SYSTEMDATE}/g" |while read SQL
do
   $(dirname $0)/executeSQL.sh "${SQL}"
done

exit 0

nicolaus

From nicolaus@localhost.localdomain  Sun Sep 30 08:00:01 2007
Return-Path: <nicolaus@localhost.localdomain>
Received: from localhost.localdomain (localhost.localdomain [127.0.0.1])
        by localhost.localdomain (8.13.1/8.13.1) with ESMTP id l8U001TL003940
        for <nicolaus@localhost.localdomain>; Sun, 30 Sep 2007 08:00:01 +0800
Received: (from nicolaus@localhost)
        by localhost.localdomain (8.13.1/8.13.1/Submit) id l8U001WT003798;
        Sun, 30 Sep 2007 08:00:01 +0800
Date: Sun, 30 Sep 2007 08:00:01 +0800
Message-Id: <200709300000.l8U001WT003798@localhost.localdomain>
From: root@localhost.localdomain (Cron Daemon)
To: nicolaus@localhost.localdomain
Subject: Cron <nicolaus@localhost> /home/nicolaus/shell/insertT_TEKIYOURATE_JOUHOU.sh 1
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <HOME=/home/nicolaus>
X-Cron-Env: <PATH=/usr/bin:/bin>
X-Cron-Env: <LOGNAME=nicolaus>
X-Cron-Env: <USER=nicolaus>

/home/nicolaus/shell/executeSQL.sh: line 7: /home/ora/oracle/product/10.1.0/Db_1: is a directory
SQL=Insert into T_TEKIYOURATE_JOUHOU ( TSUKA_KBN,TEKIYOU_KAISHI_YMDHMS,RATE_SHURUI_CD,TTM,TTS,TTB,USD_NAKANE )  VALUES ('001','20070930074056','1','118.48','119.48','117.48','118.48');
/home/nicolaus/shell/executeSQL.sh: line 17: sqlplus: command not found
/home/nicolaus/shell/executeSQL.sh: line 7: /home/ora/oracle/product/10.1.0/Db_1: is a directory
SQL=Insert into T_TEKIYOURATE_JOUHOU ( TSUKA_KBN,TEKIYOU_KAISHI_YMDHMS,RATE_SHURUI_CD,TTM,TTS,TTB,USD_NAKANE )  VALUES ('002','20070930074056','1','237.07','241.07','233.07','118.48');
/home/nicolaus/shell/executeSQL.sh: line 17: sqlplus: command not found
/home/nicolaus/shell/executeSQL.sh: line 7: /home/ora/oracle/product/10.1.0/Db_1: is a directory
SQL=Insert into T_TEKIYOURATE_JOUHOU ( TSUKA_KBN,TEKIYOU_KAISHI_YMDHMS,RATE_SHURUI_CD,TTM,TTS,TTB,USD_NAKANE )  VALUES ('004','20070930074056','1','104.4','106','102.8','118.48');
/home/nicolaus/shell/executeSQL.sh: line 17: sqlplus: command not found
/home/nicolaus/shell/executeSQL.sh: line 7: /home/ora/oracle/product/10.1.0/Db_1: is a directory
SQL=Insert into T_TEKIYOURATE_JOUHOU ( TSUKA_KBN,TEKIYOU_KAISHI_YMDHMS,RATE_SHURUI_CD,TTM,TTS,TTB,USD_NAKANE )  VALUES ('005','20070930074056','1','98.23','99.13','97.33','118.48');
/home/nicolaus/shell/executeSQL.sh: line 17: sqlplus: command not found
/home/nicolaus/shell/executeSQL.sh: line 7: /home/ora/oracle/product/10.1.0/Db_1: is a directory
SQL=Insert into T_TEKIYOURATE_JOUHOU ( TSUKA_KBN,TEKIYOU_KAISHI_YMDHMS,RATE_SHURUI_CD,TTM,TTS,TTB,USD_NAKANE )  VALUES ('020','20070930074056','1','161.32','162.82','159.82','118.48');
/home/nicolaus/shell/executeSQL.sh: line 17: sqlplus: command not found
/home/nicolaus/shell/executeSQL.sh: line 7: /home/ora/oracle/product/10.1.0/Db_1: is a directory
SQL=Insert into T_TEKIYOURATE_JOUHOU ( TSUKA_KBN,TEKIYOU_KAISHI_YMDHMS,RATE_SHURUI_CD,TTM,TTS,TTB,USD_NAKANE )  VALUES('061','20070930074056','1','98.46','100.46','96.46','118.48');
/home/nicolaus/shell/executeSQL.sh: line 17: sqlplus: command not found
/home/nicolaus/shell/executeSQL.sh: line 7: /home/ora/oracle/product/10.1.0/Db_1: is a directory
SQL=Insert into T_TEKIYOURATE_JOUHOU ( TSUKA_KBN,TEKIYOU_KAISHI_YMDHMS,RATE_SHURUI_CD,TTM,TTS,TTB,USD_NAKANE )  VALUES ('062','20070930074056','1','15.23','15.66','14.8','118.48');
/home/nicolaus/shell/executeSQL.sh: line 17: sqlplus: command not found
/home/nicolaus/shell/executeSQL.sh: line 7: /home/ora/oracle/product/10.1.0/Db_1: is a directory
SQL=Insert into T_TEKIYOURATE_JOUHOU ( TSUKA_KBN,TEKIYOU_KAISHI_YMDHMS,RATE_SHURUI_CD,TTM,TTS,TTB,USD_NAKANE )  VALUES ('074','20070930074056','1','87.21','89.21','85.21','118.48');
/home/nicolaus/shell/executeSQL.sh: line 17: sqlplus: command not found

liaosnet

用原来的shell
crontab改为

00 08 * * * su - <用户> -c  "/home/nicolaus/shell/insertT_TEKIYOURATE_JOUHOU.sh 1"  >/dev/null 2>&1
00 10 * * * su - <用户> -c  "/home/nicolaus/shell/insertT_TEKIYOURATE_JOUHOU.sh 2"  >/dev/null 2>&1
00 15 * * * su - <用户> -c "/home/nicolaus/shell/insertT_TEKIYOURATE_JOUHOU.sh 3"  >/dev/null 2>&1

[ 本帖最后由 liaosnet 于 2007-9-30 14:36 编辑 ]

dradhzn

#!/bin/bash

#Environmental parameters for Oracle Client
. /home/oracle/.profile

wmjie

#!/bin/bash

. /home/nicolaus/.profile

yuhe27913

3楼的方法也是可行的，root的crontab

springwind426

在脚本中设置一下PATH这个环境变量，上面的错误信息是说sqlplus没有找到