HI GURUS,

I HAVE NO PROBLEM TO SH A UNIX SHELL SCRIPT TO EXPORT AN ENTIRE VERSION OF MY ORACLE DATABASE. HOWEVER, I GOT AN ERROR TO CRON THE SAME SHELL SCRIPT TO AUTOMATE MY EXPORT DATABASE TASK.

CRON COMMAND:

0 6 * * 1-5 /usr/export/ORAEXP
***** ERROR MESSAGE BEGINs *********
Date: Sat, 11 Aug 2001 08:06:00 -0700 (PDT)

From: oracle
To: oracle
Subject: Output from "cron" command
Content-Type: text
Content-Length: 745
Your "cron" job on prod-sun

/usr/export/ORAEXP

produced the following output:

ORAEXP: prod export started.

ORAEXP: prod export started.

Message 206 not found; No message file for product=RDBMS, facility=EXP: Release 7.1.4.1.0 - Production on Sat Aug 11 08:05:00 2001


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-02701

EXP-00222: Message 222 not found; No message file for product=RDBMS, facility=EXP

EXP-00000: Message 0 not found; No message file for product=RDBMS, facility=EXP

ORAEXP: Export of prod failed.

ORAEXP: ORAEXP process aborting

ORAEXP: Export of prod failed.

ORAEXP: ORAEXP process aborting


********ERROR MESSAGE END *************




I ALSO COULD NOT CRON ANOTHER JOB WHICH DOES A FTP A EXPORT FILE TO ANOTHER SERVER, EVENTHOUGH I CAN RUN IT @ SHELL :
$sh /usr/bk/cold_bk

I HAVE A CORRECT PATH AND FILENAME. I EVEN RAN SUCCESSFULLY BY USING

$sh /usr/export/ftp_exp

the export_script is executable. It means:

$ls -l /usr/export/ftp_exp
-rwxr-xr-x /usr/export/ftp_exp

******error message **************
Date: Sat, 11 Aug 2001 08:46:00 -0700 (PDT)
From: oracle
To: oracle
Subject: Output from "cron" command
Content-Type: text
Content-Length: 130


Your "cron" job on prod-sun
/usr/export/ftp_exp
produced the following output:


sh: /usr/export/ftp_exp: not found

******error message end**************



Please advise what was missing. It would be appreciated very much.


Thanks