Re: Oracle hangs while shutdown immediate

Anton Dischner wrote:
>
> Hi,
>
> every week we do a nightly switch over between our master/slave
> configuration via an automated script.
>
> Sometimes the shutdown immediate hangs for no reason without any
> log-entries.
>
> I believe this is a bug but. Patching from 8.1.7 to 8.1.7.4 didn't
> change the behaviour.
>
> shutdown abort is a solution but not a good one.
>
> Any more ideas?
>
> SuSE 7.1, kernel 2.2.18-SMP, 4 * Xeon, 2GB main memory
> all programs stopped at this time.
>
> PS: I followed the shutdown from root user discussion ;-)

Try:

alter system checkpoint;
shutdown abort

if you're paranoid, add a:

startup restrict
shutdown immediate

after them

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"