ORA-29395: cannot set the initial consumer group to string

Cause : An attempt was made to set the initial consumer group of a user 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 : 26-07-2017

ORA-29395 - cannot set the initial consumer group to string
ORA-29395 - cannot set the initial consumer group to string

  • ora-01204 : file number is string rather than string - wrong file
  • ora-01596 : cannot specify system in string parameter
  • ora-30483 : window functions are not allowed here
  • ora-02845 : Invalid value for the timing wanted flag
  • ora-19505 : failed to identify file "string"
  • ora-28111 : insufficient privilege to evaluate policy predicate
  • ora-24783 : Cannot switch non-migratable transactions
  • ora-12612 : TNS:connection is busy
  • ora-31700 : Very long string supplied for AUDIT_SYSLOG_LEVEL parameter
  • ora-37126 : (XSCCOMP01) The COMPRESSED COMPOSITE workspace object can only be used as a base of a single variable.
  • ora-01206 : file is not part of this database - wrong database id
  • ora-25307 : Enqueue rate too high, flow control enabled
  • ora-01325 : archive log mode must be enabled to build into the logstream
  • ora-12216 : TNS:poorly formed PREFERRED_CMANAGERS addresses in TNSNAV.ORA
  • ora-30060 : Internal event for RECO tracing
  • ora-37021 : (XSMULTI02) Object workspace object is not acquired.
  • ora-34481 : (MXMAINT07) You cannot string values of PARTITION TEMPLATE workspace object.
  • ora-32102 : invalid OCI handle
  • ora-27369 : job of type EXECUTABLE failed with exit code: string
  • ora-00116 : SERVICE_NAMES name is too long
  • ora-00097 : use of Oracle SQL feature not in SQL92 string Level
  • ora-26522 : rpc execution error
  • ora-03261 : the tablespace string has only one file
  • ora-26084 : direct path context already finished
  • ora-24147 : rule string.string does not exist
  • ora-37133 : (XSCCOMP08) You cannot write into an aggregated VARIABLE dimensioned by a COMPRESSED COMPOSITE. Use the CLEAR AGGREGATES command to reenable write access.
  • ora-06131 : NETTCP: user access denied
  • ora-28336 : cannot encrypt SYS owned objects
  • ora-16508 : channel handle not initialized
  • ora-01078 : failure in processing system parameters
  • 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.