Solved

Uninstalling Oracle Completely. How to

Posted on 2006-11-12
4
1,320 Views
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.
0
Comment
Question by:aman_greval
4 Comments
 
LVL 142

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 250 total points
Comment Utility
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  
0
 
LVL 2

Expert Comment

by:syed555
Comment Utility
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.
0
 
LVL 47

Expert Comment

by:schwertner
Comment Utility
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.

0
 
LVL 14

Accepted Solution

by:
GGuzdziol earned 250 total points
Comment Utility
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
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, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

771 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now