Oracle/MSSQL/MySQL

How to uninstall Oracle Database 11G or 12c

As you all are aware, the process of uninstalling Oracle on Windows is totally different from the traditional step used in uninstalling a program in Windows. The following steps are vital in order not to encounter an error when reinstalling oracle unto the Server. The uninstallation process is similar to uninstalling Oracle to that of Oracle Database 11g.

Step 1Delete the Associated Environment Variable
– Deleting the environment variable would definitely mitigate a whole lot of errors if your plan to re-install the Oracle software.

Many times installation gets stuck due to PRVF-3929 error stating that “Environment variable path is too long”. In order to avoid this error and to ensure the glitch-free installation of Oracle software, it’s recommended to delete the environment variable entry of your Oracle Home.

How to Delete Environment Variable
– Right-click your Computer Icons and Select “Properties”.
– Then from the left-hand side panel of the System Properties Windows
– Select “Advanced System Settings”.
This will open up “System Properties” Windows.

Inside the “System Properties” Windows
– Navigate to “Advance” Tab and select “Environment Variable”

On the “Environment Variable” Window inside the “System Variable Section” Find entry with the name “Path”, then double click and open it. This step will open up an “Edit System Variable” dialogue box.
– On that dialogue box under the “Variable value field” find your Oracle Home entry and Delete it.

C:\oracle\product\11.2.0\bin
C:\oracle\product\OPatch\

Step 2 – Delete Registries: During the installation, oracle database makes some registries in windows system to store the information of its configurations as well as for proper functioning of Oracle Windows Services. To Uninstall Oracle Database 12c completely from your system you need to properly stop all the Oracle database services which run in the background. Also if you are planning for re-installing the Oracle Database software then you also need to delete all the configuration settings.

In short to ensure the smooth and errorless re-installation of any version of oracle database software, without formatting your computer system, you need to delete all the Oracle Database Registries.

Registries are very fragile part of any windows system thus messing with them can be catastrophic and can harm your system therefore be careful while deleting them. I would highly suggest you to take their backup.

How to Delete the Oracle Registries: To delete any registry you need to first access them and in windows all the registries are placed inside the “Registry Editors”. To access the Registry Editor first open up your Run Dialogue Box by pressing Run Windows Key and ‘R’ key simultaneously or you can directly search RUN in your start menu.

From the run window or search button, type “regedit.exe”. For more information on “Windows registry”, see https://techdirectarchive.com/2020/02/08/what-is-registry-editor-and-how-to-access-the-registry-hives/

regedit.exe

Once you have your Run Dialogue box opened then write “regedit” into it and press enter. This will open your “Registry Editor”. Now first we have to delete the “Oracle Software” Registry. To access this registry first go the following key.

- HKEY_LOCAL_MACHINE
- SOFTWARE
- ORACLE
Once you have reached this directory, right click and Delete it.

Next, we have to delete all the registries for Oracle Database Services. To access these registries first go to the following key.

- HKEY_LOCAL_MACHINE
- Systems
- CurrentControlSet and then
- Services.

Under the Services directory you have to find all the Registries which are responsible for your oracle database services. If Oracle Database 12c is the only product from Oracle that is installed on your system then search for all the registries whose names start with Oracle and Delete them. If you have other products from Oracle installed on your system then be careful and delete accordingly. In the screenshot below you can see some general Oracle Service Registries.

- HKEY_LOCAL_MACHINE
- SYSTEM
- CurrentControlSet
- SERVICES

Step 3 – Restart your system: Next you have to restart your system so that your operating system can blend in all the settings which we just altered

Step 4 – Delete the Oracle Home Directory: An Oracle home is a directory into which all Oracle software is installed. Once you have deleted all the registries of oracle database 12c you are free to delete the oracle home directory from your system.

In order to delete Oracle Home open up your computer and go to your C drive as well as any other drive where you have installed your oracle database 12c. Now go to APP directory, then to the directory with your username here select all the files and delete them. If you want to save backups then do not delete flash_recovery_area.

If in case your folder is not getting deleted then don’t worry. First try to refresh your system or you can also reboot the system then try deleting again. If it is still not deleting then re-check the services and registries and see whether you have deleted all the oracle registries or not. If not then delete those that are still left and then try deleting the Oracle database folder again.

Step 5 – Delete Directory from Program File: Next go to your program file directory and search for the folder with the name Oracle. I have one here and then delete it.

Step 6 – Delete Directory from Start Menu: Next you have to delete the directory from the Start menu as shown below. For that go to and here search for your Oracle Folder and delete it.

C:\ProgramData\Microsoft\Windows\Start Menu\Programs

Step 7 – Clear the Temporary files and Recycle bin: Again open your Run dialogue box and write %temp% this will open the temporary folder and here delete all the files. Next come to your desktop and empty your recycle bin.

Step 8 – Delete the Oracle user: The last step is to delete the oracle home user which we created during the installation of the oracle database. In order to do so, right-click “Computer Icon” and select “Manage”. Inside the computer management window click “Local User Groups” and then click and open “Users” folders.

From the list of the user, you can delete the ones which you have created as an oracle home user during the installation. In my case, its RebellionRider, right-click and select Delete.

For more info, see the following link here . I hope you found this blog post helpful. If you have any questions, please let me know in the comment session.

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x