Re: ORA-01090: shutdown in progress - connection is not permitted
From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Thu, 4 Jun 2009 09:12:04 -0700 (PDT)
Message-ID: <bfcbae1e-7c56-468f-a0f1-0703ea641fb7_at_l28g2000vba.googlegroups.com>
On Jun 4, 8:28 am, johnbhur..._at_sbcglobal.net wrote:
> On Jun 4, 5:57 am, "Tomasz Zalewski" <t..._at_mail.com> 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 ...
Date: Thu, 4 Jun 2009 09:12:04 -0700 (PDT)
Message-ID: <bfcbae1e-7c56-468f-a0f1-0703ea641fb7_at_l28g2000vba.googlegroups.com>
On Jun 4, 8:28 am, johnbhur..._at_sbcglobal.net wrote:
> On Jun 4, 5:57 am, "Tomasz Zalewski" <t..._at_mail.com> 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