Whew.....Here is a slightly quicker version. After making all necessary
backups, especially the registry. Stop all your Oracle services, uninstall
the Oracle software, delete all the Oracle folders and remove your Oracle
.ini files from Win NT boot directory.
Then use Registry Ripper http://www.techweb.com/winmag/columns/powertools/ptripper.htm
, excellent freeware to easily find all of the Oracle entries, including
all the services. (Registry Ripper will allow you to restore the deleted
entries)
When you reboot, all of the services and Oracle entries will be gone.
A clean machine.... You can also clean the orphan dll's from your system
using the excellent free AnalogX
- Downloads [DLL Archive] this also will allow you to restore removed
dll's.
Also here are some other excellent free NT system utilities PricelessSystemUtilities:
the best in Windows © System Utilities Freeware .
Charles Yuan
Oracle DBA
charlesy_at_planetsql.com
918 744 4333
"Eric D. Pierce" wrote:
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
-------
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].
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.
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 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
11. Reboot you computer.
C. 16-bit
---------
The default Oracle Home for Windows 3.X is orawin.
1. If the database is running, then shut it down.
2. Deinstall all Oracle products with the Oracle
Installer.
a) Run orainst.exe from your
Oracle Home. The Oracle Software
Asset
Manager window is displayed.
b) Select all of the Oracle
products that are listed in the
right
window pane.
c) Click the [REMOVE] button.
3. Delete your ORACLE_HOME directory.
4. Use your favorite text editor and edit win.ini.
a) Locate the ora_config
parameter.
Remove
the file that ora_config points to.
b) Delete all references
to Oracle from the win.ini file.
Search Words
------------
WINNT, WIN95, WIN98, REMOVE, DEINSTALL, CLEAN, DELETE, CLIENT,
MACHINE, WIN
.
Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved.
Legal Notices and Terms
of Use.
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:
1) Ensure you are logged in as a user
with Administrator privileges
2) Using regedit go to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
and delete the
ORACLE key.
3) Delete HKEY_LOCAL_MACHINE\SOFTWARE\odbc
4) Open HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
and remove all
keys under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services that
begin
with ORACLE
5) 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.
6) Close regedit
7) From the Control Panel, open System
8) 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.
9) 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.
10) Delete <system_drive>:\Program Files\Oracle
(from Windows NT Explorer
or from the command prompt)
11) Reboot your computer.
12) 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:
1) In regedit, go to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE.
2) Delete the ORACLE key.
3) Delete HKEY_LOCAL_MACHINE\SOFTWARE\odbc
4) Edit your AUTOEXEC.BAT file and remove
your %ORACLE_HOME%\bin and JRE
paths from the path setting
5) From the Windows Explorer or from
the command prompt; delete the Oracle
directory (Oracle Base)
6) Delete <system_drive>:\Program
Files\Oracle (from Windows Explorer or
the command prompt)
7) 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.
8) 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 Fri May 04 2001 - 23:18:39 CDT
