Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

STOPPED JOBS with expdp and dbms_scheduler

136452May 25 2006 — edited Jul 21 2007
Hello.

I am working with the 10g release 2 in a RAC enviroment, and i am trying to put an export job at the scheduler.

To launch the export i have make a shell script, then first exec the export process and after launch a bzip2 command to compress the resultant dmp file.

The problem is that the export process finish ok, but it don't compress the file, because the scheduler mark the job as STOPPED.

The log say:
REASON="Stop job with force called by user: 'SYS'"

and the expdp S.O process that launch the extjobo stay runing for ever, like if it was waiting for the expdp to exit and it can`t so the script never arrive to the part that compress the file.

I put the script that i make to export the schema:

#!/bin/bash

export ORACLE_HOME=/opt/oracle/product/10.2.0/db
export PATH=$PATH:$ORACLE_HOME/bin
export DIRBACK=/ORACLE/BACKUPS/BMR/Dumps
export dia=`date +%d_%m_%Y_%H_%M_%S`
export LOG=dump_backup_bmr_$dia.log

cd $DIRBACK

$ORACLE_HOME/bin/expdp userid=oracle_backup/orabck@BMR dumpfile="BMR_BMR_$dia.dmp" schemas=BMR directory=Dumps logfile=$LOG
cd $DIRBACK
/usr/bin/bzip2 -f --best ./BMR_BMR_$dia.dmp
cd $DIRBACK
/bin/mail -s "DUMP BACKUP BMR DIARIO [$dia]" vmalaga@prisacom.com < ./dump_backup_bmr_$dia.log
-----------------------------------------------------------------------------

I have put several cd $DIRBACK to see if it fail because the script don`t find the dmp file.
Any idea why it STOP after finish the script ?

PD: sorry for my poor english.

Regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 18 2007
Added on May 25 2006
3 comments
5,532 views