ORA-27101: shared memory realm does not exist

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

Cause: SGA is not allocated and instance is not started due to use the wrong oracle_sid and or oracle_home.

Action: use the following command on your sqlplus

set ORACLE_SID = grms

sqlplus /nolog

sql>conn system/manager as sysdba

sql>shutdown abort

sql>startup

---

Posted in: