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

From: Powell, Mark <mark.powell2_at_hpe.com>
Date: Tue, 23 Feb 2016 14:27:52 +0000
Message-ID: <1E24812FBE5611419EFAFC488D7CCDD132AD2367_at_G9W0741.americas.hpqcorp.net>



Nan, the "connected to an idle instance" message just means your connection found the Oracle instance you tried to connect to is not running and the session is ready to issue the limited set of commands that can be applied in this situation such as startup.

You may want to reference the DBA Administration manual chapter on starting and stopping an Oracle instance http://docs.oracle.com/cd/E11882_01/server.112/e25494/start.htm#ADMIN004

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala Sent: Tuesday, February 23, 2016 6:48 AM To: oracle-l_at_freelists.org
Subject: Re: What does "idle instance" mean when executing "sqlplus / as sysdba" command?

On 2/23/2016 3:57 AM, Nan Xiao wrote:
> I am a little confused of What the "idle instance" is here.
>
> Could anyone help to explain it? Thanks very much in advance!
Idle instance is a devil's workshop! You should better start it with "startup" command.

--
--
Mladen Gogala
Oracle Consultant
http://mgogala.freehostia.com

DISCLAIMER: I am solely responsible for any opinion expressed in this email

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

i0zX+n{+i^ Received on Tue Feb 23 2016 - 15:27:52 CET

Original text of this message