Environment: AIX6.1, Oracle10.2.0.3
Create a single instance on a node of RAC and create it using DBCA. An error is reported when the configuration is complete.
Error: ORA-29702
Text: error occurred in Cluster Group Service operation Cause: An unexpected error occurred while refreshing a CGS operation.
Action: Verify that the LMON process is still active. Also, check the Oracle
LMON trace files for errors. Solution: Execute two Commands
Sfc3rc1:/apps/oracle/product/10.2.0/rdbms/lib $ make-f ins_rdbms.mk ops_off
Rm-f/apps/oracle/product/10.2.0/lib/libskgxp10.a
Cp/apps/oracle/product/10.2.0/lib // libskgxpd. a/apps/oracle/product/10.2.0/lib/libskgxp10.a
Rm-f/apps/oracle/product/10.2.0/lib/libskgxn2.a
Cp/apps/oracle/product/10.2.0/lib // libskgxns. a/apps/oracle/product/10.2.0/lib/libskgxn2.a
/Bin/ar-X64 d/apps/oracle/product/10.2.0/rdbms/lib/libknlopt. a kcsm. o
/Bin/ar-X64 cr/apps/oracle/product/10.2.0/rdbms/lib/libknlopt. a/apps/oracle/product/10.2.0/rdbms/lib/ksnkcs. o
Target "ops_off" is up to date.
Sfc3rc1:/apps/oracle/product/10.2.0/rdbms/lib $ make-f ins_rdbms.mk install
Chmod 755/apps/oracle/product/10.2.0/bin
Rm-f oracle dbv extends maxmem orapwd dbfsize cursize genoci extproc extproc32 extends dumpsga mapsga osh sbttest expdp impdp imp exp extends rman hsodbc extends nid extjob extjobo extends grdcscan/oracle/ product/10.2.0/rdbms/lib/ksms. s/apps/oracle/product/10.2.0/rdbms/lib/ksms. o
See metalink introduction AIX: ORA-29702 When Creating A Single Instance Database In A Clustered Environment [ID 198901.1]
Error: ORA-29702
Text: error occurred in Cluster Group Service operation
---------------------------------------------------------------------------
Cause: An unexpected error occurred while locking Ming a CGS operation.
Action: Verify that the LMON process is still active. Also, check the Oracle
LMON trace files for errors.
Solution Description
--------------------
1) reinstall Oracle software by de-selecting Oracle Parallel Server option.
2) deinstall Oracle Parallel Server option and relink oracle kernel.
It is possible to do it manually by entering the following commands:
Cd ORACLE_HOME/rdbms/lib
Make-f ins_rdbms.mk no_parropt or make-f ins_rdbms.mk ops_off
Make-f ins_rdbms.mk install
Explanation
-----------
High Availability Group Services (HAGS) is not configured.
When creating a single instance database in a clustered environment, if you
Have a cluster software installed, then OUI detects it and installoracle
Parallel Server option by default.