Do you have any DBMS_JOBS running. We have Q-Diagnostics and experience
the same thing you do if I forget to stop the job.
............................................................................
.................................
Rich Gesler - <>< Saved By Grace
Database Administrator office: 336 878-7268
LifeStyle Furnishings International fax : 336 878-7038
............................................................................
.................................
Forgive them all - let God sort it out.
> -----Original Message-----
> From: Joan Hsieh [SMTP:jhsieh_at_infonet.tufts.edu]
> Sent: Friday, May 19, 2000 10:28 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: shutdown hang
>
> Winnie,
>
> I did shutdown abort and startup (took 20 min.) What concerns me is
> after startup, I did shutdown immediate again. It hangs (more than one
> hour and didn't comeback) NOBODY on the system. My question is the first
> startup should clean up everything, why shutdown immediate hangs after?
>
> Thanks,
>
> Joan
>
> ORACLE-L_at_fatcity.com wrote:
> >
> > It is perfectly normal. But if I were you, I will shutdown abort and
> > startup again (oracle is actually cleaning up the processes in the
> > background, they are doing the same job as if you issue the shutdown
> > immediate). At least the database is up and running while Oracle did the
> > cleaning.
> >
> > My worst nightmare is to wait for 14 hours for it to get cleaned up.
> >
> > Winnie
> >
> > Joan Hsieh <jhsieh_at_infonet.tufts.edu> on 05/18/2000 02:19:39 PM
> >
> > Please respond to ORACLE-L_at_fatcity.com
> >
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > cc: (bcc: Winnie Liu/HQ/ISC)
> >
> > Hi List,
> >
> > One of the developers deleted more than 120,000 rows on a small
> > database. In the middle of the session, he killed the process.(because
> > hang) I did shutdown abort and startup again (waited a while whitout
> > problem) and want to shutdown immediate and startup over again. This
> > time shutdown immediate hangs. Is this normal (waiting rollback)? I've
> > been hang here for over one hours now.
> >
> > Thanks in advance,
> >
> > Joan
> > --
> > Author: Joan Hsieh
> > INET: jhsieh_at_infonet.tufts.edu
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > 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).
> >
> > --
> > Author:
> > INET: Winnie_Liu_at_infonet.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > 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).
> --
> Author: Joan Hsieh
> INET: jhsieh_at_infonet.tufts.edu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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 Fri May 19 2000 - 10:29:46 CDT
