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