我试过脚本能执行,我把/home/oracle/.bash_profile中的环境变量也复制过去了,再执行计划任务也没用。
我的脚本是:
#!/bin/bash
PATH=$PATH:$HOME/bin
export PATH
ORACLE_HOME=/u01/data
export ORACLE_HOME
ORACLE_BASE=/u01
export ORACLE_BASE
PATH=$PATH:$ORACLE_HOME/bin
export PATH
cd $ORACLE_HOME
ORACLE_SID=custom
export ORACLE_SID
echo "================================="
#rm /u01/data/dmp/new01.dmp
#mv /u01/data/dmp/new.dmp /u01/data/dmp/new01.dmp
exp export/export inctype=complete file=/u01/data/dmp/new.dmp buffer=102400000 log=/u01/data/dmp/exp.log
echo "================================"
邮件中提示的错误:
From oracle@custom Thu Aug 11 17:37:01 2011
Return-Path:
Received: from custom (localhost.localdomain [127.0.0.1])
by custom (8.13.8/8.13.8) with ESMTP id p7B9b12Z027629
for ; Thu, 11 Aug 2011 17:37:01 +0800
Received: (from oracle@localhost)
by custom (8.13.8/8.13.8/Submit) id p7B9b1Ck027526;
Thu, 11 Aug 2011 17:37:01 +0800
Date: Thu, 11 Aug 2011 17:37:01 +0800
Message-Id: <201108110937.p7B9b1Ck027526@custom>
From: root@custom (Cron Daemon)
To: oracle@custom
Subject: Cron /u01/data/exp.sh
Content-Type: text/plain; charset=UTF-8
Auto-Submitted: auto-generated
X-Cron-Env:
X-Cron-Env:
X-Cron-Env:
X-Cron-Env:
X-Cron-Env:
=================================
/u01/data/exp.sh: line 21: exp: command not found
================================