- 论坛徽章:
- 0
|
redhat linux as3
shell如下:
#!/bin/sh
echo '########################################################################'
year=$(awk '{print $1}' dat)
month=$(awk '{print $2}' dat)
day=$(awk '{print $3}' dat)
echo ORACLE_HOME is:
echo $ORACLE_HOME
echo ORACLE_SID is:
echo $ORACLE_SID
day=`expr $day - 1`
if [ $day -eq 0 ]; then
month=`expr $month - 1`
day=31
elif [ $month -eq 0 ]; then
year=`expr $year - 1`
month=12
fi
echo $year $month $day>;dat
cat dat
if [ $day -le 10 ]; then
day='0'$day
fi
if [ $month -le 10 ]; then
month='0'$month
fi
echo current exp is:
echo 'test'$year$month$day
echo '########################################################################'
echo start exp:
$ORACLE_HOME/bin/exp doc/doc@doc log=log/test1$year$month$day.log file=exp/test1$year$month$day tables=test1:test1$year$month$day
echo end exp.
用oracle用户直接执行oracle.sh正常
oracle用户:
crontab -e
添加
* * * * * /usr/local/software/temp/oracle.sh
出错如下:
Content-Type: message/rfc822
Return-Path: <oracle>;
Received: (from oracle@localhost)
by localhost.localdomain (8.12.11/8.12.11/Submit) id j3J820B2010002
for oracle; Tue, 19 Apr 2005 16:02:00 +0800
Date: Tue, 19 Apr 2005 16:02:00 +0800
Message-Id: <200504190802.j3J820B2010002@localhost.localdomain>;
From: root (Cron Daemon)
To: oracle
Subject: Cron <oracle@doclinux>; /usr/local/software/temp/oracle.sh
X-Cron-Env: <SHELL=/bin/sh>;
X-Cron-Env: <HOME=/home/oracle>;
X-Cron-Env: < ATH=/usr/bin:/bin>;
X-Cron-Env: <LOGNAME=oracle>;
########################################################################
ORACLE_HOME is:
ORACLE_SID is:
expr: syntax error
/usr/local/software/temp/oracle.sh: line 12: [: -eq: unary operator expected
/usr/local/software/temp/oracle.sh: line 15: [: -eq: unary operator expected
/usr/local/software/temp/oracle.sh: line 22: [: -le: unary operator expected
/usr/local/software/temp/oracle.sh: line 25: [: -le: unary operator expected
current exp is:
test
########################################################################
start exp:
/usr/local/software/temp/oracle.sh: line 32: /bin/exp: No such file or directory
end exp.
--j3J820B3010002.1113897721/localhost.localdomain-- |
|