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 execute these commands before 'shutdown immediate':

SVRMGR>ALTER SYSTEM SET log_archive_max_processes=10;
SVRMGR>alter system archive log stop;
SVRMGR>ALTER SYSTEM SET log_archive_max_processes=1;
SVRMGR>alter system archive log start;

If these commands will help, read Note:131571.1 on metalink for explanation.

--
   WBR, Serge Lisin