定时器执行脚本后的结果和手工执行脚本的结果不一样？

hehawk

为什么定时器执行脚本后的结果和手工执行脚本的结果不一样啊？
奇怪！都是同一个脚本！！

定时器如下：
$ crontab -l

40 23 * * * /backup/bi/bi_day.sh

脚本如下：
#环境定义
SHLIB_PATH=/usr2/oracle/app/product/8.0.5/lib
PATH=/usr/bin:/usr2/oracle/app/product/8.0.5/bin:
NLS_LANG=american_america.zhs16cgb231280
ORACLE_BASE=/usr2/oracle/app
ORACLE_SID=ora7
SHELL=/usr/bin/sh
ORACLE_TERM=hp
HOME=/home/oracle
TERM=vt100
ORACLE_HOME=/usr2/oracle/app/product/8.0.5
i_path=/backup/bi

#执行抽取数据存储过程
echo "
exec Proc_97channel_Daytongji('$i_path','0');
exit; " > Proc_97channel_Daytongji.sql

sqlplus -S username/passwd @Proc_97channel_Daytongji.sql

#传送经营分析数据
echo 'prompt off' >biftp
echo 'open 10.88.88.7' >>biftp
s0Aecho 'user username/passwd '>>biftp
echo 'binary' >>biftp
echo 'lcd /backup/bi' >>biftp
echo 'cd /exchange/telejyfx/97xt/send' >>biftp
echo 'delete *' >>biftp
echo 'mput Puserfunctiondev_day*.732.txt' >>biftp
echo 'mput Puserdev*.732.txt' >>biftp

ftp -n < biftp

ln_day=`date +"%y%m%d"`
ln_day=20${ln_day}
cd /backup/bi
rm -rf bak_bi_${ln_day}
mkdir bak_bi_${ln_day}
mv /backup/bi/Puserfunctiondev_day*.732.txt Puserdev*.732.txt /backup/bi/bak_b}
rm biftp Proc_97channel_Daytongji.sql

手工执行存储过程能产生数据文本文件，传送并在备份成功；而定时器执行的话目录中就为空的。真是奇怪哦？能帮忙分析下吗？ 感谢啊！！

ZealeS

看mail里面的出错信息。
有没有export

hehawk

555 555 痛苦 /backup/bi/bi_day.sh[19]: 27363 Abort(coredump)

/usr/lib/dld.sl: Can't open shared library: /project/805/src/lib//libclntsh.sl
/usr/lib/dld.sl: No such file or directory
/backup/bi/bi_day.sh[19]: 27363 Abort(coredump)
Interactive mode off.
Local directory now /backup/bi
*: No such file or directory.
mv: /backup/bi/Puserfunctiondev_day*.732.txt: cannot access: No such file or dir
ectory
mv: Puserdev*.732.txt: cannot access: No such file or directory
rm: biftp non-existent
rm: Proc_97channel_Daytongji.sql non-existent

hehawk

/usr/lib/dld.sl: Can't open shared library: /project/805/src/lib//libclntsh.sl
/usr/lib/dld.sl: No such file or directory
/backup/bi/bi_day.sh[19]: 29068 Abort(coredump)

hehawk

改写在ROOT里面就好了
su - oracle -c /backup/bi/bi_mon.sh

zhb01

把你的用户的shell的环境变量在sh中引用进来
例： .~/.bash.profile