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

How to Register and Configure Storage Resources for Oracle Database Files by Using clsetup

Perform this procedure from only one node of the cluster.

Before You Begin

Ensure that the following prerequisites are met:

• The Support for Oracle RAC framework resource group is created and is online. For more information, see Registering and Configuring the Support for Oracle RAC Framework Resource Group.

• The multiple-owner volume-manager framework resource group is created and is online. For more information, see Registering and Configuring the Multiple-Owner Volume-Manager Framework Resource Group.

  ---

  Caution  -  Do not attempt to manually create the /var/run/nodelist file. Doing so can put the cluster at risk of a cluster-wide panic.

  ---

• Required volumes, global device groups, and file systems are created. For more information, see the following sections:

  • Installing Storage Management Software With Support for Oracle RAC

  • Creating a Global Device Group for the Support for Oracle RAC Database

• Required file systems are mounted.

Ensure that you have the following information:

• The name of each scalable device group that you are using for Oracle Database files, if any

• The mount point of each shared file system that you are using for Oracle Database files, if any

1. On one node of the cluster, assume the root role.
2. Start the clsetup utility.

   # clsetup

   The clsetup main menu is displayed.

3. Choose the menu item, Data Services.

   The Data Services menu is displayed.

4. Choose the menu item, Oracle Real Application Clusters.

   The clsetup utility displays information about Support for Oracle RAC.

5. Press Return to continue.

   The clsetup utility prompts you to select whether you are performing the initial configuration of Support for Oracle RAC or administering an existing configuration.

6. Choose the menu item, Support for Oracle RAC Create Configuration.

   The clsetup utility prompts you to select the Support for Oracle RAC cluster location. This location can be the global cluster or a zone cluster.

7. Type the option number for the location of the Support for Oracle RAC cluster.
   • If you select the global cluster option, the clsetup utility displays the list of components to configure. Skip to Step 9.
   • If you select the zone cluster option, the clsetup utility prompts you to select the required zone cluster. Proceed to the next step.
8. Type the option number for the required zone cluster.

   The clsetup utility displays the list of components of Support for Oracle RAC to configure.

9. Choose the menu item, Storage Resources for Oracle Files.

   The clsetup utility displays the list of prerequisites for performing this task.

10. Verify that the prerequisites are met.

    If you are prompted for resources for scalable device groups, omit this step.

11. If you are prompted to select a Storage Management Scheme for your Oracle Database files, select the appropriate scheme.

    • StorageTek QFS With Solaris Volume Manager for Sun Cluster

    • StorageTek QFS With Hardware RAID

    • NAS Device

12. If no suitable resources exist, or if no resource exists for a device group that you are using, add a resource to the list.

    The clsetup utility displays a list of the resources for scalable device groups that are configured on the cluster. If no suitable resources exist, this list is empty.

    If resources exist for all the device groups that you are using, omit this step.

    For each resource that you are adding, perform the following steps:

    1. Press Return.

       The clsetup utility displays a list of the scalable device groups that are configured on the cluster.

    2. Type the option number for the device group to use.

       Once you select the device group, you can either select the entire disk group or choose to specify logical devices, or disks, in the disk group.

    3. Choose whether you want to specify logical devices.
       • To specify logical devices, type yes. Proceed to the next step.
       • To select the entire disk group, type no. Skip to Step g.
    4. Type a comma-separated list of numbers that corresponds to the logical devices or disks you choose or type a for all.

       The clsetup utility returns you to the list of resources for scalable device groups that are configured on the cluster.

    5. To confirm your selection of device groups, type d.

       The clsetup utility returns you to the list of the resources for scalable device groups that are configured on the cluster. The resource that you are creating is added to the list.

13. Type the numbers that correspond to the resources that you require, if not already selected.

    You can select existing resources, resources that are not yet created, or a combination of existing resources and new resources. If you select more than one existing resource, the selected resources must be in the same resource group.

14. To confirm your selection of resources for device groups, type d.

    The clsetup utility displays a list of the resources for shared file-system mount points that are configured on the cluster. If no suitable resources exist, this list is empty.

15. If no suitable resources exist, or if no resource exists for a file-system mount point that you are using, add a resource to the list.

    If resources exist for all the file-system mount points that you are using, omit this step.

    For each resource that you are adding, perform the following steps:

    1. Press Return.

       The clsetup utility displays a list of the shared file systems that are configured on the cluster.

    2. Type a comma-separated or space-separated list of numbers that correspond to the file systems that you are using for Oracle files.
    3. To confirm your selection of file systems, type d.

       The clsetup utility returns you to the list of the resources for file-system mount points that are configured on the cluster. The resource that you are creating is added to the list.

16. Type the option numbers for the resources that you require, if not already selected.

    You can select existing resources, resources that are not yet created, or a combination of existing resources and new resources. If you select more than one existing resource, the selected resources must be in the same resource group.

17. To confirm your selection of resources for file-system mount points, type d.

    The clsetup utility displays the names of the Oracle Solaris Cluster objects that the utility will create or add to your configuration.

18. If you need to modify an Oracle Solaris Cluster object that the utility will create, modify the object.
    1. Type the option number for the Oracle Solaris Cluster object that you are modifying.

       The clsetup utility displays a list of properties that are set for the object.

    2. Modify each property that you are changing as follows:
       1. Type the option number for the property that you are changing.

          The clsetup utility prompts you for the new value.

       2. At the prompt, type the new value.

          The clsetup utility returns you to the list of properties that are set for the object.

    3. When you have modified all the properties that you need to change, type d.

       The clsetup utility returns you to the list of the names of the Oracle Solaris Cluster objects that the utility will create or add to your configuration.

19. When you have modified all the Oracle Solaris Cluster objects that you need to change, type d.

    The clsetup utility displays information about the Support for Oracle RAC framework resource group for which storage resources will be configured.

20. To create the configuration, type c.

    The clsetup utility displays a progress message to indicate that the utility is running commands to create the configuration. When configuration is complete, the clsetup utility displays the commands that the utility ran to create the configuration.

21. Press Return to continue.

    The clsetup utility returns you to the list of options for configuring Support for Oracle RAC.

22. (Optional) Type q and press Return repeatedly until you quit the clsetup utility.

    If you prefer, you can leave the clsetup utility running while you perform other required tasks before using the utility again. If you choose to quit clsetup, the utility recognizes your existing Support for Oracle RAC framework resource group when you restart the utility.

23. Determine whether the resource groups that the wizard created are online.

    # clresourcegroup status

24. If a resource group that the wizard created is not online, bring the resource group online.

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

    # clresourcegroup online -eM rac-storage-rg

    rac-storage-rg

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

Resource Configuration

The following table lists the default resource configuration that the clsetup utility creates when you complete this task.

Resource Type, Resource Name, and Resource Group Dependencies Description Resource type: SUNW.ScalDeviceGroup Resource name: scaldg-name-rs, where dg-name is the name of the device group that the resource represents Resource group: scaldg-rg Strong dependency on the resource in the multiple-owner volume-manager framework resource group for the volume manager that is associated with the device group, the Solaris Volume Manager for Oracle Solaris Cluster resource. Scalable device-group resource. One resource is created for each scalable device group that you are using for Oracle files. Resource type: SUNW.qfs Resource name: qfs-mp-dir-rs, where mp-dir is the mount point of the file system, with / replaced by – Resource group: qfsmds-rg Strong dependency on the scalable wait_zc_boot resource and scalable device-group resource, if any. If you are using StorageTek QFS without a volume manager, this resource does not depend on any other resources. Resource for the StorageTek QFS metadata server. One resource is created for each StorageTek QFS shared file system that you are using for Oracle files. Resource type: SUNW.ScalMountPoint Resource name: scal-mp-dir-rs, where mp-dir is the mount point of the file system, with / replaced by – Resource group: scalmnt-rg Strong dependency on the resource for the StorageTek QFS metadata server, if any. Offline-restart dependency on the scalable device-group resource, if any. If you are using a file system on a qualified NAS device without a volume manager, this resource does not depend on any other resources. Scalable file system mount point resource. One resource is created for each shared file system that you are using for Oracle files. Resource type: SUNW.wait_zc_boot Resource name: wait-zc-rs, where zc is the zone cluster name. Resource group: scalmnt-rg None Resource to ensure that the StorageTek QFS shared file system configured to the zone cluster is mounted only after the zone cluster is booted.

Next Steps

If you are using Oracle ASM, go to Registering and Configuring the Oracle ASM Resource Group.

Otherwise, go to Chapter 4, Enabling Support for Oracle RAC to Run in a Cluster.