Re: Database wont shutdown?

Paul Bennett wrote:
>
> In article <972669635.13350.2.pluto.d4ee154e_at_news.demon.nl>,
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> > There are three flavors of shutdown :
> > normal
> > immediate
> > abort
> > The default is normal. A normal shutdown will wait until all connected
> > processes have disconnected (which may take forever, if someone goes
 on
> > holiday and doesn't disconnect)
> > Immediate will disconnect all processes gracefully, ie any outstanding
> > transactions will be rolled back.
> > Abort is comparable to turning the power switch.
> > In normal cases immediate is to be preferred, unless you take the
 database
> > down for upgrade, during which you shouldn't take any risk.
> > Issues like this are discussed in the Server Administrators Manual.
> >
> > Hth,
> >
> > Sybrand Bakker, Oracle DBA
> >
>
> Hi,
>
> Thanks, that's exactly what I beleived. However, there are (AFAIK) any
> other processes running on that instance. I've even tried stopping the
> listener before shutdown and it doesn't seem to make any difference. I
> only have an 8i set of manuals immediately available, but I'll continue
> to dig around and see whether I can find Oracle 7 manuals, and see what
> they have to say.
>
> In the interim, could anyone tell me a relatively simple and painless
> way to check what processes Oracle thinks are running? The only other
> two machines that even try to connect to this server were cleanly
> logged off and powered down.
>
> Thanks,
>
> ---
> Pb
> My opinions are my own and should not be taken as
> representing any other group or entity.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

A common strategy is to

• start process 'x' in the background ( see below)
• start a 'shutdown immediate'
• process 'x' waits 10 minutes and then sees if the db is still up, if it is, issue a shutdown abort.

In this way, you're giving the database the best chance possible to shutdown cleanly, but if it doesn't want to play ball...its toast!

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Early to bed and early to rise, 
 makes a man healthy, wealthy and wise." - some dead guy