ORA-29702: error occurred in Cluster Group Service operation

Cause : An unexpected error occurred while performing a CGS operation.

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

Verify that the LMON process is still active. Also, check the Oracle LMON trace files for errors.

update : 26-04-2017
ORA-29702

ORA-29702 - error occurred in Cluster Group Service operation
ORA-29702 - error occurred in Cluster Group Service operation

  • ora-15107 : missing or invalid ASM disk name
  • ora-06561 : given statement is not supported by package DBMS_SQL
  • ora-07628 : smsfre: sga not mapped
  • ora-09929 : GLB of two labels is invalid
  • ora-22283 : filename contains characters that refer to parent directory
  • ora-25437 : duplicate table value for table alias: string
  • ora-06571 : Function string does not guarantee not to update database
  • ora-39048 : Unable to start all workers; only string worker(s) available.
  • ora-19809 : limit exceeded for recovery files
  • ora-29395 : cannot set the initial consumer group to string
  • ora-07640 : smsget: SGA not yet valid. Initialization in progress
  • ora-02236 : invalid file name
  • ora-02302 : invalid or missing type name
  • ora-39079 : unable to enqueue message string
  • ora-06913 : CMX: error during redirection of connection
  • ora-25213 : message with specified RELATIVE_MSGID has been dequeued
  • ora-30961 : internal SQL statement is too long
  • ora-08261 : ora_addr: cannot find name in nameserver
  • ora-02194 : event specification syntax error string (minor error string) near 'string'
  • ora-16116 : no work available
  • ora-12326 : database string is closing immediately; no operations are permitted
  • ora-24904 : invalid callback attribute passed into OCI call
  • ora-32129 : cannot get information about this column
  • ora-25296 : Queue Table string has a buffered queue string
  • ora-16590 : Data Guard configuration does not contain a primary database
  • ora-29516 : Aurora assertion failure: string
  • ora-29256 : Cursor contains both regular and array defines which is illegal
  • ora-00298 : Missing or invalid attribute value
  • ora-19633 : control file record string is out of sync with recovery catalog
  • ora-37129 : (XSCCOMP04) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object. All static MODEL statements must precede all RELATION statements over the bases of the COMPRESSED COMPOSITE.
  • 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.