Re: Removing Older version of Oracle on NT Machine
I will gladly post such a thing to my web site. Considering that I will soon be herding Oracle on NT, rounding up a few NT pointers is not a bad idea. We *do* have a goal of consolidating databases to Sun. This NT stuff should be good for a few war stories, Jared On Monday 11 June 2001 16:11, Deshpande, Kirti wrote: Hi All, This question pops up once in a while. I did not pay much attention to replies before (not much of an NT person), but I think I will now, since I am also running into similar situation and it's always good to learn a few new things. If anyone has a step-by-step procedure to do this right the first time, please post it. All NT users will thank you :) If not, add on to (or correct as appropriate) the following check list: 1) Shutdown the database (assuming only one is running) 2) Stop the database service (via MS gui or otherwise) 3) Stop the listener service (via MS gui or otherwise) 4) Manually remove all database files (optional?) 5) Remove the above services ( a sample command syntax please ... ) 6) Use Oracle Installer to remove stuff (shall we say 'yes' to all those silly questions about shared programs, ddl etc. ?) 7) Back up registry (exactly how?) 8) Edit registry to remove Oracle under (blah blah please provide the dirs/subdirs names.) 9) Check and clean up Environment variables, if set for Oracle 10) Reboot server (I would, since Registry was fiddled with) 11) Check for any if leftovers.. (if found, what to do?) 12) ...anything else? Once we have a 'proven' checklist, any volunteer's to post it on their web site? I don't have one (yet).. Jared/Chris? Others? Thanks. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Post, Ethan [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 5:26 PM To: Multiple recipients of list ORACLE-L Subject:RE: Removing Older version of Oracle on NT Machine My solution is to uninstall everything you can with O-installer, then delete oracle home and the oracle subdirectory under HKEY_LOCK_MACHINE/SOFTWARE in the registry. Perhaps there are some other things you should do but this has always worked for me in the past. Make sure you get rid of all databases and services first also. - Ethan -Original Message- Sent: Monday, June 11, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Hi, Is there any white papers for removing one version of Oracle from an NT machine? I have 8.0 and 8i and would like to fully remove all of 8.0 including registry entries etc. I attempted to use Universal Installer, but it won't let me select any of the 8.0 components to remove them. I'm gonna keep working it and see where I get. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sunrise DBA 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). - - This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: Removing Older version of Oracle on NT Machine
Hi, We run our databases on NT and we face this problem once in a while. For the benefit of our consultants working on the client side I had prepared a document. This has worked perfectly for me as well as for our consultants on the client side. I am aware that the present problem is removing one version of Oracle and not cleaning up the entire oracle installation. My document deals with removing all oracle products or as the heading says clearing up the system (of ORALCE?) = Clearing up the System after an incomplete or improper installation of Oracle - Database Installation involves a set of procedures which need to be followed in order to have a proper working installation. If we follow these procedures the Installation will be fine and usually problems related to improper installation do not arise. But it is not always possible to get a proper installation for the first time. This document is a troubleshooting guide which would help to clear off the mess created by an improper installation in a WindowsNT system. First we need to know that During installation Oracle writes into certain directories (which we would have specified during installation) and also into the WindowsNT registry. WindowsNT registry is a repository of information about all the installed products and configurations on that system. When we are installing Oracle a directory is created in the registry which is name oracle which is present in the HKEY_LOCAL_MACHINE/SOFTWARE/ In the case of an improper installation the problems faced are · We may not be able to uninstall the incomplete installation · We may succeed in uninstalling the incomplete installation but yet face problems with WindowsNT Services. · Every time we log into WindowsNT we may get an error 'at least one system service failed to start' which may be an Oracle service from the earlier installation. · We may get an error while creating a database 'the database with the name you specified already exists please chose another name' which again may be attributed to an improper un-installation.(I am not pretty comfortable with the Oracle's Un-installation utility because I feel it does not uninstall everything) Keeping the above points in mind it would be better if we know where exactly to look in case we are faced with such problems. When oracle is installed it makes entries in the following places 1. The first and the foremost- the directory in which we install the Oracle database (say D:\Ora8i) 2. The second is the inventory it maintains in the directory c:\program files\oracle 3. The third HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE in the registry 4. The other place is HKEY_LOCAL_MACHINE/SYSTEM . Inside this entry there are three nodes controlset1,controlset2 and currentcontrolset. These nodes in turn have 4 nodes out of which 2 are important to us. They are Enum and Services. The Enum node has got two nodes out of which the 'root' node is of great interest to us because it stores details about all the services that are running on a WindowsNT system. The other node of interest from the controlsets is Services. The services node has got a list of services running on a WindowsNT system. In case we need to clean up the system after an incomplete installation we can follow the following steps Delete the home directory where Oracle is installed Delete the folder C:\program files\oracle Note:- This clears off information about any other Oracle utility installed on that system. Delete the registry entry HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE Warning:- This clears off information about any other Oracle utility installed on that system and you may not be able to run those programs again. Delete the Oracle Related services from HKEY_LOCAL_MACHINE/SYSTEM/CONTROLSETx/ENUM/ROOT/ . They will be named with a prefix LEGACY_ORACLE... Note:- You will have to use regedt32.exe to invoke registry editor and not regedit. You will have to use the security menu and give permissions to yourself before deleting these entries. Else it will not work . It is to be noted that there are three control sets and all the three (in reality any 2) need to be cleared off these un-necessary entries. Delete the Oracle Related services from HKEY_LOCAL_MACHINE/SYSTEM/CONTROLSETx/SERVICES . They will have a prefix 'Oracle'. I have also attached a document having the same contents Jared will this get a chance ?? joking?? coz I am a novice Clearing up the System.doc
RE: Removing Older version of Oracle on NT Machine
Hi All, I'll add some points about NT backup to this list of steps... 1.a. Backup all drives, sample command could be ntbackup backup c:\ d:\ /B /V /L D:\FULLBACKUP.LOG /D FULL SYSTEM BACKUP /B would backup registry. 1.b. Create one repair disk by typing command rdisk at command prompt. This should always be created as part of complete backup. But you need to create/update them only when there is any changes in system configuration/ softwares. 1.c. Optionally you can take export backup of Registry. Type regedit on command prompt and select Registry-Export Registry file. Of course Above steps I would execute as first step.. Next while removing services I had faced problems recently using ORADIM(xx). The command should be ORADIM80 -DELETE -SRVC service_name or ORADIM80 -DELETE -SID sid_name The executable name for Oracle 8i is ORADIM. So while deleting services through ORADIM80, it was not getting deleted. Alternatively, you can delete it from Registry, as follows... 2. Goto HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and remove all keys under here that begin with ORACLE. Now some final clarification about Deleting registry entries of Oracle... 3.a. Start the registry at the MS-DOS command prompt: C:\ REGEDIT 3.b. Go to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE and delete this ORACLE key. 3.c. Go to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC and expand all subkeys and remove all keys under here which are related with the Oracle ODBC Driver 3.d. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and remove all keys under here that begin with ORACLE. 3.e. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\... \Application and remove all keys under here that begin with ORACLE. 3.f. Close the registry. 4. Environment Cleanup can be done by right clicking My Computer icon on your desktop. Then Choose Properties-Environment. Here you can delete/set PATH variable and other variables(e.g. ORACLE_SID,ORACLE_HOME etc.) Just note that these variables are derived from this location if not found in Registry and take precedence over Registry entries( Similar to Unix :-). I hope we have compiled the complete steps, anything still left... Feel free to add ;-) Cheers, Rajesh Hi All, This question pops up once in a while. I did not pay much attention to replies before (not much of an NT person), but I think I will now, since I am also running into similar situation and it's always good to learn a few new things. If anyone has a step-by-step procedure to do this right the first time, please post it. All NT users will thank you :) If not, add on to (or correct as appropriate) the following check list: 1) Shutdown the database (assuming only one is running) 2) Stop the database service (via MS gui or otherwise) 3) Stop the listener service (via MS gui or otherwise) 4) Manually remove all database files (optional?) 5) Remove the above services ( a sample command syntax please ... ) 6) Use Oracle Installer to remove stuff (shall we say 'yes' to all those silly questions about shared programs, ddl etc. ?) 7) Back up registry (exactly how?) 8) Edit registry to remove Oracle under (blah blah please provide the dirs/subdirs names.) 9) Check and clean up Environment variables, if set for Oracle 10) Reboot server (I would, since Registry was fiddled with) 11) Check for any if leftovers.. (if found, what to do?) 12) ...anything else? Once we have a 'proven' checklist, any volunteer's to post it on their web site? I don't have one (yet).. Jared/Chris? Others? Thanks. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Post, Ethan [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 5:26 PM To: Multiple recipients of list ORACLE-L Subject:RE: Removing Older version of Oracle on NT Machine My solution is to uninstall everything you can with O-installer, then delete oracle home and the oracle subdirectory under HKEY_LOCK_MACHINE/SOFTWARE in the registry. Perhaps there are some other things you should do but this has always worked for me in the past. Make sure you get rid of all databases and services first also. - Ethan -Original Message- Sent: Monday, June 11, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Hi, Is there any white papers for removing one version of Oracle from an NT machine? I have 8.0 and 8i and would like to fully remove all of 8.0 including registry entries etc. I attempted to use Universal Installer, but it won't let me select any of the 8.0 components to remove them. I'm gonna keep working it and see where I get. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sunrise DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego
RE: Removing Older version of Oracle on NT Machine
My solution is to uninstall everything you can with O-installer, then delete oracle home and the oracle subdirectory under HKEY_LOCK_MACHINE/SOFTWARE in the registry. Perhaps there are some other things you should do but this has always worked for me in the past. Make sure you get rid of all databases and services first also. - Ethan -Original Message- Sent: Monday, June 11, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Hi, Is there any white papers for removing one version of Oracle from an NT machine? I have 8.0 and 8i and would like to fully remove all of 8.0 including registry entries etc. I attempted to use Universal Installer, but it won't let me select any of the 8.0 components to remove them. I'm gonna keep working it and see where I get. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sunrise DBA 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). -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: Removing Older version of Oracle on NT Machine
This article provides clean remove. http://allaire.com/Handlers/index.cfm?ID=18374Method=Full -Original Message- Sent: Monday, June 11, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Hi, Is there any white papers for removing one version of Oracle from an NT machine? I have 8.0 and 8i and would like to fully remove all of 8.0 including registry entries etc. I attempted to use Universal Installer, but it won't let me select any of the 8.0 components to remove them. I'm gonna keep working it and see where I get. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sunrise DBA 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: PHU,JULIA (HP-Sunnyvale,ex2) 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: Removing Older version of Oracle on NT Machine
Hi All, This question pops up once in a while. I did not pay much attention to replies before (not much of an NT person), but I think I will now, since I am also running into similar situation and it's always good to learn a few new things. If anyone has a step-by-step procedure to do this right the first time, please post it. All NT users will thank you :) If not, add on to (or correct as appropriate) the following check list: 1) Shutdown the database (assuming only one is running) 2) Stop the database service (via MS gui or otherwise) 3) Stop the listener service (via MS gui or otherwise) 4) Manually remove all database files (optional?) 5) Remove the above services ( a sample command syntax please ... ) 6) Use Oracle Installer to remove stuff (shall we say 'yes' to all those silly questions about shared programs, ddl etc. ?) 7) Back up registry (exactly how?) 8) Edit registry to remove Oracle under (blah blah please provide the dirs/subdirs names.) 9) Check and clean up Environment variables, if set for Oracle 10) Reboot server (I would, since Registry was fiddled with) 11) Check for any if leftovers.. (if found, what to do?) 12) ...anything else? Once we have a 'proven' checklist, any volunteer's to post it on their web site? I don't have one (yet).. Jared/Chris? Others? Thanks. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Post, Ethan [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 5:26 PM To: Multiple recipients of list ORACLE-L Subject: RE: Removing Older version of Oracle on NT Machine My solution is to uninstall everything you can with O-installer, then delete oracle home and the oracle subdirectory under HKEY_LOCK_MACHINE/SOFTWARE in the registry. Perhaps there are some other things you should do but this has always worked for me in the past. Make sure you get rid of all databases and services first also. - Ethan -Original Message- Sent: Monday, June 11, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Hi, Is there any white papers for removing one version of Oracle from an NT machine? I have 8.0 and 8i and would like to fully remove all of 8.0 including registry entries etc. I attempted to use Universal Installer, but it won't let me select any of the 8.0 components to remove them. I'm gonna keep working it and see where I get. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sunrise DBA 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). -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: Deshpande, Kirti 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: Removing Older version of Oracle on NT Machine
Keep in mind though, I have two versions of oracle running and just want to remove the older version. I think there are issues with the registry. I'll be trying it tonight. Ken - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 11, 2001 4:11 PM Hi All, This question pops up once in a while. I did not pay much attention to replies before (not much of an NT person), but I think I will now, since I am also running into similar situation and it's always good to learn a few new things. If anyone has a step-by-step procedure to do this right the first time, please post it. All NT users will thank you :) If not, add on to (or correct as appropriate) the following check list: 1) Shutdown the database (assuming only one is running) 2) Stop the database service (via MS gui or otherwise) 3) Stop the listener service (via MS gui or otherwise) 4) Manually remove all database files (optional?) 5) Remove the above services ( a sample command syntax please ... ) 6) Use Oracle Installer to remove stuff (shall we say 'yes' to all those silly questions about shared programs, ddl etc. ?) 7) Back up registry (exactly how?) 8) Edit registry to remove Oracle under (blah blah please provide the dirs/subdirs names.) 9) Check and clean up Environment variables, if set for Oracle 10) Reboot server (I would, since Registry was fiddled with) 11) Check for any if leftovers.. (if found, what to do?) 12) ...anything else? Once we have a 'proven' checklist, any volunteer's to post it on their web site? I don't have one (yet).. Jared/Chris? Others? Thanks. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Post, Ethan [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 5:26 PM To: Multiple recipients of list ORACLE-L Subject: RE: Removing Older version of Oracle on NT Machine My solution is to uninstall everything you can with O-installer, then delete oracle home and the oracle subdirectory under HKEY_LOCK_MACHINE/SOFTWARE in the registry. Perhaps there are some other things you should do but this has always worked for me in the past. Make sure you get rid of all databases and services first also. - Ethan -Original Message- Sent: Monday, June 11, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Hi, Is there any white papers for removing one version of Oracle from an NT machine? I have 8.0 and 8i and would like to fully remove all of 8.0 including registry entries etc. I attempted to use Universal Installer, but it won't let me select any of the 8.0 components to remove them. I'm gonna keep working it and see where I get. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sunrise DBA 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). -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE