10 Adding and Deleting Oracle RAC from Nodes on Linux and UNIX Systems

Using DBCA in Interactive Mode to Add Database Instances to Target Nodes

To add a database instance to a target node with DBCA in interactive mode, perform the following steps:

1. Ensure that your existing nodes have the $ORACLE_HOME environment variable set to the Oracle RAC home.

2. Start DBCA by entering dbca at the system prompt from the Oracle_home/bin directory.

   DBCA performs certain CVU checks while running. However, you can also run CVU from the command line to perform various verifications.

   See Also:

   Oracle Clusterware Administration and Deployment Guide for more information about CVU

   DBCA displays the Welcome page for Oracle RAC. Click Help on any DBCA page for additional information.

3. Select Oracle Real Application Clusters (RAC) database, click Next, and DBCA displays the Operations page.

4. Select Instance Management, click Next, and DBCA displays the Instance Management page.

5. Select Add Instance and click Next. DBCA displays the List of Cluster Databases page that shows the databases and their current status, such as ACTIVE or INACTIVE.

6. From the List of Cluster Databases page, select the active Oracle RAC database to which you want to add an instance. Enter user name and password for the database user that has SYSDBA privileges. Click Next and DBCA displays the List of Cluster Database Instances page showing the names of the existing instances for the Oracle RAC database that you selected.

7. Click Next to add a new instance and DBCA displays the Adding an Instance page.

8. On the Adding an Instance page, enter the instance name in the field at the top of this page if the instance name that DBCA provides does not match your existing instance naming scheme.

9. Review file locations for undo tablespaces and redo log groups of the new instance and click Finish on the Instance Storage page.

10. Review the information on the Summary dialog and click OK or click Cancel to end the instance addition operation. DBCA displays a progress dialog showing DBCA performing the instance addition operation. When DBCA completes the instance addition operation, DBCA displays a dialog asking whether you want to perform another operation.

11. After you terminate your DBCA session, run the following command to verify the administrative privileges on the target node and obtain detailed information about these privileges where nodelist consists of the names of the nodes on which you added database instances:

    cluvfy comp admprv -o db_config -d Oracle_home -n nodelist [-verbose]
    

12. Perform any necessary service configuration procedures, as described in Chapter 5, "Introduction to Automatic Workload Management".

Using DBCA in Silent Mode to Add Database Instances to Target Nodes

You can use DBCA in silent mode to add instances to nodes on which you have extended an Oracle Clusterware home and an Oracle Database home. Before you run the dbca command, ensure that you have set the ORACLE_HOME environment variable correctly on the existing nodes. Run DBCA, supplying values for the variables described in Table 10-1,as follows:

dbca -silent -addInstance -nodeList node_name -gdbName gdb_name
[-instanceName instance_name -sysDBAUserName sysdba -sysDBAPassword password]

Perform any necessary service configuration procedures, as described in Chapter 5, "Introduction to Automatic Workload Management".

Using DBCA in Interactive Mode to Delete Instances from Nodes

To delete an instance using DBCA in interactive mode, perform the following steps:

1. Start DBCA.

   Start DBCA on a node other than the node that hosts the instance that you want to delete. The database and the instance that you plan to delete should be running during this step.

2. On the DBCA Welcome page select Oracle Real Application Clusters Database, click Next. DBCA displays the Operations page.

3. On the DBCA Operations page, select Instance Management and click Next. DBCA displays the Instance Management page.

4. On the DBCA Instance Management page, select the instance to be deleted, select Delete Instance, and click Next.

5. On the List of Cluster Databases page, select the Oracle RAC database from which to delete the instance, as follows:

   1. On the List of Cluster Database Instances page, DBCA displays the instances that are associated with the Oracle RAC database that you selected and the status of each instance. Select the cluster database from which you will delete the instance.

   2. Enter a user name and password for the database user that has SYSDBA privileges. Click Next.

   3. Click OK on the Confirmation dialog to proceed to delete the instance.

      DBCA displays a progress dialog showing that DBCA is deleting the instance. During this operation, DBCA removes the instance and the instance's Oracle Net configuration. When DBCA completes this operation, DBCA displays a dialog asking whether you want to perform another operation.

      Click No and exit DBCA or click Yes to perform another operation. If you click Yes, then DBCA displays the Operations page.

6. Verify that the dropped instance's redo thread has been removed by using SQL*Plus on an existing node to query the GV$LOG view. If the redo thread is not disabled, then disable the thread. For example:

   SQL> ALTER DATABASE DISABLE THREAD 2;
   

7. Verify that the instance has been removed from OCR by running the following command, where db_unique_name is the database unique name for your Oracle RAC database:

   srvctl config database -d db_unique_name
   

8. If you are deleting more than one node, then repeat these steps to delete the instances from all the nodes that you are going to delete.

Using DBCA in Silent Mode to Delete Instances from Nodes

You can use DBCA in silent mode to delete a database instance from a node.

Run the following command, where the variables are the same as those shown in Table 10-1 for the DBCA command to add an instance. Provide a node name only if you are deleting an instance from a node other than the one on where DBCA is running as shown in the following example where password is the password:

dbca -silent -deleteInstance [-nodeList node_name] -gdbName gdb_name
-instanceName instance_name -sysDBAUserName sysdba -sysDBAPassword password

At this point, you have accomplished the following:

• Deregistered the selected instance from its associated Oracle Net Services listeners

• Deleted the selected database instance from the instance's configured node

• Removed the Oracle Net configuration

• Deleted the Oracle Flexible Architecture directory structure from the instance's configured node.