Re: ORA-01090: shutdown in progress - connection is not permitted

From: Mark D Powell <>
Date: Thu, 4 Jun 2009 09:12:04 -0700 (PDT)
Message-ID: <>

On Jun 4, 8:28 am, wrote:
> On Jun 4, 5:57 am, "Tomasz Zalewski" <> wrote:
> > Hi
> > After command shutdown immediate in sqlplus on database Oracle9i I look
> > error message:
> > SQL> ORA-24324: service handle not initialized
> > ORA-24323: value not allowed
> > ORA-01090: shutdown in progress - connection is not permitted
> > SQL> Disconnected
> > But in Enterprise Manager database shutdown and startup correctly.
> > What is these? Help!
> You can only issue 1 shutdown immediate at a time ... wait until the
> first one completes and the instance is back up before trying another
> one.
> I am really not a fan of using EM for a shutdown personally ...

John's basic point is correct. Once a shutdown is issued do not try to connect and issue any commands until the command completes. However, I think it is possible to generate "shutdown or statup in progress" type error messages by getting a new sysdba session and issueing commands other than another shutdown immediate. The one command you can issue when a shutdown is already in progress is "shutdown abort" in the case of a hung shutdown immedaite.

HTH -- Mark D Powell -- Received on Thu Jun 04 2009 - 11:12:04 CDT

Original text of this message