Thanks a lot, Joe. Since I backed up my registry before I installed Oracle,
I can probably just import the backed-up registry and save myself some time.
We'll see how it goes!
Cheers,
JoJo
-----Original Message-----
Sent: Saturday, January 12, 2002 5:45 AM
To: Multiple recipients of list ORACLE-L
here you go, save it, i'm sure you'll need it in the future, i dont do
oracle database on windoze but support the clients.
---cut here-----------
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>&
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.
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 W.
indows
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.
Reference:
----------
Cleanly Uninstalling Oracle8i RDBMS Software from
Unix.
---------------- cut here--------------
JoJo Al-Zawawi wrote:
> Hi Joe,
>
> Please mail me the "metalstink" thing -- I've never heard of it. I agree
> that it sounds like I need to do a brutal erase.
>
> Bwaaaaa !!!
>
> Thanks in advance!
> --JoJo
>
>
> -----Original Message-----
> Sent: Friday, January 11, 2002 7:45 PM
> To: Multiple recipients of list ORACLE-L
>
>
> sounds like you need to do the brutal erase of all oracle products from
> a windoze machine. THere is a document on metalstink about how to
> remove oracle entirely from a windoze machine, if you dont have
> metalstink access let me know, i'll email it to you direct.
>
> joe
>
>
> JoJo Al-Zawawi wrote:
>
>
>>Hi all,
>>
>>I just tried to install Oracle 9i personal edition for Win98 on my Win98
>>
> PC.
>
>>After quite a bit of installation, it got to a part where it was creating
>>some database or something, and I got an error: "The program encountered
>>
> an
>
>>invalid page exception. Fault location: 0028:0022 Interrupts in service:
>>None" And it advised me to reboot, which I did.
>>
>>Now I cannot get the installation program to re-start, no matter what I
>>
> do,
>
>>from the CD-ROM, from the computer, from running various programs on the
>>CD-ROM, what have you. I can't un-install it because (a) it doesn't show
>>
> up
>
>>on Windows' uninstall list and (b) the Oracle installer won't run.
>>
>>It starts to run (a brief flash of the "installer" graphic), then the
>>
> CD-ROM
>
>>quits and nothing happens.
>>
>>Any ideas?
>>
>>Thanks,
>>JoJo
>>
--
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Testa
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: JoJo Al-Zawawi
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
