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: Shutdown Immediate hangs

Re: Shutdown Immediate hangs

From: Edward Shevtsov <ed.shevtsov_at_mail.ru>
Date: Mon, 24 Mar 2003 01:08:51 +0300
Message-Id: <24756.322829@fatcity.com>


DENNIS WILLIAMS wrote:
> We have been running Oracle 8.1.6 unchanged for several years. Within the
> past 3 days, our cold backup scripts have had a shutdown immediate hang. In
> the alert log the message is:
>
> Shutting down instance (immediate)
> Sun Mar 23 00:09:10 2003
> SHUTDOWN: waiting for active calls to complete.
>
> Normally the message is:
>
> Sun Mar 16 00:04:06 2003
> Shutting down instance (immediate)
> Sun Mar 16 00:05:11 2003
> ALTER DATABASE CLOSE NORMAL
>
> Our immediate suspicion is that someone has implemented an application this
> last week that connects to the database in a more active manner than we've
> experienced before. Does anyone have any idea what I should look for (aside
> from asking each developer: "What did you do last week?". Since 3 systems
> have been affected, we are wondering if a process using a database link
> could cause a problem like this. Any ideas appreciated.
>
>
>
> Dennis Williams
> DBA, 40%OCP, 100% DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>

Dennis,

check out if you had any active oracle jobs at the moment of shutdown. Sometimes they may be the cause of hang.

-- 
Received on Sun Mar 23 2003 - 16:08:51 CST

Original text of this message

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