Go to main content

Oracle® Solaris Cluster Data Service for Oracle Real Application Clusters Guide

Exit Print View

Updated: April 2016
 
 

How to Add Support for Oracle RAC to Selected Nodes

Perform this procedure if you are adding nodes to a cluster and you require Support for Oracle RAC to run on the nodes. Perform this procedure from only one node.

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

  • Resource groups for scalable file-system mount-point resources

  • The multiple-owner volume-manager framework resource group, if used.

  • The Support for Oracle RAC framework resource group

  • Resource groups for scalable device group resources

  • Resource groups that contain resources for the StorageTek QFS metadata server

  • Resource groups for logical hostname resources

  • The resource group for the Support for Oracle RAC database


Note -  During this procedure, some resources might report that they cannot come online, most likely because of missing software that cannot yet be installed. These failures are expected and are safe to ignore until all procedure steps are completed.

Before You Begin

  • Ensure that the required Support for Oracle RAC software packages are installed on each node to which you are adding Support for Oracle RAC. For more information, see Installing the Support for Oracle RAC Package.

  • Ensure that the node that you add is connected to the shared storage that is used by the Support for Oracle RAC configuration.

  1. Assume the root role on any cluster node.
  2. Add the nodes to 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 to which you are adding nodes, run the following command:

    # clresourcegroup add-node -S -n nodelist scal-mp-rg
    –n nodelist

    Specifies a comma-separated list of cluster nodes to which you are adding Support for Oracle RAC.

    scal-mp-rg

    Specifies the name of the resource group to which you are adding nodes.

  3. Add the nodes to the multiple-owner volume-manager framework resource group, if used.
    # clresourcegroup add-node -S -n nodelist vucmm-fmwk-rg
    –n nodelist

    Specifies a comma-separated list of cluster nodes to which you are adding the resource group.

    vucmm-fmwk-rg

    Specifies the name of the resource group to which you are adding nodes.

  4. Add the nodes to the Support for Oracle RAC framework resource group.
    # clresourcegroup add-node -S -n nodelist rac-fmwk-rg
    –n nodelist

    Specifies a comma-separated list of cluster nodes to which you are adding Support for Oracle RAC.

    rac-fmwk-rg

    Specifies the name of the resource group to which you are adding nodes.

  5. Add the nodes to any scalable device groups that you are using for Oracle Database files.

    If you are not using any scalable device groups for Oracle Database files, omit this step.

    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 set-name -M -a -h nodelist
      –s set-name

      Specifies the Solaris Volume Manager for Sun Cluster multi-owner disk set to which you are adding nodes.

      –h nodelist

      Specifies a space-separated list of cluster nodes that you are adding to the multi-owner disk set.

  6. Add the nodes to 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 to which you are adding nodes, run the following command:

    # clresourcegroup add-node -S -n nodelist scal-dg-rg
    –n nodelist

    Specifies a comma-separated list of cluster nodes to which you are adding Support for Oracle RAC.

    scal-dg-rg

    Specifies the name of the resource group to which you are adding nodes.

  7. Mount each shared file system that is to be accessed from the nodes that you are adding.

    If no shared file systems are to be accessed from the nodes that you are adding, omit this step.

    For each file system that you are mounting, type the following command:

    # mount mount-point
    mount-point

    Specifies the mount point of the file system that you are mounting.

  8. Add the nodes to any resource groups that contain resources for the StorageTek QFS metadata server.

    If no resource groups that contain resources for the StorageTek QFS metadata server are configured, omit this step.

    For each resource group to which you are adding nodes, run the following command:

    # clresourcegroup add-node -n nodelist qfs-mds-rg
    –n nodelist

    Specifies a comma-separated list of cluster nodes to which you are adding Support for Oracle RAC.

    qfs-mds-rg

    Specifies the name of the resource group to which you are adding nodes.

  9. Bring online all resource groups to which you added nodes in Step 6.

    These resource groups 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 bringing online, type the following command:

    # clresourcegroup online -eM scal-dg-rg
    scal-dg-rg

    Specifies the name of the resource group that you are bringing online.

  10. Start Oracle Grid Infrastructure.
    # /etc/init.d/init.crs start
    Startup will be queued to init within 30 seconds.
  11. Add the nodes to the resource group for each Support for Oracle RAC database that is to run on the nodes.

    For each resource group to which you are adding nodes, run the following command:

    # clresourcegroup add-node -S -n nodelist rac-db-rg
    –n nodelist

    Specifies a comma-separated list of cluster nodes to which you are adding Support for Oracle RAC.

    rac-db-rg

    Specifies the name of the resource group to which you are adding nodes.

  12. For each node that you are adding, create the Oracle Grid Infrastructure resources that are required to represent Oracle Solaris Cluster resources.

    Create an Oracle Grid Infrastructure resource for each Oracle Solaris Cluster resource for scalable device groups and scalable file-system mount points on which Oracle components depend. For more information, see How to Create an Oracle Grid Infrastructure Resource for Interoperation With Oracle Solaris Cluster.

  13. Modify each resource for Support for Oracle RAC databases to set a value of each per-node property for each node that you are adding.

    For each resource that you are modifying, perform these steps:

    1. Disable the resource.
      # clresource disable rac-db-rs
      rac-db-rs

      Specifies the name of the Support for Oracle RAC database resource that you are disabling.

    2. Enable the resource.
      # clresource enable rac-db-rs
      rac-db-rs

      Specifies the name of the Support for Oracle RAC database resource that you are enabling.

  14. Bring online each resource group for Support for Oracle RAC databases.

    For each resource group that you are bringing online, run the following command:

    # clresourcegroup online -eM rac-db-rg
    rac-db-rg

    Specifies the name of the resource group that you are bringing online.

Example 9  Adding Support for Oracle RAC to Selected Nodes

This example shows the sequence of operations that is required to add Support for Oracle RAC to nodes pclus3 and pclus4 of a four-node cluster.

    The configuration of Support for Oracle RAC in this example is as follows:

  • StorageTek QFS shared file system on Solaris Volume Manager for Sun Cluster is used to store Oracle Database files.

  • The mount points of file systems that are used for Oracle Database files are as follows:

    • Oracle Database files: /db_qfs/OraData

    • Oracle Database binary files and related files: /db_qfs/OraHome

  • The oradg disk set is used only by the Support for Oracle RAC database.

  • The name of the Support for Oracle RAC database is swb.

  • The StorageTek QFS shared file systems use a Solaris Volume Manager for Sun Cluster multi-owner disk set that is named oradg. The creation of this disk set is shown in Example 3, Creating a Multi-Owner Disk Set in Solaris Volume Manager for Sun Cluster.

  • The configuration uses a multiple-owner volume-manager framework resource group.

The configuration of resource groups in this example is shown in the following table.

Resource Group
Purpose
vucmm-framework-rg
Multiple-owner volume-manager resource group.
rac-framework-rg
Support for Oracle RAC framework resource group.
scaldg-rg
Resource group for scalable device-group resources.
qfsmds-rg
Resource group for StorageTek QFS metadata server resources.
scalmnt-rg
Resource group for scalable file-system mount-point resources.
rac_server_proxy-rg
Support for Oracle RAC database resource group.

The resource groups that are required for this configuration are shown in Configuration of Support for Oracle RAC With Solaris Volume Manager for Sun Cluster and StorageTek QFS Shared File System.

  1. To add the nodes to the resource group that contains scalable file-system mount-point resources, the following command is run:

    # clresourcegroup add-node -S -n pclus3,pclus4 scalmnt-rg
  2. To add the nodes to the multiple-owner volume-manager framework resource group, the following command is run:

    # clresourcegroup add-node -S -n pclus3,plcus4 vucmm-framework-rg
  3. To add the nodes to the Support for Oracle RAC framework resource group, the following command is run:

    # clresourcegroup add-node -S -n pclus3,plcus4 rac-framework-rg
  4. To add the nodes to the Solaris Volume Manager for Sun Cluster multi-owner disk set oradg, the following command is run:

    # metaset -s oradg -M -a -h  pclus3 pclus4
  5. To add the nodes to the resource group that contains scalable device group resources, the following command is run:

    # clresourcegroup add-node -S -n pclus3,pclus4 scaldg-rg
  6. To mount the shared file systems that are to be accessed from the nodes that are being added, the following commands are run:

    # mount /db_qfs/OraData
    # mount /db_qfs/OraHome
  7. To add the nodes to the resource group that contains resources for the StorageTek QFS metadata server, the following command is run:

    # clresourcegroup add-node -n pclus3,pclus4 qfsmds-rg
  8. To bring online the resource group that contains scalable device group resources, the following command is run:

    # clresourcegroup online -eM scaldg-rg
  9. To start Oracle Clusterware and to verify the correct startup of Oracle Clusterware, the following commands are run:

    # /etc/init.d/init.crs start
    Startup will be queued to init within 30 seconds.
    # /db_qfs/OraHome/crs/bin/crsctl check crs
    CSS appears healthy
    CRS appears healthy
    EVM appears healthy
  10. To add the nodes to the resource group for the Support for Oracle RAC database, the following command is run:

    # clresourcegroup add-node -S -n pclus3,pclus4 rac_server_proxy-rg

    After the addition of the nodes to the resource group for the Support for Oracle RAC database, the required Oracle Clusterware resources are created. The creation of these Oracle Clusterware resources is beyond the scope of this example.

  11. To bring online the resource group for the Support for Oracle RAC database, the following command is run:

    # clresourcegroup online -eM rac_server_proxy-rg