Confessions of an Oracle Database Junkie - Arup Nanda
The opinions expressed here are mine and mine alone. They may not necessarily reflect that of my employers and customers - both past or present. The comments left by the reviewers are theirs alone and may not reflect my opinion whether implied or not. None of the advice is warranted to be free of errors and ommision. Please use at your own risk and after thorough testing in your environment.

Pages

Wednesday, September 02, 2009

Oracle 11g R2 Features

Continuing on the previous posts, here is another gee-whiz feature of 11gR2 - the "deinstall" feature. Yes, that's right the deinstall one. Sometimes installations fail; sometimes you have to deinstall something to clean out the server for other use. Sometimes, I did, you have to clean out beta code to install production code. A deinstall utility stops all the processes, removes all the relevant software and components (such as diskgroups), updates all config files and make all necessary modifications to the other files. All these are done without you ever bothering about remnants that may cause issues later.

You have to download the deinstall software from 11gR2 download from OTN. Choose "see all" to get to that software.

Checking for existence of the Oracle home location /opt/oracle/product/11.2/grid1Oracle Home type selected for de-install is: SIHAOracle Base selected for de-install is: /opt/oracleChecking for existence of central inventory location /opt/oracle/oraInventoryChecking for existence of the Oracle Grid Infrastructure home /opt/oracle/product/11.2/grid1

Automatic Storage Management (ASM) instance is detected in this Oracle home /opt/oracle/product/11.2/grid1.ASM Diagnostic Destination : /opt/oracleASM Diskgroups : +DATA1,+FRA1Diskgroups will be droppedDe-configuring ASM will drop all the diskgroups and it's contents at cleanup time. This will affect all of the databases and ACFS that use this ASM instance(s).

After some initial question and answer it shows a summary of activities and prompts you for a confirmation:

####################### CHECK OPERATION SUMMARY #######################Oracle Grid Infrastructure Home is: /opt/oracle/product/11.2/grid1The cluster node(s) on which the Oracle home exists are: (Please input nodes seperated by ",", eg: node1,node2,...)nullOracle Home selected for de-install is: /opt/oracle/product/11.2/grid1Inventory Location where the Oracle home registered is: /opt/oracle/oraInventoryFollowing Oracle Restart enabled listener(s) will be de-configured: LISTENERASM instance will be de-configured from this Oracle homeDo you want to continue (y - yes, n - no)? [n]: yA log of this session will be written to: '/opt/oracle/oraInventory/logs/deinstall_deconfig2009-09-02_02-12-22-PM.out'Any error messages from this session will be written to: '/opt/oracle/oraInventory/logs/deinstall_deconfig2009-09-02_02-12-22-PM.err'

After you press "y", it starts the operation of a clean deinstallation. The output continues as shown below: