Re: Database wont shutdown?

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.
Received on Fri Oct 27 2000 - 12:40:06 CDT