DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, June 20, 2017

ORA-29702: ERROR OCCURRED IN CLUSTER GROUP                                            SERVICE OPERATION




While starting the RAC instance , after changing the hostname in cluster nodes.

Error:

ora-29702 error occurred in cluster group service operation startup

sqlplus “/as sysdba”
SQL*Plus: Release 10.2.0.4.0 – Production on Sat Oct 8 08:03:07 2011
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup nomount;
ORA-29702: error occurred in Cluster Group Service operation
SQL>

Findings :

1) As it is cluster nodes database , cross-checked the cluster parameters like cluster_interconnect,no of threads,cluster_dataabase etc.
2) Cross-checked the all cluster nodes are pinned to the cluster group.


Solution:

Here one node has not been pinned to the cluster group .

[oracle@ordbtest2 bin]$ ./olsnodes -s -t

ordbtest1        Active  unpinned
ordbtest2        Active  pinned
ordbtest3        Active  pinned


So we have to pin the node from the available nodes either ordbtst2 or ordbtest3.

[root@ordbtest2 bin]# ./crsctl pin css -n ordbtest1
CRS-4664: Node ordbtest1 successfully pinned.


And now startup the database , it will start without any error.



No comments: