RE: how to delete instance?

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Thu, 18 Oct 2001 09:18:29 -0700
Message-ID: <F001.003AEED0.20011018092453@fatcity.com>

That would delete the instance AND the database.

To "delete the instance" type SHUTDOWN ABORT. The "instance", after all, is just the SGA and background processes.

(unless you are in 9i, and then you just think real hard, and
it figures it out for you. )

;-)

Yours in Picking Nits,

etc.

-----Original Message-----
Sent: Thursday, October 18, 2001 1:01 PM To: Multiple recipients of list ORACLE-L

To delete an instance, shutdown the instance and remove all its control, log and database files. To do it properly, remove also all its entries in SQL*Net(Net8) parameter files.

That's all.

-----Message d'origine-----
De : Seema Singh [mailto:oracledbam_at_hotmail.com] Envoyé : jeudi 18 octobre 2001 18:41
À : Multiple recipients of list ORACLE-L Objet : how to delete instance?

Hi
WHich way is better way to delete Instance? Means shutdown instance/delete all reference files or remove thru dbassist mode and then delete reference files?
Thanks
-Seema

Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  INET: oracledbam_at_hotmail.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: ALEMU Abiy
  INET: abiy.alemu_at_criltelecom.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: Mohan, Ross
  INET: MohanR_at_STARS-SMI.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 Thu Oct 18 2001 - 11:18:29 CDT