ORA-29702:error occurred in Cluster Group Service operation错误解决

ORA-29702:error occurred in Cluster Group Service operation错误解决

 

一. 故障描述

笔者尝试通过手工建立单实例DB的方法,启动数据库实例到nomount状态时,报错:

SQL> startup nomount;

ORA-29702: error occurred in Cluster Group Service operation

无法进行下面的数据库创建工作.

 

在metalink上搜索了ORA-29702,找到了一个非常有价值的文章,内容如下:

Starting Instance Fails with ORA-29702 [ID 216030.1]

修改时间 16-SEP-2010 类型 PROBLEM 状态 PUBLISHED

fact: Oracle Server Enterprise Edition 8

fact: Oracle Parallel Server (OPS)

fact: AIX-Based Systems

symptom: Starting database fails

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

symptom: Mounting database in Non-OPS (exclusive) mode

symptom: Environment not configured for OPS

cause: Oracle in IBM RS6000 SP installs the Parallel Server Option as the

default option. As a result, Oracle tries to communicate with GMS or Cluster

Manager during startup, but the environment is not configured to work in

Parallel Server mode.

 

fix:

Relink Oracle to disable Parallel Server Option:

$ cd $ORACLE_HOME/rdbms/lib

$ make -f ins_rdbms.mk no_parropt

$ make -f ins_rdbms.mk install

 

这个文档说的情况与本问题的情况吻合,需要解决的问题就是取消并行模式(创建单节点DB,而非RAC DB).

 

 

三. 解决方法

执行metalink文档中的fix的命令，取消并行服务器模式。

 

$ cd $ORACLE_HOME/rdbms/lib

$ make -f ins_rdbms.mk no_parropt

rm -f /oracle/product/10.2.0/db/lib/libskgxp10.a

cp /oracle/product/10.2.0/db/lib//libskgxpd.a /oracle/product/10.2.0/db/lib/libskgxp10.a

rm -f /oracle/product/10.2.0/db/lib/libskgxn2.a

cp /oracle/product/10.2.0/db/lib//libskgxns.a /oracle/product/10.2.0/db/lib/libskgxn2.a

/bin/ar -X64 d /oracle/product/10.2.0/db/rdbms/lib/libknlopt.a kcsm.o

/bin/ar -X64 cr /oracle/product/10.2.0/db/rdbms/lib/libknlopt.a /oracle/product/10.2.0/db/rdbms/lib/ksnkcs.o

Target "no_parropt" is up to date.

 

$ make -f ins_rdbms.mk install

chmod 755 /oracle/product/10.2.0/db/bin

rm -f oracle dbv tstshm maxmem orapwd dbfsize cursize genoci extproc extproc32 hsalloci hsots hsdepxa dgmgrl dumpsga mapsga osh sbttest expdp impdp imp exp sqlldr rman hsodbc tg4sybs nid extjob extjobo genezi ikfod grdcscan /oracle/product/10.2.0/db/rdbms/lib/ksms.s /oracle/product/10.2.0/db/rdbms/lib/ksms.o

- Linking DB*Verify utility (dbv)

 

……

 

/bin/ar -X64 t /oracle/product/10.2.0/db/rdbms/lib/libknlopt.a | grep '^'kcsm.o > /dev/null 2>&1 ; then echo "-lha_gs_r -lha_em_r -lpthreads"; fi` -locijdbcst10 -lwwg -bpT:0x100000000 -bpD:0x110000000 -bforceimprw

mv -f /oracle/product/10.2.0/db/bin/oracle /oracle/product/10.2.0/db/bin/oracleO

mv /oracle/product/10.2.0/db/rdbms/lib/oracle /oracle/product/10.2.0/db/bin/oracle

chmod 6751 /oracle/product/10.2.0/db/bin/oracle

Target "install" is up to date.

 

 

SQL> startup nomount;

ORACLE instance started.

 

Total System Global Area 1073741824 bytes

Fixed Size 2101912 bytes

Variable Size 545262952 bytes

Database Buffers 524288000 bytes

Redo Buffers 2088960 bytes