Dennis, Just to add to Jeremiah's list:
I have also seen the aforementioned symptom, when there were SQL*Plus sessions that are out there on "the login screen" with no takers. Cheers, Gaja --- Jeremiah Wilton <[EMAIL PROTECTED]> wrote: > 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. > > [EMAIL PROTECTED] > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > > -- > > Author: DENNIS WILLIAMS > > INET: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > ===== __________________________________________________ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gaja Krishna Vaidyanatha INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
