Re: SHUT IMMEDIATE !!!! PROBLEM !!(URGENT!!)

From: Jurij Modic <jmodic_at_src.si>
Date: Thu, 21 Jan 1999 11:47:24 GMT
Message-ID: <36a710b0.14340708@news.siol.net>

On Wed, 20 Jan 1999 23:46:56 GMT, gedau_at_isa.mim.com.au (George Dau) wrote:

>I've read several of the replies, there are some issues with some of them.
>
>If the thing is stuck doing a big rollback, then you should leave it. The
>problem is more likely to be existing connections.
>
>Killing them off wont work because people will connect while you are killing the
>existing ones.

Small correction here: if you mean killing the existing connections *after* any kind of shutdown has begun then no new connections will be permited by Oracle RDBMS. It doesn't matter if it is NORMAL or IMMEDIATE shutdown when new connections are concerned.

>shutdown abort; startup normal; shutdown; is no good because people will connect
>just after the startup normal, so the second shutdown wont complete.
>
>I use:
>1. shutdown the lisener(s)
>2. kill connections (kill then kill -9)
>3. shutdown immediate (wait 10 seconds)
>4. shutdown abort
>5. startup restrict
>6. shutdown
>--
> ,-,_|\ George Dau - Unix (Solaris, DEC Unix, Linux), Oracle, Internet. __
>/ * \ Home: gedau_at_pobox.com ! Any views or opinions expressed (OO)
>\_,--\_/ Work: gedau_at_isa.mim.com.au ! above may be mine, but are NOT ( \/ )
> v WWW: http://pobox.com/~gedau ! necessarily those of M.I.M. W--W

Regards,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Thu Jan 21 1999 - 05:47:24 CST