-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|