8 Removing Oracle Real Application Clusters Software

8.3.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 Technology Network (OTN) (http://www.oracle.com/technetwork/). 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 and -o flags. 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 default method for running the Deinstallation tool is from the deinstall directory in the Oracle home. For example:

C:\> cd %ORACLE_HOME%\deinstall
C:\..\dbhome_1\> deinstall.bat

In addition, you can run the Deinstallation tool from other locations, or with a parameter file, or select any of the following options when using Deinstallation tool:

• -home

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

  If you run deinstall.bat 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 the -home flag is mandatory

• -silent

  Use this flag to run the command in noninteractive mode. This option requires one of the following:

  • A working system that the Deinstallation tool can access to determine the installation properties

  • A properties file that contains the configuration values for the Oracle home that is being deinstalled or deconfigured

  To create a properties file, modify the template file deinstall.rsp.tmpl, located in the response folder of the Deinstallation tool home or the Oracle home.

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

• -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 Deinstallation tool has obtained from your Oracle installation, indicated inside brackets ([]), or you can provide different values. To accept the defaults, click Enter at each prompt.

• -local

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

  When you run the deinstall.bat command with this flag, it deconfigures and deinstalls the Oracle software on the local node (the node on which you run the deinstall.bat command) for non-shared Oracle home directories.

  Note:

  You cannot use the Deinstallation tool with the -local option for a shared Oracle home.

• -paramfile complete path of input parameter property file

  This is an optional flag. Use this flag to run the deinstall.bat command 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. If you are running the deinstall.bat command from the Oracle home that you plan to deinstall, then you do not need to use the -paramfile option.

  The default location of the parameter file depends on the location of the deinstall.bat command you use:

  Location of deinstall.bat	Default Location of the Parameter File
  In the installation media or stage location:	X:\staging_location\deinstall\response
  From an unzipped archive file downloaded from OTN	X:\ziplocation\deinstall\response where X:\ziplocation refers to the directory into which the downloaded archive file was extracted
  After installation, in 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 in a parameter file that you 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_Oracle_home_name.rsp) is saved.

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

  Location of deinstall.bat	Default Location of the Properties File
  In the installation media or stage location:	X:\staging_location\deinstall\response
  From an unzipped archive file downloaded from OTN	X:\ziplocation\deinstall\response where X:\ziplocation refers to the directory into which the downloaded archive file was extracted
  After installation, in the installed Oracle home	%ORACLE_HOME%\deinstall\response

  
  

• -help

  Use this flag (-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 OTN (not installed in an Oracle home), then the command writes log files in the C:\Program Files\Oracle\Inventory\logs directory. If, however, you are using the deinstall.bat command to remove 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

• X:\ziplocation\deinstall\logs if you use the deinstall.bat command downloaded from OTN

8.3.2 Using the Deinstallation Tool for Oracle RAC

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

If you run the deinstall.bat command outside of the %ORACLE_HOME%\deinstall folder, then help output is displayed, unless you use the -home flag and provide a path to the Oracle home.

If you run the deinstall.bat command from the %ORACLE_HOME%/deinstall folder, then deinstallation starts without prompting you for a home address.

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

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

8.3.3 Example of a Deinstallation Parameter File for Oracle RAC

You can run the deinstall command with the -paramfile option to use the values you specified in a parameter file instead of responding to individual prompts.

#Copyright (c) 2005, 2010 Oracle Corporation. All rights reserved.
LOCAL_NODE=node1
HOME_TYPE=RACDB
ORACLE_BASE=C:\app\oracle
ObaseCleanupPtrLoc=C:\DOCUME~1\oracle\LOCALS~1\Temp\OraDeinstall2010-03-31_
  15-24-53\utl\orabase_cleanup.lst
DB_TYPE.orcl=RAC_DB
silent=false
ORA_CRS_HOME=C:\app\11.2.0\grid\
EMCP.CONFIG_MODE.orcl=CONFIG_DBCONTROL
EMCA_LOG.orcl=C:\app\oracle\cfgtoollogs\emca\orcl
LOGDIR=C:\Program Files\Oracle\Inventory\logs\
DATAFILE_LOC.orcl=
ORACLE_BINARY_OK=true
DUMP_DESTINATION_LOC.orcl=C:\app\oracle\admin\orcl
EMCP.DB_UNIQUE_NAME_LIST=orcl
CLUSTER_NODES=node1,node2
REMOTE_NODES=node2
SPFILE_LOC.orcl=+DATA/orcl/spfileorcl.ora
ARCHIVE_LOG_DESTINATION_LOC.orcl=
ORACLE_BASE.orcl=C:\app\oracle
LOCAL_SID.orcl=orcl1
local=false
INVENTORY_LOCATION=C:\Program Files\Oracle\Inventory
NODE_LIST.orcl=node1,node2
RAW_MAPPING_FILE.orcl=
DIAG_DEST.orcl=C:\APP\ORACLE\diag\rdbms\orcl
ORACLE_HOME=C:\app\oracle\product\11.2.0\dbhome_1\
STORAGE_TYPE.orcl=ASM
CCR_CONFIG_STATUS=CCR_DEL_HOME
CRS_HOME=false
EMCP.CHECK_POINT.orcl=WINDOWS_SERVICE_REGISTRY_CREATE,DBCONTROL_START
CONFIGFILE_LOC.orcl=+DATA/orcl/controlfile/current.260.712754807,C:\APP\ORACLE
 \PRODUCT\11.2.0\DBHOME_1\DATABASE\DR1ORCL.DAT,C:\APP\ORACLE\PRODUCT\11.2.0\
 DBHOME_1\DATABASE\DR2ORCL.DAT
SID_LIST.orcl=orcl1,orcl2
OLD_ACTIVE_ORACLE_HOME=
CREATION_MODE.orcl=y
COMPS_TO_REMOVE=ode.net.ntoledb,oramts
DB_UNIQUE_NAME_LIST=orcl
FLASH_RECOVERY_LOC.orcl=