Error ORA-1034 returned instead of Connect to idle instance (Doc ID 2011188.1)

Last updated on MAY 18, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.
-bash-4.1$ sqlplus system@DEP2

SQL*Plus: Release 11.2.0.4.0 Production on Fri May 8 19:05:26 2015

Copyright (c) 1982, 2013, Oracle. All rights reserved.

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

Goal

Expect to have the following message when connecting to a RAC instance that's down:


Connected to an idle instance.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms