Wednesday, January 11, 2017

Uninstall Oracle Database from Windows Based System

It is a very tedious task to remove Oracle Database from Windows Based System completely. We generally face this issue if Oracle is not completely installed or something wrong happened with the current installation. When you go to re-install, it creates with the new home installation. Now, we can remove Oracle Database completely from the Windows Based System and can do fresh install. After googling for many hours, found some steps which is helpful for you. The steps given below is used for Oracle 12c.

My Oracle Database 12c is installed in "C:\app\product\12.1.0\dbhome_1" and SID is "KUMAR" on Windows 7 64-bits

Follow the below process:
1. Deinstall the database using Oracle Universal Installer. 
   Steps:
   a. Go to Start -> Oracle - OraDB12Home1 -> 
       Oracle Installation Products -> 
       Universal Installer 
   b. will take some time to load installer
   c. Click "Deinstall Products..." button
   d. Expand "OraDB12Home1" in Oracle Installed product list 
   e. Tick "Oracle Database 12c 12.1.0.2.0
   f. Click "Remove..." button 
   g. Click "Yes" button in confirmation dialog
   h. It will start to delete. After completion close the dialog
2. Remove the registry entries.
    Steps:
   a. Open windows registry. Go to Start -> Run... -> Type Regedit -> OK
   b. Registry Editor is opened.
   c. Expand HKEY_CURRENT_USER\SOFTWARE and delete ORACLE 
   d. Expand HKEY_LOCAL_MACHINE\SOFTWARE and delete ORACLE
   e. Expand HKEY_LOCAL_MACHINE\ SYSTEM\ CurrentControlSet\ 
    Services\ EventLog\ Application 
        i. delete Oracle.KUMAR (Note: here KUMAR is SID)
       ii. delete Oracle.VSSWriter.KUMAR (Note: here KUMAR is SID)
      iii. delete OracleOraDB12Home1MTSRecoveryService 
   h. Expand HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
        i.  delete OracleJobSchedulerKUMAR (Note: here KUMAR is SID)
       ii.  delete OracleOraDB12Home1MTSRecoveryService 
      iii.  delete OracleOraDB12Home1TNSListener 
      iv.  delete OracleServiceKUMAR (Note: here KUMAR is SID)
       v.  delete OracleVssWriterKUMAR (Note: here KUMAR is SID)
3. Restart system
4. Delete installation directory i.e. "C:\app" in my case
5. Delete Oracle from C:\Program Files or C:\Program Files (x86)
6. Delete "Oracle - OraDB12Home1" menu from Start menu 
7. Remove Oracle full path entry from PATH environment variable. 
   i.  Go to Start -> Right click "Computer" -> Properties  OR 
   ii. Right click "Computer" on desktop -> Properties   OR 
   iii. Go to Control Panel -> System 
   
   Click "Advanced system setting" link in left pane -> Advanced tab -> 
           "Environment Variables..." button -> Select variable "Path" -> 
           Edit... 
   Remove any reference to Oracle path ("C:\app").
   Close all the windows.
8. Restart system 

Eureka!!! Now Oracle Database is completely removed from your system. 

Now re-install Oracle Database. 
During installation, if you see "the chosen installation conflicts with software already installed in the given oracle home" then either chose another installation folder or follow these steps to use the same installation folder in your previous installation:
1. Stop installation
2. Go to inventory directory in program files. Open "My Computer" -> go to "C:\Program Files\Oracle\Inventory\ContentsXML" and rename "inventory.xml" to "inventory-old.xml".
3. Close the explorer and restart installation.


References:
 http://stackoverflow.com/questions/83967/how-do-i-do-a-manual-uninstall-of-oracle
 http://wbprdgpms.in/oracle.txt
 http://dba-story.blogspot.in/2014/04/ins-32025-chosen-installation-conflicts.html