操作系统是linux(rhel4.8) +oracle10glinux系统下用户 oracle,下建立了一个脚本 expdb_phptest.sh
cat expdb_phptest.sh
#!/bin/sh
expdp phptest/php2009 directory=my_dir schemas=phptest dumpfile=p_$(date -d "today" +"%Y%m%d%H%M%S").dmp logfile=p_$(date -d "today" +"%Y%m%d%H%M%S").log job_name=expdb_phptest直接使用 expdb_phptest.sh脚本没有问题,但是我把这个脚本添加到
1 * * * * /home/oracle/shell/expdb_phptest.sh
结果报错,Subject: Cron <oracle@orc10g> /home/oracle/shell/expdb_phptest
Content-Type: text/plain; charset=UTF-8
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <HOME=/home/oracle>
X-Cron-Env: <PATH=/usr/bin:/bin>
X-Cron-Env: <LOGNAME=oracle>
X-Cron-Env: <USER=oracle>/home/oracle/shell/expdb_phptest: line 2: expdp: command not found不知道这个怎么解决?
cat expdb_phptest.sh
#!/bin/sh
expdp phptest/php2009 directory=my_dir schemas=phptest dumpfile=p_$(date -d "today" +"%Y%m%d%H%M%S").dmp logfile=p_$(date -d "today" +"%Y%m%d%H%M%S").log job_name=expdb_phptest直接使用 expdb_phptest.sh脚本没有问题,但是我把这个脚本添加到
1 * * * * /home/oracle/shell/expdb_phptest.sh
结果报错,Subject: Cron <oracle@orc10g> /home/oracle/shell/expdb_phptest
Content-Type: text/plain; charset=UTF-8
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <HOME=/home/oracle>
X-Cron-Env: <PATH=/usr/bin:/bin>
X-Cron-Env: <LOGNAME=oracle>
X-Cron-Env: <USER=oracle>/home/oracle/shell/expdb_phptest: line 2: expdp: command not found不知道这个怎么解决?
无/home/oracle/script目录
则新建该目录
mkdir /home/oracle/script
建立启动脚本
vi /home/oracle/script/backup.sh
脚本代码
#!/bin/sh
week=`date +%a`
echo $week
rm -fr /usr/local/oracle/backup/flhis/$week.dmp
#env--begin
export ORACLE_BASE=/usr/local/oracle
export ORACLE_HOME=/usr/local/oracle/product/10
export ORACLE_SID=fl
export ORACLE_TERM=xterm
export LD_ASSUME_KERNEL=2.6.18
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
LD_LIBRARY_PATH=.:$LD_LIBRARY_PATH:/usr/local/lib
export LD_LIBRARY_PATH
export PATH=.:$PATH:$ORACLE_HOME/bin
export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'
#env--end
exp flhis/flhis file=/usr/local/oracle/backup/flhis/$week.dmp owner=flhis