ORA-29366: invalid CONSUMER_GROUP argument specified

Cause : An invalid consumer group name was specified.

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

Specify a non-NULL, valid consumer group name.

update : 22-07-2017
ORA-29366

ORA-29366 - invalid CONSUMER_GROUP argument specified
ORA-29366 - invalid CONSUMER_GROUP argument specified

  • ora-19331 : Last argument to CREATE_DBURI operator must be a column
  • ora-16608 : one or more databases have warnings
  • ora-16813 : log apply service not running on apply instance string recorded by the broker
  • ora-28153 : Invalid client initial role specified: 'string'
  • ora-13351 : two or more rings of a complex polygon overlap
  • ora-17506 : I/O Error Simulation
  • ora-00395 : online logs for the clone database must be renamed
  • ora-30011 : Error simulated: psite=string, ptype=string
  • ora-16718 : failed to locate database object
  • ora-25009 : Nested table clause allowed only for INSTEAD OF triggers
  • ora-06306 : IPA: Message write length error
  • ora-14406 : updated partition key is beyond highest legal partition key
  • ora-16767 : SQL Apply unexpectedly online
  • ora-01292 : no log file has been specified for the current LogMiner session
  • ora-01251 : Unknown File Header Version read for file number string
  • ora-36200 : (XSAGGR34) AGGREGATE operator string requires a WEIGHTBY clause, but ARGS variable workspace object did not specify one.
  • ora-37080 : Advice requested for hierarchy with too many levels
  • ora-36290 : (EIFMAKEF14) You cannot export object workspace object, because EIFVERSION is set to number. That version does not support dimensions of type NUMBER.
  • ora-10932 : trace name context forever
  • ora-31199 : Warning in processing file string
  • ora-12807 : process queue could not receive parallel query message
  • ora-16413 : Unsupported database type for ONDEMAND archivelog destinations
  • ora-12513 : TNS:service handler found but it has registered for a different protocol
  • ora-01041 : internal error. hostdef extension doesn't exist
  • ora-07206 : slgtd: gettimeofday error, unable to obtain time.
  • ora-27088 : unable to get file status
  • ora-16518 : unable to allocate virtual instance id
  • ora-36970 : (XSRELTBL12) workspace object must be a self-relation.
  • ora-16006 : audit_trail destination incompatible with database open mode
  • ora-15067 : command or option incompatible with diskgroup redundancy
  • 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.