Re: "Thou shalt use 'Shutdown Abort' whenever you shutdown the database." Makes sense?
From: Miles Thomas <thomasm_at_"at".logica."dot".com>
Date: 1997/05/07
Message-ID: <01bc5aca$bf38de00$2d22ea9e_at_UKP01436.logica.co.uk>#1/1
> >
> > Nilo Segura Chinchilla * e-mail
> > nilo.segura_at_cern.ch
> > Computing and Network Division *
> > nilo_at_sundb02.cern.ch
> > European Laboratory for Particle Physics * phone +41 +22 7674943
> > Geneva - Switzerland *
> > *******************************************
> >
> > "I am the one who steps from the shadows" - John Constantine
> >
> >
> > --
> >
> >
> > Nilo Segura Chinchilla * e-mail
> > nilo.segura_at_cern.ch
> > Computing and Network Division *
> > nilo_at_sundb02.cern.ch
> > European Laboratory for Particle Physics * phone +41 +22 7674943
O yes, indeed, a Unix kill -9 does work, as long as you are not using the Multi-threaded server: in which case you have no background processes to kill, and can only use Oracle kill sessions.
Date: 1997/05/07
Message-ID: <01bc5aca$bf38de00$2d22ea9e_at_UKP01436.logica.co.uk>#1/1
Steve Phelan <stevep_at_pmcgettigan.demon.co.uk> wrote in article
<33702D30.D2B07040_at_pmcgettigan.demon.co.uk>...
> > yes, I fully agree, shutdown normal is useless, shutdown immediate
> > is not
> > reliable... shutdown abort is the only option that does the job...
> >
> > --
> >
> >
> > Nilo Segura Chinchilla * e-mail
> > nilo.segura_at_cern.ch
> > Computing and Network Division *
> > nilo_at_sundb02.cern.ch
> > European Laboratory for Particle Physics * phone +41 +22 7674943
> > Geneva - Switzerland *
> > *******************************************
> >
> > "I am the one who steps from the shadows" - John Constantine
> >
> >
> > --
> >
> >
> > Nilo Segura Chinchilla * e-mail
> > nilo.segura_at_cern.ch
> > Computing and Network Division *
> > nilo_at_sundb02.cern.ch
> > European Laboratory for Particle Physics * phone +41 +22 7674943
> > Sorry, I have to disagree here... :-) > > We have a shell script which fires of every night without problem to > perform our cold backups: It checks for connected Oracle sessions first, > and kills off (with the *UNIX kill* command, and *not an Oracle kill > session command*) any sessions it finds; it then pauses for 60 seconds, > then performs a shutdown immediate. This script has worked fine for 4 > years on two different sites, both of which were UNIX based (HP-UX and > AIX). > > Steve Phelan. > >
O yes, indeed, a Unix kill -9 does work, as long as you are not using the Multi-threaded server: in which case you have no background processes to kill, and can only use Oracle kill sessions.
Also, on non-unix platforms (NT especially), you can't see the background processes to kill them off. Again, the only solution is a Oracle kill sessions.
-- Miles Thomas Logica UK Ltd thomasm "at" logica "dot" com The above are personal opinions, and are not necessarily the opinions of my employer.Received on Wed May 07 1997 - 00:00:00 CEST