Re: ORA-01090: shutdown in progress - connection is not permitted
Date: Thu, 4 Jun 2009 09:12:04 -0700 (PDT)
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
> 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