RE: Deleting Oracle8 on NT(cleaning Oracle8)
>> From: "Raghu Kota" <[EMAIL PROTECTED]> >> Date: Mon, 03 Dec 2001 15:57:04 + >> Subject: Deleting Oracle8 on NT(cleaning Oracle8) >> >>Hi Friends, >> >>I need to clean Oracle8 database size 3Gb on one of my NT server, Is it >>possible that shutdown the database and delete all datafiles and all >>directories??? Or Is there any other way to clean all files and >>directories?? I appreciate all suggestions and responses. See MetaLink Doc IDs: 75061.1 or 74790.1 HTH, - Sean O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Deleting Oracle8 on NT(cleaning Oracle8)
Raghu, If you just want to delete one oracle database from an NT machine, do as you suggest - delete all of the files (control, log, data), init.ora, and any directories that held these files. Then, be sure and run ORADIM -delete {sid} to remove the instance from the registry. That should do it. If you wish to remove a version of Oracle software completely from an NT machine, I sent a document over this list last week that outlines how to do this. Pretty simple and straoghtforward - it has always worked for me. If you want this doc, let me know and I will send it to you. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, December 03, 2001 10:55 AM To: Multiple recipients of list ORACLE-L Hi Friends, I need to clean Oracle8 database size 3Gb on one of my NT server, Is it possible that shutdown the database and delete all datafiles and all directories??? Or Is there any other way to clean all files and directories?? I appreciate all suggestions and responses. Thanks in advance Raghu. _ 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: Raghu Kota INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Deleting Oracle8 on NT(cleaning Oracle8)
Removing Oracle on NT (or any Windoze for that matter) 1. shutdown all oracle services (db, listener, etc.) 2. use the oracle installer and deinstall everything - this gets rid of a large portion of oracle 3. use regedit and remove the key HKEY_LOCAL_MACHINE\software\oracle 4. search the registry for oracle (delete every key related to the oracle install) do not delete keys related to Microsoft's Oracle ODBC (if installed it comes with VB) this is NOT an oracle product. 5. search the registry for ORANT (delete these keys) 6. SOUNDLY CURSE the "?genius?" at M$ who came up with the idea for the registry. 7. search the registry for ORADAC - this is the oracle objects for ole data access controller (delete these keys) 8. delete the directories of oracle datafiles, software, installer (usually in Program Files), and in the Start Menu. 9. remove any references to oracle in the autoexec.bat 10. Since this is Windoze reboot the machine. Now oracle is gone. ;) Rodd Holman On Mon, 2001-12-03 at 12:10, Dwayne Cox wrote: Raghu, By shutting down the database and stopping the listener, you can delete all the data files and directories without a problem. This will remove your database. If you want to remove Oracle8 software, that will require purging the registry. I don't think I have ever successfully removed ALL Oracle software from NT. HTH On Monday 03 December 2001 10:55 am, you wrote: > Hi Friends, > > I need to clean Oracle8 database size 3Gb on one of my NT server, Is it > possible that shutdown the database and delete all datafiles and all > directories??? Or Is there any other way to clean all files and > directories?? I appreciate all suggestions and responses. > > Thanks in advance > Raghu. > -- Dwayne Cox[EMAIL PROTECTED] DBA, Development Department, Info Tech, Inc. 5700 SW 34th Street, Suite 1235 phone: (352) 381.4521 Gainesville, FL 32608 fax: (352) 381. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dwayne Cox INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED] (605) 988-1373 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Deleting Oracle8 on NT(cleaning Oracle8)
Raghu, By shutting down the database and stopping the listener, you can delete all the data files and directories without a problem. This will remove your database. If you want to remove Oracle8 software, that will require purging the registry. I don't think I have ever successfully removed ALL Oracle software from NT. HTH On Monday 03 December 2001 10:55 am, you wrote: > Hi Friends, > > I need to clean Oracle8 database size 3Gb on one of my NT server, Is it > possible that shutdown the database and delete all datafiles and all > directories??? Or Is there any other way to clean all files and > directories?? I appreciate all suggestions and responses. > > Thanks in advance > Raghu. > -- Dwayne Cox[EMAIL PROTECTED] DBA, Development Department, Info Tech, Inc. 5700 SW 34th Street, Suite 1235 phone: (352) 381.4521 Gainesville, FL 32608 fax: (352) 381. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dwayne Cox INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).