RE: Database will not shutdown in Normal or IMMEDIATE mode

From: Cale, Rick T (Richard) <RICHARD.T.CALE_at_saic.com>
Date: Fri, 05 Oct 2001 06:03:10 -0700
Message-ID: <F001.003A32A2.20011005054030@fatcity.com>

Thanks everyone with the DROP TABLE ... and SHUTDOWN replies. This morning is much better.
I was able to DROP tables I needed. The shutdown problem would not occur even after the DROP
finally succeeded. I was in a position to do a cold boot of the server and viola I was able to
shutdown and do backups. It is a beautiful sunny day in east TN.

Thanks again,
Rick

-----Original Message-----
Sent: Friday, October 05, 2001 9:20 AM
To: Multiple recipients of list ORACLE-L

Rick,

By now, I hope your database is back in working order.

My guess as to why you could not shut down your database is that the "Drop Table" command was still running.

I've seen these long-running DDL commands get started and just stick around until they finish, even if you killed the sqlplus session.

Just a guess. Hope this morning brings a better day to you.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Thursday, October 04, 2001 5:25 PM To: Multiple recipients of list ORACLE-L

Hi All,

It is one of those days.
Anyway Oracle 8.0.5 / Win 4.0.

I am trying to shutdown instance in Normal mode but just hangs. I am able to shutdown abort and restart. Heck I even rebooted server in case files were locked. There are no errors in alert log

Any ideas why I cannot shutdown in NORMAL or IMMEDIATE. No other users/sessions on the system. I have done this many times but not working today. I need to do this because I want to do an offline backup.

Thanks
Rick
--

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

Author: Cale, Rick T (Richard)
  INET: RICHARD.T.CALE_at_saic.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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).
--

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

Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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).
--

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

Author: Cale, Rick T (Richard)
  INET: RICHARD.T.CALE_at_saic.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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 Fri Oct 05 2001 - 08:03:10 CDT