Notes for Oracle 11g - How to get a “Clean Machine”

 

Notes for De-installing Oracle 11g

 

·         When de-installing the database the corresponding services are not automatically removed.  This will generate event viewer errors when rebooting your computer. To correct this, you must manually remove these entries in the registry.  Before you attempt these steps, make sure you know which Oracle home and SID to de-install.  Deleting the wrong home and/or SID service entry could cause major problems with your Oracle environment. Below is an example of removing services. Follow similar steps for each service you want to remove.

 

1.      Start regedit (you can start it at the command prompt by typing C:\regedit, or from the Start menu.)

2.      As a first step, be sure to save the current registry configuration

3.      Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services.

4.      Delete Oracle<HOME_NAME>TNSListener.

5.      Delete OracleService<SID>.

 

<HOME_NAME> is the Oracle Home Name you just deinstalled from

<SID> is the SID you just deinstalled (such as: ORCL)

 

Notes for Installing other Oracle Products

 

·         When you begin to install products a second time after initially installing using Oracle Universal Installer, (if you choose to perform a Custom installation) you will see that the products you previously installed are selected. For example, if you previously installed Oracle Server and SQL*Plus, those items will be selected in the list of installable products.  To install additional products, select those products, but do not deselect the products you have already installed. If you deselect the products you previously installed, they will be deinstalled.  If you reinstall products using Oracle Universal Installer, reboot your machine after installation.

 

Creating a Clean Machine (Removing All)!

 

In rare situations, some users may want to correct serious system problems by completely removing Oracle products from their system. This is not recommended as an easy way to fix problems, especially common ones. Only create a Clean Machine as a last resort, and only if you want to remove all Oracle products from your system. Complete the following steps to create a Clean Machine.

Note: The following Clean Machine instructions assume an OFA (Optimal Flexible Architecture) structure.

Warning: This will remove all Oracle products, Oracle services, and Oracle registry entries from your computer.

 

On Windows:

 

1. Ensure you are logged in as a user with Administrator privileges.

2. Using regedit (at the command prompt, type regedit), go to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE and delete the ORACLE key.

3. Delete HKEY_LOCAL_MACHINE\SOFTWARE\odbc.

4 Open HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services, and remove all keys under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services that begin with ORACLE.

5. Open HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\Application, and remove all keys under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\Application that begin with ORACLE.

6. Close regedit.

7. From the Control Panel, open System.

8. If JRE was installed by Oracle, remove the %ORACLE_HOME%\BIN path and the JRE path. For example, you may see a path similar to this one: C: \ORACLE\ORA81\BIN;G: \Program Files\Oracle\jre\1.1.7\bin. Go to Start > Control Panel > System > Environment tab. Click on the system variable path and modify the path.

9. Delete Icons from <system_drive>: \Winnt\Profiles\All Users\Start Menu\Programs\Oracle - <HOME> and <system_drive>: \Winnt\Profiles\All Users\Start Menu\Programs\Oracle Installation Products. Where <HOME> is the previous HOME name.

10. Delete <system_drive>: \Program Files\Oracle (from the Windows NT Explorer or from the command prompt).

11. Reboot your computer.

12. Delete all ORACLE_BASE directories (You can find the Oracle homes listed in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORACLE_HOMES).