RE: Shutdown immediate hangs

Hi

I've heared that another possible reason is the existence of "stuck" DBMS_JOB's tasks. Do you use DBMS_JOB ?

Ed

>
>
> Hi Marco,
>
> Please check up whether any of Long running query was
> running during that time.
> I so , shutdown immediare will wait until the query finishes.
> The best method is to use the folowing sequence fro shutting
> the database for
> backup.
>
> > shutdown abort;
> > startup restrict;
> >shutdown ; ( or shutdown immediate as you wish )
>
> Hope this helps.
> Regards,
>
> S Jayakumar
>
>
> "Rooy van, Marco" wrote:
>
> > Hi,
> >
> > Our environment is Alpha OpenVMS, Oracle 7.3.4 and we
> don't have Intelligent
> > Agent running.
> > One of the first things we do in our backup-job is a
> shutdown immediate.
> > When I arrived in the office this morning it was still
> doing an shutdown
> > immediate, normally it would finish this action 8 hours earlier.
> > Has any of you have had this problem before and is
> shutdown abort the best
> > action ?
> >
> > Best regards,
> >
> > Marco
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rooy van, Marco
> > INET: Rooy_M_at_sfs.nl
> >
> > 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: S Jayakumar
> INET: jaykumar_at_mahindrabt.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).
Received on Thu Oct 19 2000 - 03:20:26 CDT