RE: Working, middle of night

carry out a shutdown abort. it may be that you have another session open and the database will not close untiul it disconnects.

shutdown abort

startup

shutdown normal

you will then know that it is shut down ok

Phil West - Impex IT ltd
Unix Sys Admin and Oracle Financials DBA Services

[ all opinions, unless otherwise stated, are personal and subject to change without reason or warning ! ]

-----Original Message-----
From: Linda Hagedorn [mailto:Linda_at_pets.com] Sent: Tuesday, June 06, 2000 1:16 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Working, middle of night

This is regarding shutdown. After ALTER DATABASE RENAME 21 files, I shutdown the database and am still waiting for it to finish (over 10 minutes). I'd like it to come down faster, or be able to check that it isn't hung up. I logged into another session and tried to SHUTDOWN IMMEDIATE, but the command was not permitted as the database was in the process of shutting down?

Is there a way to see the status of a closing/shuting down instance? Would it be recommended to kill it from Unix?

Thanks, LInda

-- 
Author: Linda Hagedorn
  INET: Linda_at_pets.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).




*******************************************************************************

The information in this Internet e-mail is confidential and may be legally privileged.  It is intended solely for the addressee.  Access to this Internet e-mail by anyone else is unauthorised and any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. 
 When addressed to our clients any opinions or advice contained in this Internet e-mail are subject to the terms and conditions expressed in any applicable documentation or market practices governing the relationship between Garban Intercapital plc and its clients.

Any views expressed in this message are those of the individual sender except where they are stated to be the views of Garban Intercapital plc.


*******************************************************************************