Re: Database wont shutdown?

Sybrand Bakker 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
>
> "Paul Bennett" <spacey845_at_my-deja.com> wrote in message
> news:8tcb9p$sad$1_at_nnrp1.deja.com...
> >
> >
> > Hi,
> >
> > I have an Orace 7.3.4 database running on AIX 4.3.2
> >
> > I am connecting as 'internal' via svrmgrl.
> >
> > When I issue the 'shutdown' command, the database appears to hang.
> > I've left it (apparently) trying to shutdown for more than 24 hours to
> > no avail. I can ^C from the attempt and it gives the expected ORA-
> > 01013 message.
> >
> > The 'shutdown immediate' command appears to work fine.
> >
> > Could somebody give me some pointers to what might be wrong, or to
> > where I can look to try and find more information on the problem?
> >
> > 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.

Don't forget 'shutdown transactional'

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