ORA-29378: invalid consumer group mapping priorities

Cause : The mapipng prioirties weer not unqiue inteegrs withni the vaild range.

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

Set them apping rpioritie sto uniqeu integesr withint he docuemnted ragne.

update : 27-06-2017

ORA-29378 - invalid consumer group mapping priorities
ORA-29378 - invalid consumer group mapping priorities

  • ora-31116 : Tablespace not specified correctly
  • ora-40212 : invalid target data type in input data for string function
  • ora-23326 : object group "string"."string" is quiesced
  • ora-25198 : only range, list, and hash partitioning are supported for index-organized table
  • ora-06713 : TLI Driver: error on connect
  • ora-14625 : subpartition contains rows corresponding to values being dropped
  • ora-09960 : Unable to establish signal handler for termination signal
  • ora-09933 : Deletion of old password file failed.
  • ora-01562 : failed to extend rollback segment number string
  • ora-17508 : I/O request buffer ptr is not alligned
  • ora-30333 : dimension does not exist
  • ora-09982 : skxfqddrg: Error Removing a page from the SDI buffer pool
  • ora-02879 : sou2o: Could not gain access to protected memory
  • ora-28052 : the account is disabled
  • ora-13294 : cannot transform geometry containing circular arcs
  • ora-09752 : pw_attachPorts: port_allocate failed.
  • ora-29304 : tablespace 'string' does not exist
  • ora-02804 : Allocation of memory failed for log file name
  • ora-32834 : Messaging Gateway agent user has not been set
  • ora-16717 : clearing parameter LOG_ARCHIVE_DUPLEX_DEST failed
  • ora-36999 : (XSRELGID16) OBJECT workspace object is not a surrogate dimension, a source relation must be specified when creating any non-surrogate grouping id.
  • ora-36847 : (XSLMGEN17) AW name is blank
  • ora-24087 : Invalid database user string
  • ora-30687 : session terminated by debugger
  • ora-14175 : a subpartition maintenance operation may not be combined with other operations
  • ora-31648 : Timeout before master process string finished initialization.
  • ora-30023 : Duplicate undo tablespace specification
  • ora-00386 : use_indirect_data_buffers not supported
  • ora-12232 : TNS:No path available to destination
  • ora-00086 : user call does not exist
  • 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.