Improve company productivity with a Business Account.Sign Up

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1344
  • Last Modified:

Uninstalling Oracle Completely. How to

I want to deinstall oracle.
I selected Oracle Universal Installer, it shows all the products installed
Oracle Home81
 |+Oracle 8i Client      
      |+Net8 Products
      |      |
      |      |+Net8 Client
      |      |
      |      |+Oracle Protocol Support      
      |+Oracle Utilities
      |+Oracle Java Products
      |+Oracle Programmer
      |+Oracle Enterprise Manager Products

On each level there are checkboxes for sub products, like +Net8 Products has
subcomponents like Net8 Client and Oracle Protocol Support

Now my problem is that when i select the checkbox on +Net8 products, it's sub
subcomponents like Net8 Client and Oracle Protocol Support do not get selected
by default.

Q1.Now when i want to deinstall Oracle completely, will i have select all checkboxes
induvidually or is it ok to select only the first level components.(Selecting all
entries is a long and tedious process).

Q2. Even after complete deinstall of oracle, oracle keeps entries in the windows
registry. I have to manually delete all oracle entries to make the system clean
of oracle completely, Is that ok?

I want to clean install oracle because i want to install Oracle designer.
Oracle designer does not install on a system that already has oracle installed on it.
However, it installs well on a fresh system. So Oracle Designer should be the
first oracle product installed on a fresh pc.
2 Solutions
Guy Hengel [angelIII / a3]Billing EngineerCommented:
Q1: just select the main entries.
Q2: yes, registry cleaning is what you should/can do.

note: ususally, the oracle installer that is on the disk also left some information about oracle homes, ensure that you also get rid of those folders  
1. By selecting the parent node all the child nodes will automatically be deinstalled. Select all the parent nodes and deinstall.

2. After deinstall restart the system.

Oracle will leave OracleHome info in the registry. You can delete the registry key for oracle paths.

Search for oracle folder in Program Files and delete it.
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


   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>&
       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

  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

      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
          Application and look for keys that start with 'Oracle'.
          Normally, they should have been removed in Step 5.

      e)  Go to
          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,

  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.
      * 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
      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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now