Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Script to kill all user sessions before shutdown immediate
Some of my thoughts are:-
1) The final shutdown before an offline {cold} backup should be a shutdown
normal.
2) Some hangs were certainly possible with oracle 7.1.x when trying a
shutdown immediate. Shutdown abort covered this.
3) After the initial shutdown a startup restrict may prevent users logging
on etc before the shutdown normal. Never used it but
> shutdown immediate;
> startup mount;
> alter system set license_max_users=1;
> alter database open;
> {I sometimes like a little pause here}
> shudown normal;
Should also work, changing the immediate to an an abort if there's still
hangs.
Richard Woods wrote in message <35C31C0F.8862C542_at_concentric.net>...
>A shutdown immediate will terminate all user connections, rollback all
>uncommitted transactions, and shutdown the database cleanly.
>
>jkwallace_at_my-dejanews.com wrote:
>
>> We do a cold backup on Tuesday nights. unfortunately, users refuse to
exit
>> before shutdown and we end up doing shutdown abort, startup, shutdown
>> immediate. I am afraid that someday the startup won't.
>>
>> Is there a script I could use to kill all users (figuratively speaking,
of
>> course) before the shutdown immediate. Thanks for any and all assistance.
>>
>> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
>> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
>
>
Received on Sat Aug 01 1998 - 17:42:36 CDT