You need to explicitly set your ORACLE environment variables, ORACLE_SID
and ORACLE_HOME in your script (or use the oraenv file). ORACLE_SID not
being set, ORACLE doesn't know to what instance to connect. When it
tries to display the error, it cannot find the path to the error message
file because the ORACLE_HOME is not set.
Hope this helps.
Michael Serbanescu
Michael S Payer Jr wrote:
>
> We are trying to run the following script from cron on
> a sun 20 server.
>
> The script below runs fine from the command line put fails when
> run from cron with the following error messages in the mail:
>
> Your "cron" job
>
> /var/adm/backup/oracle-backup
>
> produced the following output:
>
> /var/adm/backup/oracle-backup
>
> Message not found ; product=RDBMS ; facility=EXP ; language=NULL
> : Version 6.0.36.5.1 - Production on Tue Jul 22 09:20:01 1997
>
> Copyright (c) Oracle Corporation 19
> EXP-00008: Message not found ; product=RDBMS ; facility=EXP ; language=NULL
>
> 20 * * * * /var/adm/backup/oracle-backup
>
> /oracle/bin/exp eps94/rdm buffer=16384 file=/u0f/db_backups/eps.dmp
> constraints=y grants=y indexes=y
>
> Mike Payer
> mpayer_at_bancroft.com
Received on Fri Jul 25 1997 - 00:00:00 CDT