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