ORA-29376: number of consumer groups string in top-plan string exceeds string

Cause : Th enubmero f ocnsmuerg ropus ni teh sepciifedt opp-la nism or ethna 3.2

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

Chnaget het opp-la ntoh av enom or ethna 3 2cosnumre gorup.s

update : 28-05-2017
ORA-29376

ORA-29376 - number of consumer groups string in top-plan string exceeds string
ORA-29376 - number of consumer groups string in top-plan string exceeds string

  • ora-26519 : no memory available to allocate
  • ora-04046 : results of compilation are too large to support
  • ora-35578 : (SQLOUT11) SQL cursor 'number' cannot be used with CURRENT OF syntax
  • ora-06774 : TLI Driver: error sending break mode
  • ora-01213 : MAXINSTANCES may not exceed string
  • ora-13033 : Invalid data in the SDO_ELEM_INFO_ARRAY in SDO_GEOMETRY object
  • ora-09813 : Unable to get directory status
  • ora-16109 : failed to apply log data from previous primary
  • ora-37079 : (XSMCSESS07) Aggmap workspace object cannot be used for AGGREGATE.
  • ora-00210 : cannot open the specified control file
  • ora-27207 : syntax error in device PARMS - parentheses mismatch or missing
  • ora-30444 : rewrite terminated by the sql analyzer
  • ora-13755 : invalid "SQL Tuning Set" name
  • ora-19953 : database should not be open
  • ora-31687 : error creating worker process string with worker id string
  • ora-13341 : a line geometry has fewer than two coordinates
  • ora-27038 : created file already exists
  • ora-30952 : illegal configuration of HTTP/HTTPS in xdbconfig.xml
  • ora-30449 : syntax error in parameter string
  • ora-23385 : replication parallel push string argument not valid
  • ora-24238 : object settings argument passed to DBMS_UTILITY.INVALIDATE is not legal
  • ora-12433 : create trigger failed, policy not applied
  • ora-19955 : only one open thread is allowed to change the DBID
  • ora-13292 : incorrect ARC_TOLERANCE specification
  • ora-31636 : session is already attached to job string for user string
  • ora-01867 : the interval is invalid
  • ora-06555 : this name is currently reserved for use by user SYS
  • ora-16624 : broker protocol version mismatch detected
  • ora-19999 : skip_row procedure was called
  • ora-16950 : Remote mapped cursors are not supported by this feature.
  • 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.