RE: Removing Oracle products from NT

From: Eric D. Pierce <PierceED_at_csus.edu>
Date: Thu, 03 May 2001 12:17:39 -0700
Message-ID: <F001.002F8FBC.20010503121842@fatcity.com>

Doc ID:

Note:74790.1
Subject:

         Cleanly Deinstalling RDBMS
         Software from 95/98/NT
 Type:
         BULLETIN
 Status:
         PUBLISHED

                                       Content Type:
                                                         TEXT/PLAIN
                                       Creation Date:
                                                         08-OCT-1999
                                       Last Revision Date:
                                                         05-SEP-2000
                                       Language:
                                                         USAENG





 ------------------------------------------------------------------------

Cleanly Deinstalling Oracle RDBMS Software from Windows 95/98/NT Machines

Purpose

This bulletin explains how to remove Oracle software from a Windows 95, 98, or NT system.

Scope & Application

This bulletin assumes the reader has a thorough understanding of the operating system and the Windows registry.

Related Documents

[NOTE:61621.1] Recreating Oracle7 / Oracle8 services and instances from

                 the command line

Introduction

Removing or deinstalling Oracle software from an 95/98/NT operating system requires several steps to completely creating a 'clean' machine. This document explains what must be done to remove all Oracle software from the system.

Warning

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

32-bit on Windows NT
32-bit on Win95/Win98
16-bit
32-bit on Windows NT
Ensure that you are logged in as a user with Administrator privileges.
Stop all Oracle-related services and all Oracle programs.
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
        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
           \Uninstall
           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.

Reboot your computer.
32-bit on Win95/Win98
Stop all Oracle programs.
Start the ODBC administrator applet, if installed, and remove any Oracle DSN definitions.
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 Windows
       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

Reboot you computer.
16-bit

The default Oracle Home for Windows 3.X is orawin.

If the database is running, then shut it down.
Deinstall all Oracle products with the Oracle Installer.
1. Run orainst.exe from your Oracle Home. The Oracle Software Asset Manager window is displayed.
2. Select all of the Oracle products that are listed in the right window pane.
3. Click the [REMOVE] button.
Delete your ORACLE_HOME directory.
Use your favorite text editor and edit win.ini.
1. Locate the ora_config parameter. Remove the file that ora_config points to.
2. Delete all references to Oracle from the win.ini file.

Search Words

WINNT, WIN95, WIN98, REMOVE, DEINSTALL, CLEAN, DELETE, CLIENT, MACHINE, WIN
.

Date sent:              Wed, 30 Aug 2000 00:00:39 -0800
To:                     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Send reply to:          ORACLE-L_at_fatcity.com
Organization:           Fat City Network Services, San Diego, California

Here are instructions that were once posted. I haven't tried it myself, but at quick glance, it looks right. /Deb

-----Original Message-----
Sent: Wednesday, January 12, 2000 11:26 PM To: Multiple recipients of list ODTUG-DES2K-L

This procedure has worked really well for me. both NT and Win9x versions here.

In rare (yeah, right) situations, some users may want to correct serious system problems by completely removing Oracle products from their systems. This is not recommended as an easy way to fix problems, especially common ones. Only create a Clean Machine as a last resort and only if you want to remove all Oracle products from your system.

· Note: The following Clean Machine instructions assume an OFA (Optimal Flexible Architecture) structure.
· Warning : This will remove all Oracle products, Oracle services and Oracle registry entries from your computer.

On Windows NT:

Ensure you are logged in as a user with Administrator privileges
Using regedit go to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE and delete the ORACLE key.
Delete HKEY_LOCAL_MACHINE\SOFTWARE\odbc
Open HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and remove all keys under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services that begin with ORACLE
Open HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\Application and remove all keys under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\Application that begin with ORACLE.
Close regedit
From the Control Panel, open System
If JRE was installed by Oracle, remove the %ORACLE_HOME%\BIN path and the JRE path. For example, you may see a path similar to this one: C:\ORACLE\ORA81\BIN; C:\Program Files\Oracle\jre\1.1.7\bin. Go to Start > Control Panel>System Environment tab. Click on the system variable path and modify the path.
Delete Icons form <system_drive>:\Winnt\Profiles\All Users\Start Menu\Programs\Oracle -<HOME> and <system_drive>:\Winnt\Profiles\All Users\Start Menu\Programs\Oracle Installation Products. Where <HOME> is the previous HOME name.
Delete <system_drive>:\Program Files\Oracle (from Windows NT Explorer or from the command prompt)
Reboot your computer.
Delete all ORACLE_BASE directories. (you can find the Oracle Homes listed in KEY_LOCAL_MACHINE\SOFTWARE\ORACLE_HOMES).

On Windows 95 and Windows 98:

In regedit, go to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE.
Delete the ORACLE key.
Delete HKEY_LOCAL_MACHINE\SOFTWARE\odbc
Edit your AUTOEXEC.BAT file and remove your %ORACLE_HOME%\bin and JRE paths from the path setting
From the Windows Explorer or from the command prompt; delete the Oracle directory (Oracle Base)
Delete <system_drive>:\Program Files\Oracle (from Windows Explorer or the command prompt)
Delete Icons from <system_drive>:\Windows\Start Menu\Programs\Oracle - <HOME> and <system_drive>:\Windows\Start Menu\Programs\Oracle Installation Products where <HOME> is the previous HOME name.
Reboot your computer.

Trudy

At 11:14 AM 01/12/2000 -0800, you wrote:

>Hi!
>
>If you want to completely remove Oracle from the machine the easiest is to

delete the ORAWINxx directory and any reference to it in the environment path AND also remove the entries from the Registry - HKEY_LOCAL_MACHINE --> SOFTWARE --> ORACLE

>
>Amin Adatia (CogniCASE )
>Cellular (613)282-8300
>PSC Phone   (613) 943-7722
>
>>>> Stanislav Rabinovich <slava_at_pop.dn.net> 2000/01/12 13:56:22 >>>
>Hello everybody,
>I am brand new in database design, and I started Oracle 8 Personal Edition
>on my personal computer under Windows 98.
>Yesterday I tried to do backup and recovery procedures by using
>Backup and Recovery managers, and my database is completely crashed now...
>Since I need to have some demo-databases, I decided to reinstall Oracle 8.
>If I am doing that over the old installation, I have some problems during
>the installation process, and Oracle works not correctly (for example
>import from MS Access doesn't work).
>So, now I am looking for correct UNinstallation procedure of Oracle 8 PE
>under Windows 98. If I see in ADD/REMOVE programs Setting menu of Windows

98,
>I don't see Oracle here at all.
>If somebody have such experience or read about that in the Internet, give me

>a link please. Thanks in advance for your help,
>
>-- Stanislav Rabinovich
>.
>
>--
>Author: Stanislav Rabinovich
>  INET: slava_at_pop.dn.net
>--
>Author: Amin Adatia
>  INET: Amin.Adatia_at_psc-cfp.gc.ca
===========================

Trudy Curtis
TruBear Custom Design Inc.

--
Author: Trudy A. Curtis
  INET: curtist_at_telusplanet.net
--
Author: Debbie Lennartsson
  INET: deb_at_adaptivepartners.com
---end---

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
  INET: PierceED_at_csus.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu May 03 2001 - 14:17:39 CDT