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

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_at_maboc.nl> 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
> >> --
> >> http://www.freelists.org/webpage/oracle-l
> >>
> >>
> >
> > --
> > Met vriendelijke groet,
> >
> > Martijn Bos
> > +31 6 39477001
> >
> > (Public pgp-key : http://maboc.nl/pubkey.maboc.asc)

-- 
Met vriendelijke groet,

Martijn Bos
+31 6 39477001

(Public pgp-key : http://maboc.nl/pubkey.maboc.asc)




--
http://www.freelists.org/webpage/oracle-l