Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: DATABASE HANGS WITH SHUTDOWN IMMEDIATE

Re: DATABASE HANGS WITH SHUTDOWN IMMEDIATE

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 27 Apr 2006 16:05:57 -0700
Message-ID: <bf46380604271605q55030d5g1c8e785ed351c98c@mail.gmail.com>


Please define what you consider a hang.

How long did wait for shutdown immediate?

If there are transactions running, it could take awhile.

10-15 minutes is not all that unusual if there are some long running transactions going on.

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist


On 4/27/06, Ahmed Ullah <ahmed107_at_yahoo.com> wrote:

>
> Hello all:
>
> We have Oracle 9.2.0.5 database ( single Note RAC ). There were some heavy
> batch jobs running which cuased the db hang ( only sys connection was
> working ).
>
> We tried to bring down the database after cleaning all sessions. It did
> not go down with SHUTDOWN IMMEDIATE. We had to abort it. I tried to bring
> down the DB three times with SHUTDOWN IMMEDIATE it never went down.
>
>
-- http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 27 2006 - 18:05:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US