While trying to login in oracle database, after that ORA-29702 error 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=initDoyen.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 , 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.

Recent Posts

Start typing and press Enter to search