Uninstall Oracle without the Uninstaller?

I installed Oracle 9i on my PC (Micron Millenia, Pentium 4) running Windows XP Pro SP1.  I need to get rid of it; when I attempt to open the installer and uninstall using it, I am told that it cannot find Java 1.3 and cannot run for that reason.  I am running Java 1.4.1, and it is installed ok (to the best of my knowledge).  Is there a way to uninstall Oracle without resorting to the uninstaller, pls?  My need is rather urgent - the presence of Oracle on my machine is getting in the way of my recent install of IIS 5.1, which I need to use for a school assignment.  TIA.
jlw99Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

paquicubaCommented:
Try this:
1. Go to Control Panel/Administrative Tools/Services and stop any service named like 'Oracle%'.
2. Remove the entire ORACLE_HOME directory. i.e. 'C:/Oracle'
3. Remove 'C:/Program Files/Oracle' sub-directory.
4. Go to Start/Run and type: regedit, then expand [HKEY_LOCAL_MACHINE] , expand [SOFTWARE] and delete the ORACLE key.
5. Colapse [SOFTWARE] , expand [SYSTEM], expand [CurrentControlSet], expand [Services] and remove any 'Oracle%' key.
6. Go to Start/ Control Panel /System /Advanced Tab, click on Environment Variables, select variable named Path and click Edit. Delete all entries referencing the ORACLE_HOME you deleted.
7. Restart your machine.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
schwertnerCommented:
1)  Backup

    Be careful, because these steps remove all Oracle software, Oracle services,
    and Oracle registry entries from the system. So it is advisable that you
    first perform a backup, if required, of certain files like:

       SQL*Nnet configuration files
       Database files
       Self-written scripts
       
    that are stored under the oracle home directory, etc.

2)  The following procedures require the editing of Windows registry, which is
a
    potentially dangerous operation. There is no undo option in the Registry
    Editor.

   Content
   -------

   A. 32-bit on Windows NT
   B. 32-bit on Win95/Win98
   C. 16-bit

   A. 32-bit on Windows NT
   -----------------------
   1.  Ensure that you are logged in as a user with Administrator privileges.

   2.  Stop all Oracle-related services and all Oracle programs.

   3.  Remove the database services via the oradim command. This can be
       done via ORADIMXX -DELETE -SID <SID> or via the 'SC' tool of the
       resource kit.

       For a full explanation on using the ORADIM command, see <<NOTE:61621.1>&
gt;.
 
       As from 8.1.6, the method for deinstalling is to first run Net8CA
       in Deinstall mode, then run DBCA to delete a database, then run OUI
       to deinstall the products.  At this point, all services should be
       removed.

  4.  Start the ODBC administrator applet, if installed, and remove any
      Oracle DSN definitions.
 
  5.  Remove the Oracle software via the Oracle installer or the
      Universal Installer (8.1.5 and onwards). Make sure that all
      services related to Oracle are stopped first.
      Note that you cannot remove the installer itself.

      If Legato Storage Manager is installed on the system, then remove it via
      the uninstaller executable that is shipped with Legato.
          Start->Programs->Networker->Uninstall Networker

      Caution: If Legato Storage Manager was installed independently of
              Oracle, DO NOT REMOVE LSM, because your system's backup
              environment may be adversely affected.

  6.  Start the Event Viewer, Log->Application, and clean up the
      application logs for Oracle.

  7.  Start the registry editor. This can be done via regedit or
      regedt32.

      a)  If the Oracle Universal Installer (OUI) was used, go to
          HKEY_LOCAL_MACHINE\Software\Oracle and write down the value of
          the INST_LOC variable. This shows you where the OUI
          software is installed. This can then be used to remove the OUI
          from the machine afterwards.

      b)  Go to HKEY_LOCAL_MACHINE\Software and remove the ORACLE key,
          look into the ODBC key for any 'leftovers' of Oracle. If they
          exist, then remove them as well.

      c)  Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and
          verify that all services that start with 'Oracle' are removed.
          If this is not the case, then remove the services starting with
         'Oracle' (database related) and the ones that start with
          'OraWeb' (Oracle Application Server related).
          No entries will not be removed from the services dialog box
          until you reboot.

      d)  Go to
          HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\
          Application and look for keys that start with 'Oracle'.
          Normally, they should have been removed in Step 5.

      e)  Go to
          HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion
          \Uninsta.
ll
          and remove all entries related to Oracle

          Typical entries to found there are:
                  Oracle JInitiator 1.1.x.x

      f)  Close the registry editor.
 
  8.  Remove any Oracle related .INI files that may exist in the Windows
      NT Boot directory. The Windows NT boot directory may be found by
      entering "SET WINDIR" from a command prompt.

      Typical Oracle .INI files include ORADIM73.INI, ORADIM80.INI,
      ORACLE.INI, ORAODBC.INI

  9.  Go to Start->Settings->control Panel->System->Environment.
      * Select in the 'System Variables' window the PATH variable and
        remove the %ORACLE_HOME%\BIN directory. If JRE was installed by
        Oracle, then remove the JRE path as well.
        (For example: ...;C:\Orant\Bin;C:\Program Files\Oracle\jre\1.
1.7\bin;...)
      * Check the ?User Variables for user xxx? section also for Oracle
        entries to remove.
      * Check as well the ?System Variables? as ?User Variables for user
        xxx? windows for Oracle variable to remove: typical entries could
        be: ORACLE_SID, TNS_ADMIN, ?

  10. Remove any icons and references from the start menu. They are
      listed into the C:\Winnt\Profiles\All Users\Start Menu\Programs
      directory.
      Normally, they should be removed by the Oracle Installer in Step 4.

  11. Remove the %ORACLE_HOME% directory from the machine, either by
      using the Windows NT Explorer or from the command prompt.

  12. If the Oracle products were installed via the Oracle Universal
      Installer, then remove this also from the system. By default, it is
      installed under the Oracle directory in C:\Program Files, although
      you could have specified an alternative directory when
      you installed the Oracle Universal Installer (OUI). In that case,
      look at the INST_LOC parameter you have noted down in Step 6a.

  13. Reboot your computer.


  B. 32-bit on Win95/Win98
  ------------------------

  1.  Stop all Oracle programs.

  2.  Start the ODBC administrator applet, if installed, and remove any
      Oracle DSN definitions.

  3.  Remove the Oracle software via the Oracle installer or the
      Universal Installer (8.1.5 and onwards). Note that you cannot remove
      the installer itself.
      If Legato Storage Manager is installed on the system, then remove it via
      the uninstaller executable that is shipped with Legato.
          Start->Programs->Networker->Uninstall Networker

      Caution: If Legato Storage Manager was installed independently of
              Oracle, then DO NOT REMOVE LSM, because your system's backup
              environment may be adversely affected.

  4.  Start the registry editor. This can be done via regedit or
      regedt32.

      a)  If the Oracle Universal Installer (OUI) was used, go to
          HKEY_LOCAL_MACHINE\Software\Oracle and write down the value of
          the INST_LOC variable. This is showing you where the OUI
          software is installed. This can then be used to remove the OUI
          from the machine afterwards.

      b)  Go to HKEY_LOCAL_MACHINE\Software and remove the ORACLE key,
          look into the ODBC key for any 'leftovers' of Oracle, if they
          exist remove them as well.

      c)  Go to HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\
          CurrentVersion\Uninstall and remove all entries related to
          Oracle.

  5.  Close the registry editor.

  6.  Edit your AUTOEXEC.BAT file and remove the %ORACLE_HOME%\bin and
      JRE paths from the PATH.
      (For example: ...;C:\Orant\Bin;C:\Program Files\Oracle\jre\1.1.
7\bin;...)
      Check if any Oracle variables are set in the AUTOEXEC.BAT.  If there are,
      then remove them.

  7.  Remove any icons and references from the Start menu.  They are
      listed in the C:\Windows\Start Menu\Programs directory via W.
indows
      Explorer. These are not always removed by the Oracle installer in
      Step 2.

  8.  Remove the %ORACLE_HOME% directory from the machine, either by
      using the Windows Explorer or from the command prompt.

  9.  If the Oracle products were installed via the Oracle Universal
      Installer, remove this also from the system. By default, it is
      installed under the Oracle directory in C:\Program Files, although
      you could have specified an alternative directory when
      you installed the Oracle Universal Installer (OUI). In that case,
      look at the INST_LOC parameter you have noted down in Step 3a.

  10. Remove any Oracle-related .INI files that may exist in the Windows
      directory. The Windows may be found by entering "echo %WINDIR%"
      from a command prompt.

      Typical Oracle .INI files include ORADIM73.INI, ORADIM80.INI,
      ORACLE.INI, ORAODBC.INI

  11. Reboot you computer.
jlw99Author Commented:
Thank you, all.  I will wait until the weekend - I can work around the situation for the time being as I found that IIS was not essential to my school project.  I still want to get Oracle off my machine, however, and will give it a shot when I have time to backup properly and cope with the inevitable side issues that are bound to arise.  
jlw99Author Commented:
On 8/6-7/2005 I implemented the suggestions I received from paquicuba and schwertner, with a few additions of my own, thus:

1.  Created a restore point in Windows XP Pro.

2.  Did an incremental backup of my primary hard drive, C:, using Acronis True Image.

3.  Went to Control Panel/Administrative Tools/Services and stopped all Oracle% services.
    When I did this, one service, OracleOracleHomeAgent would not stop fully; it showed as "stopping".

4.  Due to the difficulty I encountered in step 3, above, I restarted the computer in "Safe" mode,  
    and then stopped all Oracle services successfully via Control Panel/Administrative Tools/Services.

Note - I remained in "Safe" mode for the rest of the removal process.

5.  Deleted the Oracle home directory, C:\oracle.

6.  Deleted C:\Program Files\Oracle

7.  Clicked Start/run/regedit to edit Registry.

8.  Expanded HKEY_LOCAL_MACHINE/SOFTWARE and deleted Oracle key.

9.  Collapsed /SOFTWARE and expanded /SYSTEM, and deleted all Oracle keys.

10. Went to Start/Control Panel/System/Advanced/Environmental Variables and:
      A) Deleted JSERV entirely, as it only had one item, and that was in Oracle directory.
      B) Deleted WV_GATEWAY_CFG, as it, too, only had one item, and that was in Oracle directory.
      C) Edited PATH variable to remove several Oracle references.
   
Note - I backed up all of the above and still retain the configuration as it was before I deleted/changed same.

11. Once again went to Start/run/regedit, expanded HKEY_LOCAL_MACHINES/SYSTEM/Current Control Set/Services/
      Event Log/Application  and deleted all Oracle%.

12. Deleted Oracle-Oracle Home and Oracle Installation Products from Start menu.

13. I ran a software product called "Clean My PC", which can clean/maintain the Registry; I deleted any Oracle   related entries that I found (28 in all).

14. There is no trace of Oracle products in the Add/Remove Software screen of the Control Panel.

At this point, to test the effects of the de-install, I rebooted and installed  Microsoft Internet Information Services, which was the original point of all this.  It installed cleanly, with no error messages and appears to be properly installed.

15. Last traces of Oracle are in HKEY_CLASSES_ROOT/CLSID; it still shows up in ODBC Admin screens.  I traced many  Oracle references all through this section of the Registry and have decided to leave well enough alone.
I am reasonably confident that I will be able to install telecommunications modules as I need to for my school requirements, and have all functionality on my primary computer unscathed.  I shall leave well enough alone at this point, pending a complete re-install of operating system and all applications after school ends for me in December (assuming that I can find time, of course).

As you can see from the above account, I have used parts of the posts from both paquicuba and schwertner in this procedure, plus a few add-ons of my own.  I could not have done it without you, guys, and appreciate the help you gave so generously.  Thank you.  
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.