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 : 28-05-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-14270 : table is not partitioned by Range or Hash or List method
  • ora-27064 : cannot perform async I/O to file
  • ora-36406 : (VCACHE00) 'number' is an invalid value for the VARCACHE option. The only permissible values are 'SESSION', 'VARIABLE', and 'NONE'.
  • ora-13186 : fixed tile size tessellation failed
  • ora-02437 : cannot validate (string.string) - primary key violated
  • ora-25102 : PARALLEL option can only be used with ALTER INDEX REBUILD
  • ora-27078 : unable to determine limit for open files
  • ora-36312 : (PHYS00) workspace object must be a dimension or dimensioned variable.
  • ora-19715 : invalid format string for generated name
  • ora-30938 : No prefix defined for namespace 'string' (particle string)
  • ora-14027 : only one PARTITION clause may be specified
  • ora-39122 : Unprivileged users may not perform string remappings.
  • ora-38416 : A stored attribute may not be longer then 300 characters.
  • ora-08457 : syntax error in SEPARATE CHARACTER option of SIGN clause
  • ora-01665 : control file is not a standby control file
  • ora-33447 : (ESDREAD16) Discarding compiled code for workspace object because workspace object and workspace object, which were partition-dependent when the code was compiled, are now not partition-dependent.
  • ora-06931 : CMX: error during read_properties for server
  • ora-38433 : index "string" could not be maintained due to "string"
  • ora-14640 : add/coalesce index partition operation is valid only for hash partitioned global indexes
  • ora-04054 : database link string does not exist
  • ora-28029 : could not authorize remote server for user string
  • ora-23322 : Privilege error accessing pipe
  • ora-15105 : missing or invalid FAILGROUP name
  • ora-31515 : CDC change source string already exists
  • ora-30449 : syntax error in parameter string
  • ora-09926 : Unable to set effective privilege set of the server
  • ora-13001 : dimensions mismatch error
  • ora-06574 : Function string references package state, cannot execute remotely
  • ora-15194 : Internal ASM-DB interaction testing event number 15194
  • ora-30017 : segment 'string' is not supported in string Undo Management mode
  • 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.