This chapter describes how to completely remove all Oracle databases, instances, and software from an Oracle Real Application Clusters (Oracle RAC) Oracle home directory.
This chapter contains the following topics:
See Also:If you want to remove an individual product, refer to the product-specific documentation for requirements and restrictions
To completely remove all Oracle databases, instances, and software from an Oracle home directory:
Identify all instances associated with the Oracle home
Shut down processes
Remove database instances
Remove Automatic Storage Management
Remove Oracle Clusterware
Note:You cannot remove or uninstall the Oracle Database Vault option. However, you can disable it. Refer to Oracle Database Vault Administrator's Guide for more details.
You can remove Oracle Configuration Manager. Refer to Oracle Configuration Manager Installation and Administration Guide for more details.
To identify all instances associated with the Oracle home that you want to remove, enter the following command:
AIX, HP-UX, or Linux:
$ more /etc/oratab
$ more /var/opt/oracle/oratab
The output of this command contains entries similar to the following:
These entries show that the
+ASM Automatic Storage Management instance and the
CUST Oracle database instance are associated with the Oracle home directory
Perform the following procedures to de-install Oracle RAC:
See Also:Oracle Real Application Clusters Administration and Deployment Guide for more information about using Oracle RAC scalability features of adding and deleting nodes and instances from Oracle RAC databases, and for information about viewing OCR content
Caution:Before you perform these steps, Oracle recommends that you make a backup of any databases that run from the Oracle home you are about to delete. You should then stop any instances and processes on all nodes, including services, that depend on the software that you are de-installing.
oratab file to identify the instance dependencies on this Oracle home.
Start DBCA, select Oracle Real Application Clusters Database, select Delete a database, and select the database that you want to delete. Repeat this step to delete all databases.
If you do not use ASM, then proceed to step 4.
If the database is in the Oracle home from which the ASM database runs, then ensure that there are no other database dependencies on this group of ASM instances.
If Oracle RAC and ASM are owned by the same Oracle user account, then log in as that user (typically
If Oracle RAC and Oracle ASM are owned by different software owners, then remove the Oracle RAC installation by logging in as the Oracle RAC software owner, and remove ASM by logging in as the ASM software owner.
To remove the software, complete the following steps
SQL> select INSTANCE_NAME from GV$ASM_CLIENT;
Note:This command lists only database instances that are running. It is possible that other instances are associated with the ASM instance, but they are not currently running. If you removed a database from this Oracle home but the output from the command shows that this ASM instance is supporting a database instance in another Oracle home, then do not remove the ASM instance or the Oracle home.
If your Oracle RAC database uses a different Oracle home from the Oracle home that your ASM environment uses, and you want to delete the Oracle RAC database, then perform step 5 in the Oracle RAC database home.
For each instance listed in the output of the statement you run in step a, stop the respective databases.
Oracle recommends that you back up the database files for all the databases that are currently using this ASM instance.
SQL> select * from V$ASM_DISKGROUP;
For each disk group listed in the output of the statement you run in step d, run the following command, where the variable
diskgroup_name is the name of the disk group that you want to delete:
SQL> drop diskgroup diskgroup_name including contents;
Shut down ASM on all Oracle RAC nodes, and verify that all ASM instances are stopped.
If you are de-installing from a system with ASMLIB, then run the following procedure. First, run this command to list the disks that you need to delete:
Second, run the following command to delete every disk listed by the previous command:
Third, re-run the
oracleasm listdisks command to confirm that the disks are all deleted. Repeat this command on each of the Oracle RAC cluster nodes to confirm that the disks have been deleted from all the nodes.
/etc/init.d/oracleasm stop/etc/init.d/oracleasm disable
Deconfigure ASM, using either DBCA in silent mode, or performing deconfiguration manually.
To deconfigure ASM using DBCA, run DBCA in silent mode to deconfigure ASM. To run DBCA in silent mode, navigate to the directory
$ORACLE_HOME/bin and use the following command syntax:
dbca -silent -deleteASM -nodelist node1,node2,...
for the variables
node2, and so on, provide a list of all the nodes where ASM is configured. When DBCA completes de-installation, proceed to step 4.
srvctl remove asm -n nodename
nodename is the name of a node from which you want to remove the ASM instance. Repeat this command for each node on which you want to remove ASM.
rm -Rf $ORACLE_HOME/dbs/*ASM* rm -Rf $ORACLE_BASE/admin/+ASM
You may need to remove subordinate files or directories before these commands complete successfully.
If you are not using a shared cluster file system for your Oracle home, then run the commands from the previous step, step j, on each node on which the Oracle home exists.
If there are no outstanding dependencies, then change directory to the
$ORACLE_HOME/bin directory, and use the following NETCA command syntax to remove the listener and its Oracle Clusterware resources.
$ ./netca /deinst /nodeinfo node1,node2,...
In the preceding syntax example, replace the variables
node2, and so on, with all the member nodes of the Oracle RAC database.
Note:You cannot perform an Oracle RAC installation from the same Oracle Universal Installer session in which you perform an Oracle RAC deinstallation. If you deinstall Oracle RAC with OUI and want to perform another Oracle RAC installation, then you must start a new OUI session.
Start OUI, and remove any existing Oracle Database with Oracle RAC software by selecting Deinstall Products, and selecting the Oracle home that you want to remove. If any of these databases is an ASM database, then de-install the Oracle home with ASM where you want to de-install the Oracle Database software, and then de-install the Oracle Database. Removing ASM does not remove the ASM data or disk groups.
Deinstall each Oracle RAC home by running the procedure in the previous section, "Deinstalling Oracle RAC and ASM Using Configuration Assistants". Then complete the deinstallation by removing the Oracle Clusterware software. Refer to Oracle Clusterware Installation Guide for your platform for Oracle Clusterware deinstallation procedures.
The following steps describe how to use Oracle Universal Installer (OUI) to remove Oracle software from an Oracle home:
Note:Always use OUI to remove Oracle software. Do not delete any Oracle home directories without first using OUI to remove the software.
If necessary, log in as the
$ su - oracle
ORACLE_HOME environment variable to specify the path of the Oracle home directory that you want to remove:
Bourne, Bash, or Korn shell:
$ ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 $ export ORACLE_HOME
$ setenv ORACLE_HOME /u01/app/oracle/product/11.1.0/db_1
Remove any databases or Automatic Storage Management instances associated with this Oracle home and delete the Oracle CSS daemon.
Refer to the preceding sections for information about how to complete these tasks.
|Oracle Net listener||
|Oracle Ultra Search||
Start OUI as follows:
In the Welcome window, click Deinstall Products.
The Inventory screen appears, listing all of the Oracle homes on the system.
In the Inventory screen, select the Oracle home and the products that you want to remove, then click Remove.
Note:If you choose to remove Oracle JVM, then OUI removes all installed products that depend on Oracle JVM, including Oracle Database 10g.
OUI displays a confirmation window asking you to confirm that you want to deinstall the products and their dependent components.
OUI displays a progress indicator as it removes the software.
Click Close on the Inventory screen.
When the products have been deleted, click Cancel to exit from OUI, and then click Yes.