Removing Support for Oracle RAC

You can remove Support for Oracle RAC from the following entities:

A cluster. See How to Remove Support for Oracle RAC From a Cluster.
Selected nodes in a cluster. See How to Remove Support for Oracle RAC From Selected Nodes.

How to Remove Support for Oracle RAC From a Cluster

Perform this task to remove Support for Oracle RAC from all nodes in a cluster.

On a cluster where multiple Oracle RAC databases are running, perform this task to remove an Oracle RAC database from the cluster. The remaining Oracle RAC databases continue to run in the cluster.

This task involves removing the following resource groups from the cluster in the following order:

The resource group for the Oracle RAC database
Resource groups for logical hostname resources
Resource groups for scalable file-system mount-point resources
Resource groups for scalable device group resources
The Oracle RAC framework resource group
The multiple-owner volume-manager framework resource group, if used

Caution - You might perform this task to remove an Oracle RAC database from a cluster where multiple Oracle RAC databases are running. In this situation, do not remove any resource group on whose resources the remaining Oracle RAC databases depend.

For example, you might have configured multiple database file systems to depend on a single device group. In this situation, do not remove the resource group that contains the resource for the scalable device group.

Similarly, if multiple databases depend on the Oracle RAC framework resource group, do not remove this resource group.

Before You Begin

Ensure that the cluster node from which you perform this task is booted in cluster mode.

On one node of the cluster, become superuser.
Remove the resource group for each Oracle RAC database that you are removing.
For each Oracle RAC database that you are removing, type the following command:
```
# clresourcegroup delete -F rac-db-rg
```
rac-db-rg

Specifies the resource group that you are removing.
Use Oracle utilities to remove from the cluster each Oracle RAC database that you no longer require.
If you are removing Support for Oracle RAC entirely, use Oracle utilities to remove the following items from all nodes in a cluster:
- The Oracle RAC software
- The Oracle Grid Infrastructure software
Disable the Oracle Grid Infrastructure framework resource.
```
# clresource disable crs-framework-rs
```
crs-framework-rs

Specifies the name of the resource that you are disabling. This resource is the instance of the SUNW.crs_framework resource type that is configured in the cluster.
Remove any resource groups that contain scalable file-system mount-point resources.
If no resource groups that contain scalable file-system mount-point resources are configured, omit this step.
For each resource group that you are removing, type the following command:
```
# clresourcegroup delete -F scal-mp-rg
```
scal-mp-rg

Specifies the resource group that you are removing.
Remove any resource groups that contain scalable device group resources.
If no resource groups that contain scalable device group resources are configured, omit this step.
For each resource group that you are removing, type the following command:
```
# clresourcegroup delete -F scal-dg-rg
```
scal-dg-rg

Specifies the resource group that you are removing.
Destroy any scalable device groups that were affected by the removal of resource groups in Step 7.
How to perform this step depends on the type of the scalable device group.
- For each Solaris Volume Manager for Sun Cluster multi-owner disk set, destroy the disk set as follows:
  1. Remove all metadevices such as volumes, soft partitions, and mirrors from the disk set.
    Use the metaclear(1M) command for this purpose.
```
# metaclear -s scal-dg-ms -a
```
    -s scal-dg-ms
    
    Specifies the name of the disk set from which you are removing metadevices.
  2. Remove all global devices from the disk set.
```
# metaset -s scal-dg-ms -d -f alldevices
```
    -s scal-dg-ms
    
    Specifies the name of the disk set from which you are removing global devices.
    
    alldevices
    
    Specifies a space-separated list that contains all global devices that were added to the disk set when the disk set was created. The format of each device ID path name is /dev/did/dsk/dN, where N is the device number.
  3. Remove all nodes from the disk set that you are destroying.
    The removal of all nodes from a disk set destroys the disk set.
```
# metaset -s scal-dg-ms -d -h allnodes
```
    -s scal-dg-ms
    
    Specifies the name of the disk set that you are destroying.
    
    -h allnodes
    
    Specifies a space-separated list that contains all nodes that were added to the disk set when the disk set was created.
Note - If you are removing an Oracle RAC database from a cluster where multiple Oracle RAC databases are running, omit the remaining steps in this procedure.
Remove the Oracle RAC framework resource group.
```
# clresourcegroup delete -F rac-fmwk-rg
```
rac-fmwk-rg

Specifies the resource group that you are removing.
Remove the multiple-owner volume-manager framework resource group, if used.
```
# clresourcegroup delete -F vucmm-fmwk-rg
```
vucmm-fmwk-rg

Specifies the resource group that you are removing.
Unregister the resource type of each resource that you removed in this procedure.
```
# clresourcetype unregister resource-type-list
```
resource-type-list

Specifies a comma-separated list of the names of the resource types that you are unregistering. For a list of the resource types that are associated with Support for Oracle RAC, see Automatically Generated Names for Oracle Solaris Cluster Objects.
(Optional) From each node in the cluster, uninstall the Support for Oracle RAC software packages.
```
# pkg uninstall ha-cluster/data-service/oracle-database ha-cluster/library/ucmm
```
Reboot each node in the cluster.

How to Remove Support for Oracle RAC From Selected Nodes

Perform this task to remove Support for Oracle RAC from selected nodes.

On a cluster where multiple Oracle RAC databases are running, perform this task to remove an Oracle RAC database from selected nodes. The Oracle RAC database that you remove continues to run on the other cluster nodes. The remaining Oracle RAC databases continue to run on the selected nodes.

This task involves removing the selected nodes from the following resource groups in the following order:

The resource group for the Oracle RAC database
Resource groups for logical hostname resources
Resource groups for scalable file-system mount-point resources
Resource groups for scalable device group resources
The Oracle RAC framework resource group

Caution - You might perform this task to remove an Oracle RAC database from selected nodes of a cluster where multiple Oracle RAC databases are running. In this situation, do not remove the nodes from any resource group on whose resources the remaining Oracle RAC databases depend. For example, you might have configured multiple database file systems to depend on a single device group. In this situation, do not remove the nodes from the resource group that contains the resource for the scalable device group. Similarly, if multiple databases depend on the Oracle RAC framework resource group, do not remove the nodes from this resource group.

Become superuser.
Remove the nodes from the resource group for each Oracle RAC database that you are removing.
For each Oracle RAC database that you are removing, perform the following steps:
1. Take offline the resource group for the Oracle RAC database on the nodes from which you are removing Support for Oracle RAC.
```
# clresourcegroup offline -n nodelist rac-db-rg
```
  -n nodelist
  
  Specifies a comma-separated list of cluster nodes from which you are taking offline the resource group.
  
  rac-db-rg
  
  Specifies the name of the resource group that you are taking offline.
2. Remove the nodes from the node list of the resource group for the Oracle RAC database.
```
# clresourcegroup remove-node -n nodelist rac-db-rg
```
  -n nodelist
  
  Specifies a comma-separated list of cluster nodes that you are removing from the resource group.
  
  rac-db-rg
  
  Specifies the name of the resource group from which you are removing nodes.
Remove each node that you are removing from the list of nodes where the Oracle Grid Infrastructure resource for the Oracle database runs.
```
# Grid_home/bin/crsctl delete -n node-name
```
Grid_home

Specifies the Oracle Grid Infrastructure home directory. This directory contains the Oracle Grid Infrastructure binary files and Oracle Grid Infrastructure configuration files.

node-name

Specifies the host name of the node where the Oracle Grid Infrastructure resource runs.
From each node that you are removing, remove each Oracle Grid Infrastructure resource that represents an Oracle Solaris Cluster resource from whose resource group you are removing nodes.
An Oracle Grid Infrastructure resource is configured for each Oracle Solaris Cluster resource for scalable device groups and scalable file-system mount points on which Oracle components depend.
For each Oracle Grid Infrastructure resource that you are removing, perform the following steps on each node from which you are removing the resource:
1. Stop the Oracle Grid Infrastructure resource that you are removing.
```
# Grid_home/bin/crsctl stop
```
2. Delete the Oracle Grid Infrastructure resource that you want to remove.
```
# Grid_home/bin/crsctl delete res
```
Use Oracle utilities to remove the following items from each node from which you are removing Support for Oracle RAC:
- The Oracle RAC database
- Oracle Grid Infrastructure
Remove the nodes from any resource groups that contain scalable file-system mount-point resources.
If no resource groups that contain scalable file-system mount-point resources are configured, omit this step.
For each resource group from which you are removing nodes, perform the following steps:
1. Take offline the resource group on the nodes from which you are removing Support for Oracle RAC.
```
# clresourcegroup offline -n nodelist scal-mp-rg
```
  -n nodelist
  
  Specifies a comma-separated list of cluster nodes from which you are taking offline the resource group.
  
  scal-mp-rg
  
  Specifies the name of the resource group that you are taking offline.
2. Remove the nodes from the node list of the resource group.
```
# clresourcegroup remove-node -n nodelist scal-mp-rg
```
  -n nodelist
  
  Specifies a comma-separated list of cluster nodes that you are removing from the resource group.
  
  scal-mp-rg
  
  Specifies the name of the resource group from which you are removing nodes.
Remove the nodes from any resource groups that contain scalable device group resources.
If no resource groups that contain scalable device group resources are configured, omit this step.
For each resource group from which you are removing nodes, perform the following steps:
1. Take offline the resource group on the nodes from which you are removing Support for Oracle RAC.
```
# clresourcegroup offline -n nodelist scal-dg-rg
```
  -n nodelist
  
  Specifies a comma-separated list of cluster nodes from which you are taking offline the resource group.
  
  scal-dg-rg
  
  Specifies the name of the resource group that you are taking offline.
2. Remove the nodes from the node list of the resource group.
```
# clresourcegroup remove-node -n nodelist scal-dg-rg
```
  -n nodelist
  
  Specifies a comma-separated list of cluster nodes that you are removing from the resource group.
  
  scal-dg-rg
  
  Specifies the name of the resource group from which you are removing nodes.
Remove the nodes from any scalable device groups that were affected by the removal of nodes from resource groups in Step 7.
How to perform this step depends on the type of the scalable device group.
- For each Solaris Volume Manager for Sun Cluster multi-owner disk set, type the following command:
```
# metaset -s scal-dg-ms -d -h nodelist
```
  -s scal-dg-ms
  
  Specifies the name of the disk set from which you are removing nodes.
  
  -h nodelist
  
  Specifies a space-separated list of the nodes that you are removing from the disk set.
Note - If you are removing an Oracle RAC database from selected nodes of a cluster where multiple Oracle RAC databases are running, omit the remaining steps in this procedure.
Remove the nodes from the Oracle RAC framework resource group.
1. Take offline the resource group on the nodes from which you are removing Support for Oracle RAC.
```
# clresourcegroup offline -n nodelist rac-fmwk-rg
```
  -n nodelist
  
  Specifies a comma-separated list of cluster nodes from which you are taking offline the resource group.
  
  rac-fmwk-rg
  
  Specifies the name of the resource group that you are taking offline.
2. Remove the nodes from the node list of the resource group.
```
# clresourcegroup remove-node -n nodelist rac-fmwk-rg
```
  -n nodelist
  
  Specifies a comma-separated list of cluster nodes that you are removing from the resource group.
  
  rac-fmwk-rg
  
  Specifies the name of the resource group from which you are removing nodes.
Remove the nodes from the multiple-owner volume-manager framework resource group, if used.
1. Take offline the resource group on the nodes from which you are removing Support for Oracle RAC.
```
# clresourcegroup offline -n nodelist vucmm-fmwk-rg
```
  -n nodelist
  
  Specifies a comma-separated list of cluster nodes from which you are taking offline the resource group.
  
  vucmm-fmwk-rg
  
  Specifies the name of the resource group that you are taking offline.
2. Remove the nodes from the node list of the resource group.
```
# clresourcegroup remove-node -n nodelist vucmm-fmwk-rg
```
  -n nodelist
  
  Specifies a comma-separated list of cluster nodes that you are removing from the resource group.
  
  vucmm-fmwk-rg
  
  Specifies the name of the resource group from which you are removing nodes.
(Optional) From each node that you removed, uninstall the Support for Oracle RAC software packages.
```
# pkg uninstall ha-cluster/data-service/oracle-database ha-cluster/library/ucmm
```
Reboot each node from which you from which you removed Support for Oracle RAC.

Skip Navigation Links
Exit Print View
	Oracle Solaris Cluster Data Service for Oracle Real Application Clusters Guide Oracle Solaris Cluster 4.0