Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Database wont shutdown?

Re: Database wont shutdown?

From: Heiko Onnebrink <Heiko.Onnebrink_at_t-online.de>
Date: Sat, 28 Oct 2000 22:15:21 +0200
Message-ID: <8tfd9a$l5r$00$1@news.t-online.com>

and last but not least

if you are running the Oracle Intelligent Agent stop him before you stop a database
normal or just shutdown immediate...

bye

HEIKO "Connor McDonald" <connor_mcdonald_at_yahoo.com> schrieb im Newsbeitrag news:39FACE35.6F1A_at_yahoo.com...
> 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
Received on Sat Oct 28 2000 - 15:15:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US