shell script for auto export

Hello to All,

I wrote a unix shell script which can automatic export data from my oracle database server( Oracle enterprise 7.3.3).This shell script can be executed

by manual, but when I use "crontab" to auto the execution of this shell program
, it generated below error messages. Is there anyone can solve this problem
for me ?

< output >

Your "cron" job

/mnt/oracle/exp_backup/backup

produced the following output:

Message 206 not found; No message file for product=RDBMS, facility=EXP: Release9

Copyright (c) Oracle Corporatio
EXP-00008: Message 8 not found; No message file for product=RDBMS, facility=EXP
Error while trying to retrieve text for error ORA-12545 EXP-00222: Message 222 not found; No message file for product=RDBMS, facility=EP
EXP-00000: Message 0 not found; No message file for product=RDBMS, facility=EXPt
/mnt/oracle/exp_backup/export.out: No such file or directory
mv: cannot access /mnt/oracle/exp_backup/export.out.Z 01.25.99.export.Z: No such file or directory Interactive mode off.

< File name : backup >

#!/sbin/sh
cd /mnt/oracle/exp_backup
/mnt/oracle/product/7.3/bin/exp system/asetadmin<
/mnt/oracle/script/exp_response

mv /mnt/oracle/exp_backup/export.out /mnt/oracle/exp_backup/export.out compress /mnt/oracle/exp_backup/export.out mv /mnt/oracle/exp_backup/export.out.Z /mnt/oracle/exp_backup/`date +%m.%d.%y.export.Z`

< File name :exp_response >  

10240
/mnt/oracle/exp_backup/export.out

2
yes
yes
yes
wafer

Thanks in advance.

Regrads,
Stanley

Email Address: stanley_yeh_at_email.asetest.com.tw Telophone No: 886-7-3636663 ~ 1249 Received on Sun Jan 24 1999 - 21:13:41 CST