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

From: George Dau <gedau_at_isa.mim.com.au>
Date: Wed, 20 Jan 1999 23:46:56 GMT
Message-ID: <36a669ce.180912137@isappp>

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.

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

Received on Wed Jan 20 1999 - 17:46:56 CST