免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 568 | 回复: 0
打印 上一主题 下一主题

有关crontab的问题,大家快帮忙 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2005-04-19 16:17 |只看该作者 |倒序浏览
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--
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP