Hello Gurus,

I've been tasked with solving a problem at my new job and I'm stumped. We've got a script that dynamically builds an oracle export parameter files and then runs export from the shell. it runs fine when using the shell, but will NOT run (fails in one spot everytime) when entered into crontab.

I have attached the script. It fails at line 94 every time (see below).

$ORACLE_HOME/bin/exp PARFILE=$ORACLE_SCRIPT/temp.sql

One thing that i've tried is to put direct paths to both the executable and parfile, but to no avail. I've got a feeling that it has to do with the environment variables, but I don't know for sure. I believe that this is running the KSH shell (but again i'm not sure). I just started here and this is my first adventure with AIX.

Any assistance with this will be great!

Thanks in advance,

Jeremy

Attached Files

ora_export_EMTLTD_FPLEFW.sh.txt (5.3 KB, 194 views)

It says that the Oracle home is not set, but i'm certain it is in the script! I will continue digging, but will still welcome any assistance!

----------------------------------------------------

Message 206 not found; No message file for product=RDBMS, facility=EXP: Release 10.2.0.2.0 - Production on Thu Oc
t 16 15:11:00 2008

Copyright (c) 1982, 2005, Orac

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