ORA-29396: cannot switch group to string

Cause : An attempt was made to switch the consumer group of a user or a session to OTHER_GROUPS.

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

OTHER_GROUPS is for the resource manager's internal use. Specify another consumer group.

update : 21-08-2017
ORA-29396

ORA-29396 - cannot switch group to string
ORA-29396 - cannot switch group to string

  • ora-02302 : invalid or missing type name
  • ora-32625 : illegal dimension in cell reference predicate
  • ora-01981 : CASCADE CONSTRAINTS must be specified to perform this revoke
  • ora-38726 : Flashback database logging is not on.
  • ora-39777 : data saves are not allowed when loading lob columns
  • ora-29309 : export dump file was generated by different version of DBMS_PITR package
  • ora-14129 : INCLUDING INDEXES must be specified as tables have enabled UNIQUE constraints
  • ora-25314 : a commit-time queue table cannot be migrated to 8.0
  • ora-36833 : (XSLMGEN03) View token cannot be blank
  • ora-15029 : disk 'string' is already mounted by this instance
  • ora-06564 : object string does not exist
  • ora-12213 : TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA
  • ora-24385 : Application context size or index is not valid
  • ora-31403 : change table string already contains a column string
  • ora-37107 : (XSVPART07) Attempt to write to non-existent partition of workspace object.
  • ora-29261 : bad argument
  • ora-31231 : DBMS_LDAP: invalid PROPERTY_SET
  • ora-37122 : AW Session cache disabled
  • ora-01619 : thread string is mounted by another instance
  • ora-22305 : attribute/method/parameter "string" not found
  • ora-29318 : datafile string is online
  • ora-16702 : generic resource guard warning
  • ora-19283 : XQ0031 - It is a static error if the version number specified in a version declaration is not supported by the implementation.
  • ora-01352 : tablespace given for Logminer spill does not exist
  • ora-09930 : LUB of two labels is invalid
  • ora-30978 : The XML Index is not locally partitioned.
  • ora-39027 : wrong version of master table
  • ora-31007 : Attempted to delete non-empty container string/string
  • ora-24016 : cannot create QUEUE_TABLE, user string does not have execute privileges on QUEUE_PAYLOAD_TYPE string.string
  • ora-39710 : only connect AS SYSDBA is allowed when OPEN in UPGRADE 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.