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 : 27-05-2017

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

  • ora-32740 : The requested operation cannot be proceeded
  • ora-15049 : diskgroup "string" contains string error(s)
  • ora-27054 : NFS file system where the file is created or resides is not mounted with correct options
  • ora-25106 : only one of PARALLEL or NOPARALLEL clause may be specified
  • ora-13387 : sdo_batch_size for array inserts should be in the range [number,number]
  • ora-27369 : job of type EXECUTABLE failed with exit code: string
  • ora-26535 : %ud byte row cache insufficient for table with rowsize=number
  • ora-04075 : invalid trigger action
  • ora-22130 : buffer size [string] is less than the required size [string]
  • ora-25134 : keyword TABLE expected
  • ora-31642 : the following SQL statement fails: string
  • ora-16238 : attempt to use version 9 log
  • ora-10647 : Tablespace other than SYSTEM, string, string not found in read only mode
  • ora-27141 : invalid process ID
  • ora-26017 : global indexes not allowed for direct path load of table partition string
  • ora-02199 : missing DATAFILE/TEMPFILE clause
  • ora-30990 : insufficient privileges to change owner of resource string
  • ora-13435 : GeoRaster metadata dimension inconsistent
  • ora-29806 : specified binding does not exist
  • ora-30455 : summary contains VARIANCE without corresponding SUM & COUNT
  • ora-06765 : TLI Driver: error awaiting orderly release
  • ora-12412 : policy package string is not installed
  • ora-31604 : invalid string parameter "string" for object type string in function string
  • ora-09340 : Specified ORACLE_SID is either invalid or too long
  • ora-12196 : TNS:received an error from TNS
  • ora-02094 : replication option not installed
  • ora-36861 : (XSTFRC01) SQL Cache ID parameter is invalid or missing.
  • ora-29702 : error occurred in Cluster Group Service operation
  • ora-09846 : soacon: ARCH unable to open named pipe.
  • ora-03113 : end-of-file on communication channel
  • 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.