Shulou(Shulou.com)06/01 Report--

When using exp to back up the database on the backup server, there is no problem when you use the / bin/sh call directly on oracle, but when you put it into the scheduled task call, you report "Export terminated successfully with warnings".

/ opt/ora11/product/11.2/bin/exp test/test@192.168.0.31:1521/orcl file=/backup/bak/ `date'+% Y% m% d% H% M``. Dmp owner=zbxbid log=/backup/bak/backlog_exp_ `date'+% Y% m% d% H% M``. Log

The content is the same before and after, except that the error is reported in the planned task, and it is puzzled. Finally, it is found that the environment variable of oracle is not called in the script. The definition file in the environment variable of oracle. The settings in bash_profile are written in the script, and the problem is solved immediately. The variables are similar to the following:

Export PATHexport ORACLE_BASE=/opt/ora11export ORACLE_HOME=$ORACLE_BASE/product/11.2#export LANG=zh_CN.GB18030export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/bin:$PATHexport ORACLE_SID=orclexport ORACLE_OWNER=oracleexport ORACLE_TERM=vt100export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATHexport NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.