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 : 24-09-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-00710 : new tablespace name is the same as the old tablespace name
  • ora-13062 : topology IDs do not match in the feature table and the topology
  • ora-06019 : NETASY: invalid login (connect) string
  • ora-25231 : cannot dequeue because CONSUMER_NAME not specified
  • ora-33429 : (EIFMAKEF17) CAUTION: NTEXT expression will be exported with type TEXT.
  • ora-27453 : %s is an invalid job or program argument name.
  • ora-24392 : no connection pool to associate server handle
  • ora-01082 : 'row_locking = always' requires the transaction processing option
  • ora-28664 : a partitioned table may not be coalesced as a whole
  • ora-12078 : fast refresh of refresh group ID string failed
  • ora-07235 : slemcw: fwrite error.
  • ora-06256 : NETNTT: remote fork failed
  • ora-21700 : object does not exist or is marked for delete
  • ora-10576 : Give up restoring recovered datafiles to consistent state: some error occurred
  • ora-19683 : real and backup blocksize of file string are unequal
  • ora-32104 : cannot retrieve OCI error message
  • ora-19932 : control file is not clone or standby
  • ora-09271 : szlon: error verifying user name
  • ora-29536 : badly formed source: string
  • ora-31030 : Unable to retrieve XML document
  • ora-01596 : cannot specify system in string parameter
  • ora-28546 : connection initialization failed, probable Net8 admin error
  • ora-21780 : Maximum number of object durations exceeded.
  • ora-24028 : cannot create a reciever non-repudiable single consumer queue
  • ora-02768 : Maximum number of files is invalid
  • ora-36778 : (XSPGTRLOW) The amount of available temporary storage is still low. Free some temporary storage immediately. You can do so, for example, by UPDATING or DETACHING an analytic workspace.
  • ora-30108 : invalid positional parameter value 'string'
  • ora-02183 : valid options: ISOLATION_LEVEL { SERIALIZABLE | READ COMMITTED }
  • ora-24801 : illegal parameter value in OCI lob function
  • ora-13409 : null or invalid pyramidLevel parameter
  • 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.