Re: Try to set a oracle cron job on AIX 5.2

<philchan_at_rogers.com> wrote in message
news:1174336400.261141.70360_at_y66g2000hsf.googlegroups.com...
> Hi,
> I am trying to set up a cron job to backup my database daily, the
> following is my shell script, but it
> seems it would not run from the cron, but the manual run is fine, I
> don't know what is missing from my environment:
>
> ==================================
> #!/usr/bin/ksh
> #oracle daily backups
>
> export ORACLE_SID=MYPRD
> export ORACLE_HOME=/home/app/oracle/product/9.2.0
> export ORAENV_ASK=NO;
> . oraenv
>
> WORK_IDEN=/san01/pmmprd/alcprd/exp/exp_myprd_full
>
> exp system/manager file=$WORK_IDEN.dmp log=$WORK_IDEN.log full=y
> direct=y
> exp system/manager parfile=$WORK_IDEN.par
> ~
>
> ===============================================
>
> Any suggestion is appreciated.
>
> Philip
>

Do you have exp in your path ? Try to add export PATH=$PATH:$ORACLE_HOME/bin, or the full path to the exp executable.

Matthias Received on Mon Mar 19 2007 - 16:20:55 CDT