This is the post for the error “ORA-29702”.
ORA-29702: ERROR OCCURRED IN CLUSTER GROUP SERVICE OPERATION
Cause: An unexpected error occurred while performing a CGS operation.
Action: Verify that the LMON process is still active. Also, check the Oracle LMON trace files for errors.
#####################################################
ORA-29702: ERROR OCCURRED IN CLUSTER GROUP SERVICE OPERATION
#####################################################
Got the above error while starting up test instance in nomount from prod instance where as prod is a Cluster database.
-bash-3.2$ sqlplus "/as sysdba" SQL*Plus: Release 11.2.0.3.0 Production on Sun Feb 9 20:03:36 2014 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount; ORA-29702: error occurred in Cluster Group Service operation SQL> shut immediate; ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or directory SQL> exit
Solution:
-bash-3.2$ cd $ORACLE_HOME/rdbms/lib -bash-3.2$ make -f ins_rdbms.mk rac_off ioracle -bash-3.2$ make -f ins_rdbms.mk ioracle
Now try to start the database.
-bash-3.2$ sqlplus "/as sysdba" SQL*Plus: Release 11.2.0.3.0 Production on Sun Feb 9 20:10:48 2014 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount; ORACLE instance started. Total System Global Area 2137886720 bytes Fixed Size 2230072 bytes Variable Size 452987080 bytes Database Buffers 1660944384 bytes Redo Buffers 21725184 bytes SQL> exit
Stay tuned for More articles on Oracle RAC
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Telegram Channel : https://t.me/helporacle
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
