Search

Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Thursday, 7 August 2014

How to Remove Oracle services from Windows

If you have uninstall the Oracle software from your system, but, the services are not removed. This resulted, when you are trying to install oracle back and trying to configure your Instance as old name is not allowed.
Method1:
To remove OracleService , go to the command prompt and 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")
Method2:
If you have the resource kit, you can use delsrv.exe to remove the listener service.
If you don't have the resource kit, you can download delsrv.exe from Microsoft Support: http://www.microsoft.com/windows2000/tec…
Method3:
Go to Registry (Type regedit on RUN)
Take a backup of Registry. (For the backup Click on file menu on Registry and export your registry backup any location so whenever required you can import your old registry.)
Now go to registry HKEY_LOCAL_MACHINE
Then go to system –> current control set –> services
From there you can remove oracle services (directly selecting and pressing delete)

Manually removing all Oracle Components and services from your system
These instructions remove all Oracle components, services, and registry entries from your computer. In addition, any database files in the subdirectories under ORADATA and oracle network configuration files, user made scripts or any other stored scripts are also removed.
WARNING:
It is not recommended, remove all Oracle components from your computer manually only as a last option.
Exercise extreme care when removing registry entries. Removing incorrect entries can severely compromise your computer.
On Windows NT/Windows 2000/Windows XP:
1. Login with Administrator Privilege user.
2. Then first stop all the running Oracle services. To list the services either goes to Control Panel > Services or type in RUN services.msc then if any oracle services exist have the status started simply right click on the services and press stop.
3. Now start the registry just type on RUN regedit and Go to the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE












Note the value of the key INST_LOC, this is the location of the Oracle Universal Installer. The default location is C:\Program Files\Oracle\Inventory. If this value is different, make note of it, will be deleted later or Delete this ORACLE key.
From HKEY_LOCAL_MACHINE\SOFTWARE\ODBC remove all keys related with the "Oracle ODBC Driver"
From HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services remove all keys that begin with ORACLE or ORAWEB.
From HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\Application remove all keys that begin with ORACLE.
From HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Uninstall remove any entries related to Oracle.
From HKEY_CLASSES_ROOT, remove all keys that begin with Oracle, OraPerf or OraoleDB
4. Do not forget to Clean up the environment settings. Go to Control Panel > System > Environment tab check out the below screenshot.





















Click on the variable PATH in order to modify the value
– Check if the %ORACLE_HOME% was installed, remove this %ORACLE_HOME%\bin path.
– Check if JRE was installed by Oracle, remove the JRE path.
– Check if there is a CLASSPATH variable make note, then delete it. This can be added back at
a later if needed.
– Check if there are any other Oracle variables exist, delete them also.
5. Delete the software and icons:
Note: These locations depend on the OS or whether it is upgraded or this was a fresh install
6. After deleting oracle installed file from hard drive, reboot your computer.
On Unix/Linux:
­This method is not recommended better to use Oracle Universal installer (OUI)
rm -rf $ORACLE_HOME
rm -rf /etc/ora*
rm -rf /path/to/your/oraInventory
rm -f /usr/local/bin/coraenv
rm -f /usr/local/bin/oraenv
rm -f /usr/local/bin/dbhome

1 comments:

  1. oradim saved my day today....as I'm not often working with Oracle on Windows this was a great find. Thank you for your effort to put this information on the web!

    ReplyDelete