Introduction:-
In this article, we will fix ORA 29702 error occurred in Cluster Group Service operation. After resolve this error we will able to login in database successfully.
While trying to login in oracle database, after that ORA 29702 error occurred coming.
$sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 10 10:29:23 2021
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup pfile=initPHASE2.ora
ORA-29702: error occurred in Cluster Group Service operation
SQL>
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>
To resolve this error ORA 29702 error occurred , need to be do the same as below.
Solution:-
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk rac_off ioracle
make -f ins_rdbms.mk ioracle
Check it now, able to login successfully.
sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 10 10:34:28 2021
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 2137886720 bytes
Fixed Size 2254952 bytes
Variable Size 553650072 bytes
Database Buffers 1560281088 bytes
Redo Buffers 21700608 bytes
Database mounted.
Database opened.
I believe after following the above solution, your issue got resolve, click here for another interesting post.
For same issue, you may check here to investigate more the ongoing issue.