RE: shutdown immediate

From: <GKor_at_rdw.nl>
Date: Thu, 7 Dec 2000 09:43:10 +0100
Message-Id: <10703.123906@fatcity.com>

the database problably hangs because the oracle agent has to log out of = the
database.
the shutdown abort is then the trick, after that you must startup = restrict
so crash recovery can performed and the oracle agent can't come in at last with the normal shutdown you close the database gracefully. = Nothing
is wrong with this method i thought=20

> -----Oorspronkelijk bericht-----
> Van: Satar Naghshineh [SMTP:Satar.Naghshineh_at_irvine.mellesgriot.com]
> Verzonden: 6-dec-00 20:07
> Aan: Multiple recipients of list ORACLE-L
> Onderwerp: RE: shutdown immediate

>=20
> Why? are you doing a backup?=A0 "Shutdown abort" will do just fine. =
Then in
> your spare time, try to find out what was causing the database to =
hang
> while issuing the "shutdown immediate" command.

>=20

> Regards,
> Satar=20

>=20


> 	-----Original Message-----=20

> From:=A0=A0 GKor_at_rdw.nl [SMTP:GKor_at_rdw.nl]=20
> Sent:=A0=A0 Wednesday, December 06, 2000 11:22 AM=20
> To:=A0=A0=A0=A0 Multiple recipients of list ORACLE-L=20
> Subject:=A0=A0=A0=A0=A0=A0=A0 RE: shutdown immediate=20

>=20


> 	i think the method to use is=20

>=20


> 	shutdown abort=20

> startup restrict=20
> shutdown=20

>=20


> 	> -----Oorspronkelijk bericht-----=20

> > Van:=A0 Weerd Kirsten, E.C. de [SMTP:Kirsten.deWeerd_at_oranjewoud.nl] =

> > Verzonden:=A0=A0=A0 6-dec-00 11:36=20
> > Aan:=A0 Multiple recipients of list ORACLE-L=20
> > Onderwerp:=A0=A0=A0 RE: shutdown immediate=20
> >=20
> > I'm sorry, but I don't agree ...=20
> > If a shutdown immediate won't work, there is no point in trying a =
normal
>=20
> > shutdown ... The only solution left if you really want to DB =
brought
> down,=20
> > is a shutdown abort ...=20
> >=20
> > Greets,=20
> >=20
> > Kirsten=20
> >=20
> > > -----Original Message-----=20
> > >=20
> > > Hi.=20
> > >=20
> > > why not try the command "shutdown", that is better than an abort. =

> > > I know it doesn't answer your question, but before you start =
trying=20
> > > shutdown=20
> > > abort....=20
> > > The shutdown command will terminate the processes properly, not =
like=20
> > > shutdown abort.=20
> > >=20
> > > Thanks=20
> > >=20
> > > Clint=20
> > >=20
> > > -----Original Message-----=20
> > >=20
> > > Hi,=20
> > >=20
> > > =A0=A0=A0 I would definately check if one (or more) of Oracle's =
background=20
> > > processes is eating away CPU on the machine. As Satar Naghshineh=20
> > > suggested,=20
> > > Oracle is probably performing rollback or whatever ...=20
> > >=20
> > > =A0=A0=A0 Bare in mind though, a shutdown abort will bring the DB =
down, but=20
> > > after starting it, the background process will probably start=20
> > recovering.=20
> > > No=20
> > > tellin ghow long that will take. No real problem though, other =
users
> can=20
> > > just go to work, it might cause some performance-loss tho ...=20
> > >=20
> > > =A0=A0=A0 Greets,=20
> > >=20
> > > Kirsten=20
> > >=20
> > --=20
> > Please see the official ORACLE-L FAQ: <http://www.orafaq.com>=20
> > --=20
> > Author: Weerd Kirsten, E.C. de=20
> >=A0=A0 INET: Kirsten.deWeerd_at_Oranjewoud.nl=20
> >=20
> > Fat City Network Services=A0=A0=A0 -- (858) 538-5051=A0 FAX: (858) =
538-5051=20
> > San Diego, California=A0=A0=A0=A0=A0=A0=A0 -- Public Internet =
access / Mailing Lists=20
> > =

--------------------------------------------------------------------=20

> > To REMOVE yourself from this mailing list, send an E-Mail message=20
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in =

> > the message BODY, include a line containing: UNSUB ORACLE-L=20
> > (or the name of mailing list you want to be removed from).=A0 You =
may=20
> > also send the HELP command for other information (like =
subscribing).=20
> --=20
> Please see the official ORACLE-L FAQ: <http://www.orafaq.com>=20
> --=20
> Author:=20
> =A0 INET: GKor_at_rdw.nl=20

>=20
> Fat City Network Services=A0=A0=A0 -- (858) 538-5051=A0 FAX: (858) =
538-5051=20
> San Diego, California=A0=A0=A0=A0=A0=A0=A0 -- Public Internet access =
/ Mailing Lists=20
> --------------------------------------------------------------------=20
> To REMOVE yourself from this mailing list, send an E-Mail message=20
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in=20
> the message BODY, include a line containing: UNSUB ORACLE-L=20
> (or the name of mailing list you want to be removed from).=A0 You may =
Received on Thu Dec 07 2000 - 02:43:10 CST