RE: Shutdown Immediate hangs

Jeremiah, Gaja

   Thanks for the tips. My theory is that since 3 production instances were affected, it may be easy to find.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
From: Jeremiah Wilton [mailto:jwilton_at_speakeasy.net] Sent: Sunday, March 23, 2003 11:54 AM
To: Multiple recipients of list ORACLE-L Subject: Re: Shutdown Immediate hangs

1. Turn on PMON and SMON tracing for your instance and look at their trace files during shutdown
2. Look for segments of type TEMPORARY with many extents that need deallocating prior to shutdown - this will be done "lazily" during shutdwn immediate
3. Look for large transactions that need commit/rollback prior to shutdown
4. Look for which processes are still alive during the shutdown, use lsof to trace them back to the client app OR select a list of sessions and their respective processes prior to shutdown
5. Forget about shutdown immediate, use shutdown abort.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Sun, 23 Mar 2003, 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 

> 

> -- 

> Please see the official ORACLE-L FAQ: http://www.orafaq.net

> -- 

> Author: DENNIS WILLIAMS

>   INET: DWILLIAMS_at_LIFETOUCH.COM

> 

> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com

> San Diego, California        -- Mailing list and web hosting services

> ---------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message

> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> the message BODY, include a line containing: UNSUB ORACLE-L

> (or the name of mailing list you want to be removed from).  You may

> also send the HELP command for other information (like subscribing).

> 

> 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremiah Wilton
  INET: jwilton_at_speakeasy.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may