Skip to Main Content

Oracle Database Discussions

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!

Why is DataPump in 11g not smarter

rg2May 29 2009 — edited May 29 2009
I am trying to run several data pump jobs in my 3 node rac env. On node 1 I have 2 impdp jobs running, and I would like to run 1 or 2 more on nodes 2 and nodes 3.

so here its
$ impdp user/****** parfile=USER.par

Import: Release 11.1.0.7.0 - 64bit Production on Friday, 29 May, 2009 8:36:50

Copyright (c) 2003, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORA-31626: job does not exist
ORA-31637: cannot create job IMP_USER for user USER
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 736
ORA-39147: cannot migrate Data Pump queue table ownership to this instance


$ vi USER.par

DUMPFILE=USER.dmp
LOGFILE=imp_USER.log
DIRECTORY=DP_STAGING_DATA_01
TABLES=XYZ
CONTENT=DATA_ONLY
JOB_NAME=IMP_USER
DATA_OPTIONS=SKIP_CONSTRAINT_ERRORS

This is all I found online.
Oracle Error : ORA-39147: cannot migrate Data Pump queue table ownership to this instance
Cause: There are active Data Pump jobs running on another instance in a RAC. All concurrent, active Data Pump jobs must be run on the same instance.
Action: Start this job on the same instance where other active Data Pump jobs are running, or wait until they finish.

Anyone gotten around this?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 26 2009
Added on May 29 2009
4 comments
2,242 views