Deinstall an Oracle Home

In my experience, the Deinstall utility which ships with the full client or db download is a bit flakey, and there is a cleaner, more reliable alternative available.

There is an External Deinstall Utility available for download from OTN here.

For full instructions on how to use the Deinstall Utility see metalink note How To Deinstall/Uninstall Oracle Home In 11gR2 [ID 883743.1]

De-installing Oracle Home using external de-install utility

1. Download and unzip de-install utility in some folder outside Oracle Home.
2. Go to the deinstall folder.
3. Invoke deinstall utility with the -home option specifying the full path of the Oracle Home you want to deinstall.

Example:

In linux

% ./deinstall -home /u01/app/oracle/product/11.2.0/dbhome_2

in Windows:

start deinstall.bat -home E:\oracle\product\11.2.0\dbhome_1

4. If you want to do a non-interactive deinstall you can use the -silent option with a parameter file.

Example:

%./deinstall -home /u01/app/oracle/product/11.2.0/dbhome_2 -silent <path for response file>

An example response file is located in /deinstall/response/deinstall.rsp.tmpl. You can modify and use it.

5. Check the logs created under <central_inventory>/logs folder for any issue.
6. Check the inventory is updated properly.
7. Check if Oracle Home folder is deleted or not. If not then you have to remove it manually.

LOG LOCATION
– deinstall tool creates logs as per this logic:

a) If there are other oracle home (OUI based) in this Host except one which you are installing then it will create log under <central_inventory>/log folder.
b) If this is last Oracle Home to be deinstalled then current central inventory will also get deleted along with deinstall , therefore in this case it will choose log locations in the following order:
– It will create log directory in current location where deinstall utility is launched.
– If current folder is not writable or remotely mounted (permission issues ) then it will create user home directory (/home/oracle) as next option.
– If all criteria above is not met then it will proceed to create log directory under user TEMP location (/tmp).

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

Enterprise Manager Configuration Assistant START

EMCA de-configuration trace file location: E:\deinstall\\logs\emcadc_clean.log

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: E:\deinstall\logs\databasedc_clean2831.log

Network Configuration clean config START

Network de-configuration trace file location: E:\deinstall\logs\netdc_clean2832.log

De-configuring Single Instance listener(s): LISTENER

De-configuring listener: LISTENER
    Stopping listener: LISTENER
    Listener stopped successfully.
    Deleting listener: LISTENER
    Listener deleted successfully.
Listener de-configured successfully.

De-configuring Listener configuration file…
Listener configuration file de-configured successfully.

De-configuring Naming Methods configuration file…
Naming Methods configuration file de-configured successfully.

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 : E:\deinstall\\logs\\ocm_clean645.log
Oracle Configuration Manager clean END
Removing Windows and .NET products configuration START

Removing Windows and .NET products configuration END
Oracle Universal Installer clean START

Stopping service ‘OracleOraDb11g_home1TNSListener’ on the local node : Done

Removing service ‘OracleOraDb11g_home1TNSListener’ on the local node : Done

Failed to delete the file ‘E:\oracle\product\11.2.0\dbhome_1\BIN\oci.dll’. The file is in use.
Failed to delete the directory ‘E:\oracle\product\11.2.0\dbhome_1\BIN’. The directory is not empty.
Failed to delete the directory ‘E:\oracle\product\11.2.0\dbhome_1’. The directory is not empty.
Delete directory ‘E:\oracle\product\11.2.0\dbhome_1’ on the local node : Failed<<<<

Removing oracle home ‘E:\oracle\product\11.2.0\dbhome_1’ from PATH variable on the local node : Done

Oracle Universal Installer cleanup was successful.

Oracle Universal Installer clean END

Oracle install clean START

Oracle install clean END

Moved default properties file E:\deinstall\response\deinstall_noHomeName.rsp as E:\deinstall\response\deinstall_noHomeName.rsp1

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

####################### CLEAN OPERATION SUMMARY #######################
Following Single Instance listener(s) were de-configured successfully: LISTENER
Cleaning the config for CCR
As CCR is not configured, so skipping the cleaning of CCR configuration
CCR clean is finished
Successfully stopped service ‘OracleOraDb11g_home1TNSListener’ on the local node
.
Successfully removed service ‘OracleOraDb11g_home1TNSListener’ on the local node
.
Failed to delete directory ‘E:\oracle\product\11.2.0\dbhome_1’ on the local node
.
Successfully removed oracle home ‘E:\oracle\product\11.2.0\dbhome_1’ from PATH variable on the local node.
Oracle Universal Installer cleanup was successful.

Oracle install successfully cleaned up the temporary directories.
#######################################################################

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

Advertisements

One Response to Deinstall an Oracle Home

  1. while uninstalling oracle 11g on windows 7, oci.dll file left undeleted in app\product\bin folder how to permanently delete this file.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: