ORA-27101: Shared memory realm does not exist

ORA-27101: Shared memory realm does not exist
Cause: Unable to locate shared memory realm
Action: Verify that the realm is accessible

Usually occurs when trying to start an instance and you do not have enough memory or your memory offset is not such that you can run a large SGA.

My work around on this problem

Cause 1)
This error occurs when Oracle Home is not set properly.
Solution)
Check the Oracle Home is set properly. Check the registry and your Oracle installation product have same path

Cause 2)
Error occurs when Oracle SID is not set properly.
Solution)
Check the Oracle SID is set properly. Compare the OracleServices property have the SID and the SID given in your registry both are same.
SID is case sensitive so be careful.

Cause 3)
Sometimes it may so happen that the drive (C: or D:) you have install the Oracle product/database have not define the virtual memory.
Solution)
It needed to define the virtual memory where you have installed the Oracle product/database.

Solution)
Another Solution is that change

SQLNET.AUTHENTICATION_SERVICES=(NTS)
to
SQLNET.AUTHENTICATION_SERVICES=(NONE)

In sqlnet.ora file and restart your database service.

Database of Life

Lazy DBA

Well come to the world of Lazy DBA.

A lazy dba is a SMART dba. A lazy dba is too lazy to look after databases manually , so they've written their own scripts, or bought a 3rd party piece of software in stead. A lazy dba doesn't want to be woken up in the middle of the night by any mobile call, so they proactively monitor their databases to make sure that there are no surprises. Remember, power steering was invented by a lazy engineer.