ORA-27101: shared memory realm does not exist
A local connection found no shared memory for the instance named by ORACLE_SID: the instance isn't started, or ORACLE_SID or ORACLE_HOME is wrong.
- Error code
ORA-27101- Category
- Connection and login
What it means
On a local (bequeath) connection, the client attaches to the instance's shared memory directly. ORA-27101 means there is no shared memory for the instance named by ORACLE_SID in that ORACLE_HOME. It usually comes paired with ORA-01034.
Common causes
- The instance isn't running.
ORACLE_SIDis wrong or in the wrong case (it is case-sensitive on Linux and Unix).ORACLE_HOMEdiffers from the one the instance was started from.
How to fix it
-
Check the environment:
echo $ORACLE_SID $ORACLE_HOMEon Linux, and compare with the running instance (ps -ef | grep pmon). -
Start the instance if it is down.
-- sqlplus / as sysdba STARTUP;
Related errors
More connection and login errors
ORA-01017invalid username/password; logon deniedORA-12154TNS: could not resolve the connect identifierORA-12514TNS: listener doesn't know the requested serviceORA-12505TNS: listener doesn't know the SIDORA-12541TNS: no listenerORA-12170TNS: connect timeout occurredORA-03113end-of-file on communication channelORA-03135connection lost contact
The code and message text are from the Oracle Database Error Help. Browse the full Oracle error list or search every database error.
Work on Oracle in SQLly
A native SQL client for macOS, Windows and Linux with schema-aware IntelliSense, guardrails for risky statements and clear error messages, for Oracle and the other databases you use.