Oracle-L: RE: It takes too long to shutdown database

From: Sinardy Xing <SinardyXing_at_bkgcomsvc.com>
Date: Tue, 25 Feb 2003 19:53:48 -0800
Message-ID: <F001.0055983C.20030225195348@fatcity.com>

Hi David,

These are what I think

first, you are not using shutdown immediate (Oracle waiting user to close the session) - unlikely for this case. or
It has been so long you never shutdown your database, Oracle doing housekeeping, your rollback segment, update your data files, things like that or
you are using archive log mode with 8.1.6, and legend said bug cause the shutdown took hours (oracle code performing endless loop I quest), I encounter this problem then I did :

startup force follow with shutdown immediate (hmm... I think, I am a lousy dba, he he he...) the problem never occur again, and my database life happily ever after.

Sinardy

-----Original Message-----
Sent: 26 February 2003 09:44
To: Multiple recipients of list ORACLE-L

I try to bounce database by shutting it down and starting it back up but it just hang in there for almost 45 minutes trying to shut down. It is running on Solaris8, I can press Ctrl+C to interrupt it or issue a kill command to kill it but I hesitate to do so. Do you have any advices and why it takes too long to shutdown database? It usually only takes me about 3 minutes to bounce database.

Thanks,
David

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Sinardy Xing
INET: SinardyXing_at_bkgcomsvc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Feb 25 2003 - 21:53:48 CST