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
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(orORACLE_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
-
Check
ORACLE_SIDandORACLE_HOME, then connect as SYSDBA and start the instance.-- sqlplus / as sysdba STARTUP;
-
If startup fails, read the alert log for the reason (parameter file, memory, missing files).
Related errors
ORA-27101shared memory realm does not existORA-12514TNS: listener doesn't know the requested serviceORA-12505TNS: listener doesn't know the SID
More connection and login errors
ORA-01017invalid username/password; logon deniedORA-12154TNS: could not resolve the connect identifierORA-12541TNS: no listenerORA-12170TNS: connect timeout occurredORA-03113end-of-file on communication channelORA-03135connection lost contactORA-28000the account is lockedORA-28001the password has expired
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.