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 : 29-04-2017

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

  • ora-27141 : invalid process ID
  • ora-13385 : error in network manager: [string]
  • ora-34021 : (MSCGADD04) You must specify a partition when maintaining PARTITION TEMPLATE workspace object.
  • ora-12555 : TNS:permission denied
  • ora-19282 : XQ0068 - It is a static error if a Prolog contains more than one xmlspace declaration
  • ora-32839 : property string is reserved, names with MGWPROP$_ prefix are not valid
  • ora-00381 : cannot use both new and old parameters for buffer cache size specification
  • ora-04031 : unable to allocate string bytes of shared memory ("string","string","string","string")
  • ora-16416 : Switchover target is not synchronized with the primary
  • ora-31099 : XDB Security Internal Error
  • ora-08186 : invalid timestamp specified
  • ora-25176 : storage specification not permitted for primary key
  • ora-00722 : Feature "string"
  • ora-01233 : file string is read only - cannot recover using backup control file
  • ora-19693 : backup piece string already included
  • ora-08322 : scnmin: open/convert of bias lock failed
  • ora-02430 : cannot enable constraint (string) - no such constraint
  • ora-31230 : DBMS_LDAP: unable to dynamically allocate additional memory
  • ora-12471 : Specified compartment or group is not authorized for user
  • ora-22317 : typecode number is not legal as a number type
  • ora-16401 : archivelog rejected by RFS
  • ora-12706 : this CREATE DATABASE character set is not allowed
  • ora-24030 : Only one of rule or rule-set must be specified
  • ora-24305 : bad bind or define context
  • ora-23445 : missing template site
  • ora-32034 : unsupported use of WITH clause
  • ora-19751 : could not create the change tracking file
  • ora-13432 : GeoRaster metadata blankCellValue error
  • ora-12333 : database (link name string) is not mounted
  • ora-22630 : attribute [string] is null or it is not well-formed
  • 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.