test

Sun Cluster Data Service for Oracle Real Application Clusters Guide for Solaris OS

How to Register and Configure Oracle RAC Server Resources

  1. On one node of the cluster, become superuser.

  2. Register the SUNW.oracle_rac_server resource type.


    # scrgadm -a -t SUNW.oracle_rac_server

  3. For each node where Sun Cluster Support for Oracle Real Application Clusters can run, create a resource group and a resource for the Oracle RAC server.

    1. Create a failover resource group to contain the Oracle RAC server resource.


      # scrgadm -a -g rac-server-rg -h node \
-y RG_AFFINITIES=++rac-fmwk-rg \
[-y RG_DEPENDENCIES=sqfs-rg-list]
      -g rac-server-rg

      Specifies the name that you are assigning to the resource group.

      -h node

      Specifies the node for which you are creating the resource group. You must specify only one node.

      -y RG_AFFINITIES=++rac-fmwk-rg

      Creates a strong positive affinity to the RAC framework resource group. If the RAC framework resource group was created by using the scsetup utility, the RAC framework resource group is named rac-framework-rg.

      -y RG_DEPENDENCIES=sqfs-rg-list

      Specifies a comma-separated list of Sun StorEdge QFS resource groups on which this Oracle RAC server instance depends. These resource groups are created when you register and configure the data service for the Sun StorEdge QFS metadata server. For more information about these resources, see Configuration Planning Questions. Create this dependency only if you are using Sun StorEdge QFS shared file system.

    2. Add an instance of the SUNW.oracle_rac_server resource type to the resource group that you created in Step a.

      When you create this resource, specify the following information about the resource:

      • The Oracle home directory. The Oracle home directory contains the binary files, log files, and parameter files for the Oracle software.

      • The Oracle system identifier. This identifier is the name of the Oracle database instance.


      # scrgadm -a -j rac-server-resource -g rac-server-rg \
-t SUNW.oracle_rac_server \
-y RESOURCE_DEPENDENCIES=rac-fmwk-rs[, sqfs-rs-list] \
-x ORACLE_SID=ora-sid \
-x ORACLE_HOME=ora-home
      -j rac-server-resource

      Specifies the name that you are assigning to the SUNW.oracle_rac_server resource.

      -g rac-server-rg

      Specifies the resource group to which you are adding the resource. This resource group must be the resource group that you created in Step a.

      -y RESOURCE_DEPENDENCIES=rac-fmwk-rs[, sqfs-rs-list]

      Specifies the resources on which this Oracle RAC server instance depends.

      You must specify the RAC framework resource. If the RAC framework resource group is created by using the scsetup utility, this resource is named rac_framework.

      If you are using Sun StorEdge QFS shared file system, you must also specify a comma-separated list of Sun StorEdge QFS resources. These resources are created when you register and configure the data service for the Sun StorEdge QFS metadata server. For more information about these resources, see Configuration Planning Questions.

      -x ORACLE_SID=ora-sid

      Specifies the Oracle system identifier. This identifier is the name of the Oracle database instance.

      -x ORACLE_HOME=ora-home

      Specifies the path to the Oracle home directory. The Oracle home directory contains the binary files, log files, and parameter files for the Oracle software.

Example 2–1 Registering and Configuring Oracle RAC Server Resources

This example shows the sequence of operations that is required to register and configure Oracle RAC server resources for a two-node cluster.

The example assumes that a RAC framework resource group named rac-framework-rg has been created. The example also assumes that this resource group contains a SUNW.rac_framework resource named rac_framework.

  1. To register the SUNW.oracle_rac_server resource type, the following command is run:


    # scrgadm -a -t SUNW.oracle_rac_server

  2. To create the RAC1-rg resource group for node node1, the following command is run:


    # scrgadm -a -g RAC1-rg -h node1 \
-y RG_AFFINITIES=++rac-framework-rg

  3. To create the RAC2-rg resource group for node node2, the following command is run:


    # scrgadm -a -g RAC2-rg -h node2 \
-y RG_AFFINITIES=++rac-framework-rg

  4. To create the RAC1-rs resource in the RAC1-rg resource group for node node1, the following command is run:


    # scrgadm -a -j RAC1-rs -g RAC1-rg \
-t SUNW.oracle_rac_server \
-y RESOURCE_DEPENDENCIES=rac_framework \
-x ORACLE_SID=RAC1 \
-x ORACLE_HOME=/oracle

  5. To create the RAC2-rs resource in the RAC2-rg resource group for node node2, the following command is run:


    # scrgadm -a -j RAC2-rs -g  RAC2-rg \
-t SUNW.oracle_rac_server \
-y RESOURCE_DEPENDENCIES=rac_framework \
-x ORACLE_SID=RAC2 \
-x ORACLE_HOME=/oracle

Where to Go From Here

Go to Registering and Configuring Oracle Listener Resources.