DE-INSTALL ORACLE RAC

To completely remove all Oracle databases, instances, and software from an Oracle home directory:

1) Identify all instances associated with the Oracle home

2) Shut down processes

3) Remove database instances

4) Remove Automatic Storage Management

5) Remove Oracle Clusterware

1) Identify all instances associated with the Oracle home

AIX, HP-UX, or Linux:

==============

$ more /etc/oratab

+ASM1:/u01/app/oracle/product/10.2.0/db_1:N 

brij:/u01/app/oracle/product/10.2.0/db_1:N

These entries show that the +ASM1 Automatic Storage Management instance and the brij Oracle database instance are associated with the Oracle home directory /u01/app/oracle/product/10.2.0/db_1.

Deinstalling Oracle RAC and ASM Using Configuration Assistants

This section describes the procedure to deinstall the Oracle RAC software and Automatic Storage Management (ASM) software using configuration assistant command lines.

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.

• 1. Examine the oratab file to identify the instance dependencies on this Oracle home.

  2. 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.

  3. If you do not use ASM, then proceed to step 4.

     1. 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.

     2. If Oracle RAC and ASM are owned by the same Oracle user account, then log in as that user (typically oracle).

     3. 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.

     4. To remove the software, complete the following steps

        1. Connect to the ASM instance and run the following command to determine database instances using this ASM instance:

           1. SQL> select INSTANCE_NAME from GV$ASM_CLIENT;

              1. Note:

           2. 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.

• • • • • 1. 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.

• 3. 4. 2. For each instance listed in the output of the statement you run in step a, stop the respective databases.

        3. Oracle recommends that you back up the database files for all the databases that are currently using this ASM instance.

        4. Using your connection to the ASM instance, run the following command:

• • • • 1. SQL> select * from V$ASM_DISKGROUP;

• 3. 4. 5. 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:

• • • • 1. SQL> drop diskgroup diskgroup_name including contents;

• 3. 4. 6. Shut down ASM on all Oracle RAC nodes, and verify that all ASM instances are stopped.

        7. 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:

• • • • 1. oracleasm listdisks

        2. Second, run the following command to delete every disk listed by the previous command:

        3. oracleasm deletedisks

        4. 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.

        5. Fourth, as root, run the following commands on all nodes of your Oracle RAC cluster:

        6. /etc/init.d/oracleasm stop/etc/init.d/oracleasm disable

• 3. 4. 8. Deconfigure ASM, using either DBCA in silent mode, or performing deconfiguration manually.

• • • • 1. To deconfigure ASM manually, complete steps i through l.

        2. 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:

        3. dbca -silent -deleteASM -nodelist node1,node2,...

        4. for the variables node1, node2, and so on, provide a list of all the nodes where ASM is configured. When DBCA completes de-installation, proceed to step 4.

• 3. 4. 9. To remove the ASM entry from the OCR, run the following command for all nodes on which this Oracle home exists:

• • • • 1. srvctl remove asm -n nodename

        2. where 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.

• 3. 4. 10. If you are using a shared cluster file system for your Oracle home, then run the following commands on the local node:

• • • • 1. rm -Rf $ORACLE_HOME/dbs/*ASM* rm -Rf $ORACLE_BASE/admin/+ASM

        2. You may need to remove subordinate files or directories before these commands complete successfully.

• 3. 4. 11. 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.

        12. Remove oratab entries for the deleted Oracle home databases.

  4. 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.

• • 1. $ ./netca /deinst /nodeinfo node1,node2,...

    2. In the preceding syntax example, replace the variables node1, node2, and so on, with all the member nodes of the Oracle RAC database.

       1. Note:

    3. 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.

• 5. 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.

8.3.2 Deinstalling Oracle Clusterware

Deinstall each Oracle RAC home by running the procedure in the previous section, "Deinstalling Oracle RAC and ASM Using Configuration Assistants". Then complete thedeinstallation by removing the Oracle Clusterware software. Refer to Oracle Clusterware Installation Guide for your platform for Oracle Clusterware deinstallation procedures.

8.4 Removing Oracle Software

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.

• 1. If necessary, log in as the oracle user:

     1. $ su - oracle

  2. Set the ORACLE_HOME environment variable to specify the path of the Oracle home directory that you want to remove:

     2. • Bourne, Bash, or Korn shell:

          • $ ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1  $ export ORACLE_HOME

        • C shell:

          • $ setenv ORACLE_HOME /u01/app/oracle/product/11.1.0/db_1

  3. Remove any databases or Automatic Storage Management instances associated with this Oracle home and delete the Oracle CSS daemon.

• • 1. Refer to the preceding sections for information about how to complete these tasks.

• 4. Stop any processes running in this Oracle home:

• 1. Start OUI as follows:

     1. $ $ORACLE_HOME/oui/bin/runInstaller

  2. In the Welcome window, click Deinstall Products.

• • 1. The Inventory screen appears, listing all of the Oracle homes on the system.

• 3. In the Inventory screen, select the Oracle home and the products that you want to remove, then click Remove.

     2. 1. Note:

• • 1. If you choose to remove Oracle JVM, then OUI removes all installed products that depend on Oracle JVM, including Oracle Database 10g.

    2. OUI displays a confirmation window asking you to confirm that you want to deinstall the products and their dependent components.

• 4. Click Yes.

• • 1. OUI displays a progress indicator as it removes the software.

• 5. Click Close on the Inventory screen.

  6. When the products have been deleted, click Cancel to exit from OUI, and then click Yes.