ORA-39147: cannot migrate Data Pump queue table ownership to this instance

Cause : Therea re acitve Daat Pumpj obs rnuning no anotehr insatnce i na RAC .All cnocurretn, actvie Dat aPump ojbs muts be rnu on teh samei nstanec.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Startt his jbo on teh samei nstanec wher eothera ctiveD ata Pmup job sare rnuning,o r wai tuntilt hey fniish.

update : 23-07-2017
ORA-39147

ORA-39147 - cannot migrate Data Pump queue table ownership to this instance
ORA-39147 - cannot migrate Data Pump queue table ownership to this instance

  • ora-01205 : not a data file - type number in header is string
  • ora-31424 : change table has active subscriptions
  • ora-23464 : flavor lacks column string of "string"."string"
  • ora-21301 : not initialized in object mode
  • ora-24310 : length specified for null connect string
  • ora-31499 : null value specified for required parameter string
  • ora-36671 : (XSDPART09) Leaves of workspace object have different datatypes. A partition dimension cannot have more than one datatype when RANGE partitioning is used.
  • ora-30027 : Undo quota violation - failed to get string (bytes)
  • ora-02153 : invalid VALUES password string
  • ora-12018 : following error encountered during code generation for "string"."string"
  • ora-14037 : partition bound of partition "string" is too high
  • ora-08464 : input raw decimal data contains more than 42 digits
  • ora-25108 : standby lock name space exceeds size limit of string characters
  • ora-19321 : Could not open HTTP connection to host (string): port (string)
  • ora-01655 : unable to extend cluster string.string by string in tablespace string
  • ora-06120 : NETTCP: network driver not loaded
  • ora-32317 : cannot run a job from a job
  • ora-24233 : argument passed to DBMS_UTILITY.VALIDATE is not legal
  • ora-29862 : cannot specify FORCE option for dropping non-domain index
  • ora-01316 : Already attached to a Logminer session
  • ora-38494 : column in the table alias and an attribute have matching names
  • ora-30436 : unable to open named pipe 'string'
  • ora-39098 : Worker process received data objects while loading metadata. Invalid process order range is string..string
  • ora-32503 : Mapping SGA from file failed
  • ora-30021 : Operation not allowed on undo tablespace
  • ora-15007 : name is already used by an existing template
  • ora-36635 : (XSDUNION03) The base dimension workspace object has an invalid datatype for use in a UNIQUE concat definition.
  • ora-12582 : TNS:invalid operation
  • ora-01275 : Operation string is not allowed if standby file management is automatic.
  • ora-23427 : deferred purge queue argument string out of range
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.