Upgrading to Oracle Solaris Cluster 3.3 Resource Types for Oracle 9i RAC Database Instances

As of the Sun Cluster 3.2 release, the failover resource types that automate the startup and shutdown of Oracle 9i RAC database instances can be replaced with multi-master resource types. The multi-master resources simplify the administration and enhance the scalability of Support for Oracle RAC.

Upgrading from Sun Cluster 3.1 software to Oracle Solaris Cluster 3.3 resource types for Oracle 9i RAC database instances involves the tasks that are described in the following sections:

1. How to Take Offline Resource Groups for Oracle RAC Database Components and Restart the Components

2. How to Modify the Configuration of Oracle Solaris Cluster Resources for Oracle 9i RAC Database Instances

Perform these tasks in the order in which they are listed.

How to Take Offline Resource Groups for Oracle RAC Database Components and Restart the Components

This task involves taking offline resource groups for Oracle RAC database components and restarting the components on each cluster node individually.

This sequence of operations avoids downtime by ensuring that the Oracle RAC database components remain online on other cluster nodes.

Perform this task on each cluster node individually.

Before You Begin

Ensure that you have upgraded resources in the RAC framework resource group. For more information, see Upgrading Resources in Support for Oracle RAC.

1. Become superuser on the cluster node.
2. If you configured Oracle listener resources in separate resource groups, take offline the resource groups from the node.

   If you configured Oracle listener resources in the same resource group as the Oracle RAC server resource, omit this step.

   For each resource group that you are taking offline, type the following command:

   # clresourcegroup offline -n node rac-listener-rg

   -n node

   Specifies the node from which you are taking the resource group offline. This node is the node where you are performing this task.

   rac-listener-rg

   Specifies the resource group for Oracle listener resources that you are taking offline.

   When the resource group is taken offline, the Oracle listener is stopped on the node. The Oracle listeners on other nodes are unaffected.

3. Take offline the resource group for the Oracle RAC server from the node.

   # clresourcegroup offline -n node rac-server-rg

   -n node

   Specifies the node from which you are taking the resource group offline. This node is the node where you are performing this task.

   rac-server-rg

   Specifies the resource group for the Oracle RAC server resource that you are taking offline.

   When the resource group is taken offline, the Oracle RAC server is stopped on the node. The Oracle RAC servers on other nodes are unaffected.

   If you configured Oracle listener resources in the same resource group as the Oracle RAC server resource, the listeners are also stopped on the node. The Oracle listeners on other nodes are unaffected.

4. Use Oracle utilities to restart the Oracle RAC server and Oracle listener on the node.

Next Steps

Go to How to Modify the Configuration of Oracle Solaris Cluster Resources for Oracle 9i RAC Database Instances.

How to Modify the Configuration of Oracle Solaris Cluster Resources for Oracle 9i RAC Database Instances

Perform this task from one cluster node.

Before You Begin

Ensure that the task that is explained in How to Take Offline Resource Groups for Oracle RAC Database Components and Restart the Components has been performed.

1. Become superuser or assume a role that provides solaris.cluster.admin and solaris.cluster.modify RBAC authorizations.
2. If you configured Oracle listener resources in separate resource groups, remove the resource groups.

   If you configured Oracle listener resources in the same resource group as Oracle RAC server resources, omit this step.

   For each resource group that you are removing, type the following command:

   # clresourcegroup delete -F rac-listener-rg

   rac-listener-rg

   Specifies the resource group for Oracle listener resources that you are removing.

3. Remove all resource groups that contain an Oracle RAC server resource.

   For each resource group that you are removing, type the following command:

   # clresourcegroup delete -F rac-server-rg

   rac-server-rg

   Specifies the resource group that contains an Oracle RAC server resource that you are removing.

4. If you are using a Sun QFS shared file system, remove all resource groups that contain resources for the Sun QFS metadata server.

   If you are not using a Sun QFS shared file system, omit this step.

   For each resource group that you are removing, type the following command:

   # clresourcegroup delete -F qfs-mds-rg

   qfs-mds-rg

   Specifies the resource group that contains resources for the Sun QFS metadata server that you are removing.

5. If you are using global device groups or shared file systems for Oracle files, add storage resources to manage the availability of the storage on which the Oracle software depends.

   If you are not using global device groups or shared file systems for Oracle files, omit this step.

   For instructions for performing this task, see Adding Storage Resources for Oracle Files.

6. Configure new resources for Oracle 9i RAC database instances.

   For instructions for performing this task, see Configuring Resources for Oracle RAC Database Instances.