ORA-29399: user string does not have privilege to switch to consumer group string

Cause : Ana ttmeptw asm ad etos ett hei niitalc onusme rgruop fo teh sepciifedu se rbu tth eusre deos ont ahvet hep riivleeg t oswticht o htatg ropu.

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

Grnat hte rpivlieg etos wicth ot teh cnosuemr rgou ptot heu se ran dthne ste teh iintila gorup.

update : 20-09-2017
ORA-29399

ORA-29399 - user string does not have privilege to switch to consumer group string
ORA-29399 - user string does not have privilege to switch to consumer group string

  • ora-01984 : invalid auditing option for procedures/packages/functions
  • ora-30749 : column string not enabled to store objects of type string.string
  • ora-19282 : XQ0068 - It is a static error if a Prolog contains more than one xmlspace declaration
  • ora-01626 : rollback segment number 'string' cannot handle more transactions
  • ora-32801 : invalid value string for string
  • ora-02848 : Asynchronous I/O package is not running
  • ora-19117 : invalid redefinition of predefined namespace prefix 'string'
  • ora-09759 : osnsbt: bad message received.
  • ora-19659 : incremental restore would advance file string past resetlogs
  • ora-38412 : Expression set column string does not exist.
  • ora-19564 : error occurred writing string bytes at block number string
  • ora-38708 : not enough space for first flashback database log file
  • ora-01411 : cannot store the length of column in the indicator
  • ora-06748 : TLI Driver: cannot allocate t_discon
  • ora-13031 : Invalid Gtype in the SDO_GEOMETRY object for point object
  • ora-03136 : inbound connection timed out
  • ora-16709 : standby archived log location settings conflict with flash recovery area
  • ora-01508 : cannot create database; error in file 'string' at line string
  • ora-38958 : Source platform string is in different byte order than target platform string
  • ora-27191 : sbtinfo2 returned error
  • ora-31465 : cannot obtain a lock on the subscription
  • ora-02851 : Request list is empty when it should not be
  • ora-39002 : invalid operation
  • ora-16501 : the Data Guard broker operation failed
  • ora-15033 : disk 'string' belongs to diskgroup "string"
  • ora-25246 : listen failed, the address string is an 8.0 style exception queue
  • ora-10633 : No space found in the segment
  • ora-40284 : model does not exist
  • ora-30767 : OID type mismatch
  • ora-04000 : the sum of PCTUSED and PCTFREE cannot exceed 100
  • 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.