Deleting Oracle SID

Download as doc, pdf, or txt
Download as doc, pdf, or txt
You are on page 1of 2

Re: How to remove Oracle service

To remove Oracle Service from your Windows system,

> go to Start
> click Run
> In the command prompt, type: oradim -delete -sid SID

where SID is the sid of your database, as it appears when you type
net start | more (you should get an "OracleServiceSID")

> press Enter

Re: How to remove Oracle service


Follow the steps below to remove Oracle -

The simplest way to remove Oracle is to run the Oracle installer:


Start > Programs > Oracle Installation Products > Universal Installer
On the first screen that appears, click on "Deinstall Products..."
Expand the tree view (as the second level is visible) and select everything that is selectable.
Click "Remove..."
On the confirmation screen, click "Yes"
Click "Close" when finished and then "Exit" to quit the installer

The Oracle installer removes most of the components but it leaves many traces behind. In order
to completely remove all traces of Oracle, some additional steps needs to be taken:

Start > Settings > Control Panel > Services.


Look for any services with names starting with 'Oracle'.

Start > Run > type "regedit", click "OK"

Find and delete the following keys:

HKEY_LOCAL_MACHINE
\SOFTWARE
\ORACLE

HKEY_LOCAL_MACHINE
\SYSTEM
\CurrentControlSet
\Services
\EventLog
\Application
\Oracle.oracle

Note: some users also have registry entries saved under


HKEY_CURRENT_USER\SOFTWARE\ORACLE, which may be created by some Oracle
utilities. If it exists then delete it.

Delete the Oracle home directory:


"C:\Oracle"
This will also remove your database files (unless you located them elsewhere, in which case you
will need to delete them separately).

Delete the Oracle program Files directory:


"C:\Program Files\Oracle"

Delete the Oracle programs profile directory:


"C:\Documents and Settings\All Users\Start Menu\Programs\Oracle - OraHome90"

If you didn't first run the Oracle Installer to remove Oracle then you may have some references
to Oracle left in the path.
To remove these: Start > Settings > Control Panel > System > Advanced > Environment
Variables. look at both the use and system variable 'PATH' and edit them to remove any
references to Oracle.

To uninstall Oracle service -

• You can uninstall all the Oracle components and services using OUI (Oracle Universal
Installer).

• Delete the HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE key which contains


registry entries for all Oracle products by using regedit.
• Delete any references to Oracle services/components in the following registry location:
HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/. Looks for key
entries that starts with “Ora” which are obviously related to Oracle.
• Reboot the workstation.
• Delete the ORACLE_BASE directory. (i.e C:\Oracle)
• Delete the C:\Program Files\Oracle directory.
• At the end, empty the temp directory and the recycle bin.

You might also like