Message-Id: <24765.322882@fatcity.com> From: Hemant K Chitale Date: Mon, 24 Mar 2003 17:12:08 +0800 (SGT) Subject: RE: Shutdown Immediate hangs Check if you have JOB_QUEUE_PROCESSES > 0 and the schedules for jobs in DBA_JOBS. A running job will prevent a shutdown. Hemant --- DENNIS WILLIAMS wrote: > 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@lifetouch.com > > > -----Original Message----- > Sent: Sunday, March 23, 2003 11:54 AM > To: Multiple recipients of list ORACLE-L > > > 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@lifetouch.com > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: DENNIS WILLIAMS > > INET: DWILLIAMS@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@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@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@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: DENNIS WILLIAMS > INET: DWILLIAMS@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@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