My Oracle Support Banner

Oracle Deinstall Utility Drops Database While Deinstalling the ORACLE_HOME - Workaround for How to Keep the Database intact ? (Doc ID 1568557.1)

Last updated on DECEMBER 25, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Oracle Database - Standard Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Generic Linux

Symptoms

This article helps users on how to perform ORACLE_HOME only de-install while preserving the Database associated with it.  Steps shared in this article also talk about creation of responcefile/template and use the same in future de-installtion of other ORACLE_HOME.

Note: De-install Utility  does not  prompt users to skip the DB while removal of ORACLE_HOME, since db removal is the default behaviour of deinstall Utility

Scenario:

De-installation of ORACLE_HOME removes Database without any notice. Intention is to only remove the ORACLE_HOME leaving the DB intact.
Observed that this only happens when ORACLE_HOME being deleted has a DB associated with it (i.e  /etc/oratab  has an a entry of DB and target ORACLE_HOME) 

following are the setup details when this articles is drafted.

ORACLE_HOME=/refresh/product/112db Version:11.2.0.3 ORACLE_BASE=/oracle
ORACLE_SID=CONTENT
Deinstall tool invoked : $ORACLE_HOME/deinstall        

also applicable for the external de-install tool available at the link below for de-install purpose.

Global link:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

Example: How to find the external de-install utility for Linux 86-64
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-linx8664soft-100572.html
Refer : Oracle De-install Utility

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.