// Oracle error reference

ORA-01034: ORACLE not available

The database instance isn't running, or you connected to a different instance than the one you meant. Start the instance or fix ORACLE_SID.

Error code
ORA-01034
Category
Connection and login
Error message
ORACLE not available

What it means

ORA-01034 means the session reached no running instance. It often appears together with ORA-27101 (shared memory realm does not exist) on a local connection, which tells you the instance's memory isn't there because it isn't started.

Newer releases word it as The Oracle instance is not available for use. Start the instance.

Common causes

  • The instance is shut down, or failed to start.
  • ORACLE_SID (or ORACLE_HOME) in your environment points at a different instance.
  • The listener has a static registration for an instance that isn't running.

How to fix it

  1. Check ORACLE_SID and ORACLE_HOME, then connect as SYSDBA and start the instance.

    -- sqlplus / as sysdba
    STARTUP;
  2. If startup fails, read the alert log for the reason (parameter file, memory, missing files).

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.