8 Removing Oracle Real Application Clusters Software

8.2.1 About the Deinstallation Tool

The Deinstallation Tool (deinstall.bat) is available in the installation media before installation, and is available in Oracle home directories after installation in the directory %ORACLE_HOME%\deinstall. The Deinstallation tool is also available for download from Oracle TechNet (http://www.oracle.com/technology). You can download it with the complete Oracle Database 11g release 2 software, or as a separate archive file.

The deinstall.bat command uses the information you provide, plus information gathered from the software home to create a parameter file. You can alternatively supply a parameter file generated previously by the deinstall.bat command using the -checkonly flag and -o flag. You can also edit a response file template to create a parameter file.

The Deinstallation tool stops Oracle services, instances, and processes, and removes Oracle software and configuration files on the operating system for a specific Oracle home. At the end of the deinstallation process you are prompted to run the rootcrs.pl script as a user that is a member of the Administrators group.

The deinstall.bat command uses the following syntax, where variable content is indicated by italics:

deinstall -home complete path of Oracle home [-silent] [-checkonly] [-local]
[-paramfile complete path of input parameter property file] [-params name1=value
name2=value . . .] [-o complete path of directory for saving files] [-help | -h]
 

The options are:

• -home

  Use this flag to indicate the home path of the Oracle home that you want to check or deinstall. To deinstall Oracle software using the Deinstallation tool located in the Oracle home being removed, provide a parameter file a location outside the Oracle home, and do not use the -home flag.

  If you run deinstall from the Oracle_home\deinstall path, then the -home flag is not required because the tool knows from which home it is being run. If you use the standalone version of the tool, then -home is mandatory

• -silent

  Use this flag to run the command in noninteractive mode. If you use the -silent flag, then you must use the -paramFile flag, and provide a properties file that contains the configuration values for the Oracle home that you want to deinstall or deconfigure.

  You can generate a properties file to use or modify by running deinstall.bat with the -checkonly flag. The deinstall.bat command then discovers information from the Oracle home that you want to deinstall and deconfigure. It generates the properties file, which you can then use with the -silent option

  You can also modify the template file deinstall.rsp.tmpl, located in the response folder of the Deinstallation tool archive or installation.

• -checkonly

  Use this flag to check the status of the Oracle software home configuration. Running the command with the checkonly flag does not remove the Oracle configuration. The checkonly flag generates a properties file that you can use with the deinstall.bat command.

  When you run checkonly to generate a properties file, you are prompted to provide information about your system. You can accept the default value the tool has obtained from your Oracle installation, indicated inside brackets ([]), or you can provide different values. To accept the defaults, click Enter.

• -local

  Use this flag on a multinode environment to deconfigure Oracle software in a cluster.

  When you run deinstall.bat with this flag, it deconfigures and deinstalls the Oracle software on the local node (the node on which you run deinstall.bat). On remote nodes, it deconfigures Oracle software, but does not deinstall the Oracle software.

• -paramfile complete path of input parameter property file

  This is an optional flag. You can use this flag to run deinstall.bat with a parameter file in a location other than the default. When you use this flag, provide the complete path where the parameter file is located.

  The default location of the parameter file depends on the location of the Deinstallation tool:

  • From the installation media or stage location: <Drive>:\staging_location\deinstall\response

  • From a unzipped archive file downloaded from OTN: <Drive>:\ziplocation\deinstall\response, where <Drive>:\ziplocation refers to the directory in which the downloaded archive file was extracted.

  • After installation, from the installed Oracle home: %ORACLE_HOME%\deinstall\response

• -params [name1=value name2=value name3=value . . .]

  Use this flag with a parameter file to override one or more values that you want to change in a parameter file you have already created.

• -o complete path of directory for saving response files

  Use this flag to provide a path other than the default location where the properties file (deinstall.rsp.tmpl) is saved.

  The default location of the properties file depends on the location of the Deinstallation tool:

  • From the installation media or stage location: <Drive>:\staging_location\deinstall\response

  • From a unzipped archive file downloaded from OTN: <Drive>:\ziplocation\response, where <Drive>:\ziplocation refers to the location of the downloaded archive file

  • After installation, from the installed Oracle home: %ORACLE_HOME%\deinstall\response

• -help | -h

  Use the help option (-help or -h) to obtain additional information about the command options and flags.

If you use the deinstall.bat command located in an Oracle home, or the deinstall.bat command downloaded from Oracle TechNet (not installed in an Oracle home), then it writes log files in the C:\Program Files\Oracle\Inventory\logs directory. If, however, you are using the deinstall.bat command to removed the last Oracle home installed on the server, then the log files are written to:

• %TEMP%\OraDeinstall<timestamp>\logs if you use the deinstall.bat command located in the Oracle home

• <Drive>:\ziplocation\deinstall\logs if you use the deinstall.bat command downloaded from Oracle TechNet

8.2.2 Example of Running the Deinstall Command for Oracle RAC

If you use the separately downloaded version of deinstall.bat, then when the deinstall.bat command runs, you are prompted to provide the home directory of the Oracle software that you want to remove from your system. Provide additional information as prompted.

To run the deinstall.bat command located in an Oracle Database home in the path C:\app\oracle\product\11.2.0\dbhome_1, enter the following command while logged in as a member of the Administrators group:

C:\> cd app\oracle\product
C:\app\oracle\product> 11.2.0\dbhome_1\deinstall\deinstall.bat

In the following example, use the deinstall.bat command in the path C:\app\oracle\product\deinstall to deinstall the Oracle home using a parameter file in the software owner location C:\user\oracle:

C:\> cd app\oracle\product\deinstall
C:\deinstall> deinstall -home C:\app\oracle\product\11.2.0\dbhome_1 -paramfile
C:\user\oracle\my_db_paramfile.tmpl

8.2.3 Example of a Deinstallation Parameter File for Oracle RAC

The following is an example of a parameter file, in which the Oracle Database home (Oracle home) is in the path C:\app\oracle\product\11.2.0\dbhome_1, the Oracle base (where other Oracle software is installed) is C:\app\oracle, the central Oracle Inventory home (oraInventory) is C:\Program Files\Oracle\Inventory, the virtual IP address (VIP) is 192.0.2.1, the local node (the node where you are running the deinstallation session from) is node1, and the remote node is node2:

#Copyright (c) 2005, 2006 Oracle Corporation. All rights reserved.
#Wed Feb 11 16:30:21 PST 2009
DISK_GROUPS.typi=
REMOTE_NODES=node2
ORACLE_BASE.typi=C:\app\oracle
STORAGE_TYPE.typi=FS
ASM_HOME=
ASM_LOCAL_SID=
FLASH_RECOVERY_LOC.typi=
LOGDIR=C:\Program Files\Oracle\Inventory\logs\
DB_TYPE.typi=RAC_DB
ORACLE_BASE=C:\app\oracle
INVENTORY_LOCATION=C:\Program Files\Oracle\Inventory
NODE_LIST.typi=node1,node2
ARCHIVE_LOG_DESTINATION_LOC.typi=
ASM_FILES.typi=
LOCAL_SID.typi=typi1
CLUSTER_NODES=node1,node2
DB_UNIQUE_NAME_LIST=typi
RAW_MAPPING_FILE.typi=
ORA_CRS_HOME=C:\app\11.2.0\grid\
HOME_TYPE=RACDB
CRS_HOME=false
SID_LIST.typi=typi1,typi2
DATAFILE_LOC.typi=O:\ocfs\storage\database\oradata\typi
ORACLE_BINARY_OK=true
local=false
LOCAL_NODE=node1
CREATION_MODE.typi=y
CONFIGFILE_LOC.typi=O:\ocfs\storage\database\oradata\typi\control01.ctl,
O:\ocfs\storage\database\oradata\typi\control02.ctl,O:\ocfs\storage\
database\oradata\typi\control03.ctl,C:\app\oracle\product\11.2.0\dbhome_1\
dbs\dr1typi.dat,C:\app\oracle\product\11.2.0\dbhome_1\dbs\dr2typi.dat
DIAG_DEST.typi=C:\app\oracle\diag\rdbms\typi
SPFILE_LOC.typi=O:\ocfs\storage\database\oradata\typi\spfiletypi.ora
silent=true
ORACLE_HOME=C:\app\oracle\product\11.2.0\dbhome_1\