// Oracle error reference

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
Error message
shared memory realm does not exist

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_SID is wrong or in the wrong case (it is case-sensitive on Linux and Unix).
  • ORACLE_HOME differs from the one the instance was started from.

How to fix it

  1. Check the environment: echo $ORACLE_SID $ORACLE_HOME on Linux, and compare with the running instance (ps -ef | grep pmon).

  2. Start the instance if it is down.

    -- sqlplus / as sysdba
    STARTUP;

Related errors

More connection and login errors

The code and message text are from the Oracle Database Error Help. Browse the full Oracle error list or search every database error.

// fewer errors, faster fixes

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.