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 <DWILLIAMS_at_LIFETOUCH.COM> 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_at_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_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
> 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_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
Received on Mon Mar 24 2003 - 03:12:08 CST