Removing Oracle Database 11g home on Linux

This document describes the procedure to remove the Oracle Database 11g Home using  storage type ASM on Oracle Linux 6.5.

Starting with Oracle Database 11g Release 2 , Oracle recommends that you use the deinstallation tool to remove the entire Oracle home associated with the Oracle Database, Oracle Clusterware, Oracle ASM, Oracle RAC, or Oracle Database client installation. Oracle does not support the removal of individual products or components.

Identify all instances associated with the Oracle home that you want to remove.

[oracle@oracle123 ~]$ cat /etc/oratab
+ASM:/u02/app/oracle/product/12.1.0/grid:N

db11g:/u01/app/oracle/product/11.1.0/db_1:N

Oracle recommends to run the deinstallation tool as the Oracle software installation owner usually as oracle user.

After executing deinstall tool, it will prompt for list of Databases , Type of Database, list of Nodes, Diagnostic destination and Storage type used by Database.
All info marked in RED to be prompted.


[oracle@oracle123 ~]$ cd /u01/app/oracle/product/11.2.0/db_1/deinstall/
[oracle@oracle123 deinstall]$ ls -l
total 92
-rwxr-xr-x. 1 oracle oinstall  9780 May 10  2011 bootstrap.pl
-rwxr-xr-x. 1 oracle oinstall  9658 Mar 21 09:47 deinstall
-rwxr-xr-x. 1 oracle oinstall 18841 Jan 29  2013 deinstall.pl
-rw-r--r--. 1 oracle oinstall  3466 Aug 18  2010 deinstall.xml
drwxr-xr-x. 2 oracle oinstall  4096 Mar 21 09:42 jlib
-rw-r--r--. 1 oracle oinstall   409 Aug 18  2010 readme.txt
drwxr-xr-x. 2 oracle oinstall  4096 Mar 21 09:42 response
-rwxr-xr-x. 1 oracle oinstall 32343 Dec 16  2009 sshUserSetup.sh

[oracle@oracle123 deinstall]$ ./deinstall
Checking for required files and bootstrapping ...
Please wait ...
Location of logs /u01/app/oraInventory/logs/

############ ORACLE DEINSTALL & DECONFIG TOOL START ############


######################### CHECK OPERATION START #########################
## [START] Install check configuration ##


Checking for existence of the Oracle home location /u01/app/oracle/product/11.2.0/db_1
Oracle Home type selected for deinstall is: Oracle Single Instance Database
Oracle Base selected for deinstall is: /u01/app/oracle
Checking for existence of central inventory location /u01/app/oraInventory
Checking for sufficient temp space availability on node(s) : 'oracle123.localdomain'

## [END] Install check configuration ##


Network Configuration check config START

Network de-configuration trace file location: /u01/app/oraInventory/logs/netdc_check2016-03-24_08-32-09-AM.log

Network Configuration check config END

Database Check Configuration START

Database de-configuration trace file location: /u01/app/oraInventory/logs/databasedc_check2016-03-24_08-32-12-AM.log

Use comma as separator when specifying list of values as input

Specify the list of database names that are configured in this Oracle home [db11g]: db11g

###### For Database 'db11g' ######

Specify the type of this database (1.Single Instance Database|2.Oracle Restart Enabled Database) [2]: 2
Specify the list of nodes on which this database has instances [oracle123]: oracle123
Specify the diagnostic destination location of the database [/u01/app/oracle/diag/rdbms/db11g]: 
Specify the storage type used by the Database ASM|FS []: ASM


Database Check Configuration END

Enterprise Manager Configuration Assistant START

EMCA de-configuration trace file location: /u01/app/oraInventory/logs/emcadc_check2016-03-24_08-32-55-AM.log 

Checking configuration for database db11g
Enterprise Manager Configuration Assistant END
Oracle Configuration Manager check START
OCM check log file location : /u01/app/oraInventory/logs//ocm_check3684.log
Oracle Configuration Manager check END

######################### CHECK OPERATION END #########################


####################### CHECK OPERATION SUMMARY #######################
Oracle Home selected for deinstall is: /u01/app/oracle/product/11.2.0/db_1
Inventory Location where the Oracle home registered is: /u01/app/oraInventory
The following databases were selected for de-configuration : db11g
Database unique name : db11g
Storage used : ASM
Will update the Enterprise Manager configuration for the following database(s): db11g
No Enterprise Manager ASM targets to update
No Enterprise Manager listener targets to migrate
Checking the config status for CCR
Oracle Home exists with CCR directory, but CCR is not configured
CCR check is finished
Do you want to continue (y - yes, n - no)? [n]: y
A log of this session will be written to: '/u01/app/oraInventory/logs/deinstall_deconfig2016-03-24_08-32-06-AM.out'
Any error messages from this session will be written to: '/u01/app/oraInventory/logs/deinstall_deconfig2016-03-24_08-32-06-AM.err'

######################## CLEAN OPERATION START ########################

Enterprise Manager Configuration Assistant START

EMCA de-configuration trace file location: /u01/app/oraInventory/logs/emcadc_clean2016-03-24_08-32-55-AM.log 

Updating Enterprise Manager Database Control configuration for database db11g
Updating Enterprise Manager ASM targets (if any)
Updating Enterprise Manager listener targets (if any)
Enterprise Manager Configuration Assistant END
Database de-configuration trace file location: /u01/app/oraInventory/logs/databasedc_clean2016-03-24_08-33-02-AM.log
Database Clean Configuration START db11g
This operation may take few minutes.
Database Clean Configuration END db11g

Network Configuration clean config START

Network de-configuration trace file location: /u01/app/oraInventory/logs/netdc_clean2016-03-24_08-33-21-AM.log

De-configuring Local Net Service Names configuration file...
Local Net Service Names configuration file de-configured successfully.

De-configuring backup files...
Backup files de-configured successfully.

The network configuration has been cleaned up successfully.

Network Configuration clean config END

Oracle Configuration Manager clean START
OCM clean log file location : /u01/app/oraInventory/logs//ocm_clean3684.log
Oracle Configuration Manager clean END
Setting the force flag to false
Setting the force flag to cleanup the Oracle Base
Oracle Universal Installer clean START

Detach Oracle home '/u01/app/oracle/product/11.2.0/db_1' from the central inventory on the local node : Done

Delete directory '/u01/app/oracle/product/11.2.0/db_1' on the local node : Done

Delete directory '/u01/app/oracle' on the local node : Done

Oracle Universal Installer cleanup was successful.

Oracle Universal Installer clean END


## [START] Oracle install clean ##

Clean install operation removing temporary directory '/tmp/deinstall2016-03-24_08-31-44AM' on node 'oracle123'

## [END] Oracle install clean ##


######################### CLEAN OPERATION END #########################


####################### CLEAN OPERATION SUMMARY #######################
Updated Enterprise Manager configuration for database db11g
Successfully de-configured the following database instances : db11g
Cleaning the config for CCR
As CCR is not configured, so skipping the cleaning of CCR configuration
CCR clean is finished
Successfully detached Oracle home '/u01/app/oracle/product/11.2.0/db_1' from the central inventory on the local node.
Successfully deleted directory '/u01/app/oracle/product/11.2.0/db_1' on the local node.
Successfully deleted directory '/u01/app/oracle' on the local node.
Oracle Universal Installer cleanup was successful.

Oracle deinstall tool successfully cleaned up temporary directories.
#######################################################################



############# ORACLE DEINSTALL & DECONFIG TOOL END #############

Now your Database home has been removed successfully. verify the /etc/oratab file and remove oracle home path if still exist.

Thanks