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=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 , 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.
No comments:
Post a Comment
Thanks for reading till end. I hope this will help you more to improve your knowledge.
Now it's your turn!
What do you think? Share your experience in the comments box and subscribe for more interesting post.