[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


Uninstalling Oracle Completely. How to

Posted on 2006-11-12
Medium Priority
Last Modified: 2010-08-05
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.
Question by:aman_greval
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 1000 total points
ID: 17928186
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  

Expert Comment

ID: 17928209
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.
LVL 48

Expert Comment

ID: 17928507
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.

LVL 14

Accepted Solution

GGuzdziol earned 1000 total points
ID: 17928601

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to recover a database from a user managed backup

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question