What does "idle instance" mean when executing "sqlplus / as sysdba" command?

From: Nan Xiao <xiaonan830818_at_gmail.com>
Date: Tue, 23 Feb 2016 16:57:31 +0800
Message-ID: <CA+MhoaPQYagOeHsJxzk1WPJvy1xyqebEuDxGX4avhKoLN+0jyA_at_mail.gmail.com>



Hi all,

My Oracle SID environment is:

ORACLE_SID="ORCL5" When I didn't start ORCL5 instance, executing "sqlplus system/system" generated errors:

$ sqlplus system/system

SQL*Plus: Release 12.1.0.2.0 Production on Tue Feb 23 03:04:34 2016

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

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or directory Additional information: 3640
Additional information: 1813205355
Process ID: 0
Session ID: 0 Serial number: 0

While executing "sqlplus / as sysdba" prompts "Connected to an idle instance.":

$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Feb 23 03:04:55 2016

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

Connected to an idle instance.

SQL> I am a little confused of What the "idle instance" is here.

Could anyone help to explain it? Thanks very much in advance!

Best Regards
Nan Xiao

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 23 2016 - 09:57:31 CET

Original text of this message