Indeed
On 2016-02-23 17:24:32, Nan Xiao wrote:
Hi Martijn,
So there is actually "no instance" for "idle instance", right?
Best Regards
Nan Xiao
On Tue, Feb 23, 2016 at 5:25 PM, Martijn Bos <maboc@xxxxxxxx> wrote:
Hi Nan Xiao,
This means there is no oracle to connect to.
You first have to start the instance : startup
Best Regards,
Martijn
On 2016-02-23 16:57:31, Nan Xiao wrote:
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
--
//www.freelists.org/webpage/oracle-l
--
Met vriendelijke groet,
Martijn Bos
+31 6 39477001
(Public pgp-key : http://maboc.nl/pubkey.maboc.asc)
Attachment:
signature.asc
Description: Digital signature