Cron export failing with no message file error 1

[dklloyd]

Hi
I've been thrown in the deep end with ORACLE and trying to put all the pieces together! I try to run an export via a cron but it fails with the following error:

Message 206 not found; No message file for product=RDBMS, facility=EXP: Release
8.1.6.0.0 - Production on Fri Mar 9 18:04:00 2001
(c) Copyright 1999 Oracle Corpor
Invalid format of Export utility name
Verify that ORACLE_HOME is properly set
Export terminated unsuccessfully
EXP-00000: Message 0 not found; No message file for product=RDBMS, facility=EXP

Below is the script that I have robbed from an example of a cron export file... can you see the obvious error???? I am running this from a userid that has no problems when export is done from the command line.

#!/bin/sh
HOME=/home/oracle
HZ=
LOGNAME=oracle
ORACLE_BASE=/rdbms/oracle
ORACLE_HOME=$ORACLE_BASE/product/8.1.6

PATH=$PATH:$ORACLE_HOME/bin
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
ORACLE_SID=CMAL
ORACLE_TERM=vt100
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
PATH=/rdbms/oracle/product/8.1.6/bin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin
TZ=GMT0BST,M3.5.0,M10.5.0
exportdir=/u01/export
file=$exportdir/exp_CMAL.dmp
logfile=$exportdir/exp_CMAL.log
mv -f $file $file.old
mv -f $logfile $logfile.old
exp system/xxxxx@CMAL file=$file log=$logfile full=y

 

[Nebuchednezzar]

Is the cron run under the oracle unix user, or another user (root, etc)?

Log in under the user whom the cron is launched under, and just try typing exp and hit enter.
Make sure that the exp executable itself is executing correctly.

If it isn't, it is probably a rights issue...

 

[DBAwhosaysNIE]

hey,

are you saying that the ABOVE SCRIPT runs fine from the command line or that you can MANUALLY RUN EXPORT from it? does the script work if run from a shell logged in as the user on whose crontab it is scheduled? if answer is yes then I'd suspect environmental problem. what I usually do (& this is treading on religous grounds is write a script to do a task (such as export, backup, etc) assuming my normal ksh environment (as defined in /home/<user>.profile) and then write/schedule a crontab wrapper which calls .profile and then the body. again, this is a philosophical/religous issue but it works well for me.

hope this helps & good luck!

 

[dklloyd]

I was running this as oracle user. I have taken your advise however and have preceded the oracle export command with the non terminal parts of the .profile script. I'm not sure if this is what you meant by wrapping the script but this has worked fine, so thanks out there!