Re: Problem with Database

If you use SHUTDOWN NORMAL, Oracle will wait until all sessions has been logged out while SHUTDOWN IMMEDIATE will kill all sessions, rollback all incomplete transactions, and then shutdown. That's the difference.

Diego Pafumi wrote:

> Hi guys !!
> I have a question, Why I can't make a normal shutdown in my Database???
> I can do a
> shutdown immediate, but I never can made a normal shutdown !!!!
> That's very rare !!!!
> So, please, I accept any advice !!!
>
> Thanks

--
Best Regards,

Reid Lai <reidlai_at_hk.super.net>
Oracle 7.3 Certified Database Administrator (OCP)
================================================
The above opinions are mine and do not represent
any official standpoints of my employer