how to uninstall oracle 11g

Remove Oracle 11g: A Step-by-Step Guide

By James Wilson
AD

Uninstalling Oracle 11g involves careful planning and execution. The process can be complex, and discrepancies can cause database issues. This step-by-step guide will walk you through the process, ensuring minimal disruption to your system.

Before proceeding, ensure you have the necessary credentials, specifically the ORACLE_SID and ORACLE_HOME details. Also, always backup your data before making such significant changes to your system. Let's dive into the process.

Pre-Uninstallation Checks and Preparations

adequate preparation is key to a trouble-free un-installation process. Let's go through the necessary checks and preparations:

AD
How to Install Oracle 11g R2 in Debian 7,8 Linux Mint 17.2 and Ubuntu 14.04,15.04,16.04
How to Install Oracle 11g R2 in Debian 7,8 Linux Mint 17.2 and Ubuntu 14.04,15.04,16.04
How to Disable/Enable Encryption Oracle Remediation Within Windows 10?
How to Disable/Enable Encryption Oracle Remediation Within Windows 10?
Install Oracle Database Server on Windows
Install Oracle Database Server on Windows

Step 1: Verify that your system meets the un-installation requirements. Oracle 11g can be un-installed on any platform where it was originally installed.

Verify Software Accessibility

Make sure that the Oracle software is present in your system. Check if the directory named '$ORACLE_HOME' exists and includes the subdirectories 'bin', 'admin', and 'sqlplus'.

Oracle Unlock Account
Oracle Unlock Account
Install Oracle Database Server on Windows
Install Oracle Database Server on Windows

Note: The ORACLE_HOME location is crucial for the un-installation process. If it's not sure, you can find it using the following command:

$ echorasid homogenizedPATHORACLEHOMEREPLICATEоматическийсрекрингрепи شائعbbero8653orum/OMRORACLEHOME/

AD

Backup Your Data

Safely backup your Oracle data before proceeding with the un-installation. This can be done using the following commands:

$expdp system/manager file=FULLBACKUPOFYOURDATABASE.dmp

Uninstalling Oracle 11g

Now that you've completed the initial checks and preparations, let's proceed with the actual un-installation:

Step 1: Shutdown the Oracle Database. Remember to upgrade to a newer version before un-installing. You can do this by running:

$ORACLE_HOMEbinoraclesuid

Uninstall Oracle Homes

After successfully shutting down the database, un-install the Oracle homes by executing:

$ORACLE_HOMErootshorauninstall -silent -responseFile silent.rsp

Note: Make sure you specify the correct ORACLE_HOME with the path details mentioned earlier.

Remove Installation Directories

After successful un-installation of Oracle homes, remove the following directories:

  • ORACLE_HOME: Directories created during the installation of Oracle clients.
  • $ORACLE_HOMEnetworkadmin: Directory containing network database configuration files.
  • $ORACLE_HOMERDBMS: This directory contains the RDBMS software.

Post-Uninstallation Steps

Following a successful un-installation, you'll need to verify the complete removal of Oracle 11g and its components from your system:

Step 1: Check if the ORACLE_HOME directory and its subdirectories are deleted. If not, manually remove them.

Check for Remaining Oracle Components

Run the following command to ensure that there are no remaining Oracle components:

$ls -la /etc/oratab
$ls -la /etc/init.d/oracle

Finally, remember that un-installing Oracle 11g doesn't delete the data that was in your Oracle home directory. To completely clear your system, you might need additional steps based on your specific use-case. As always, maintain good backups, and consider seeking professional help if you're unsure about any part of the un-installation process.

AD