Sun Cluster Data Service for Oracle RAC Guide for Solaris OS

ProcedureHow to Verify the Configuration of Storage Resources for Oracle Files

Storage resources for Oracle files are created when the task in Registering and Configuring Storage Resources for Oracle Files is performed.

Perform this task only if your configuration of storage management schemes requires storage resources for Oracle files.

This procedure provides the long forms of the Sun Cluster maintenance commands. Most commands also have short forms. Except for the forms of the command names, the commands are identical. For a list of the commands and their short forms, see Appendix A, Sun Cluster Object-Oriented Commands, in Sun Cluster Data Services Planning and Administration Guide for Solaris OS.

  1. Become superuser on a cluster node.

  2. Verify that all resource groups that contain storage resources for Oracle files are correctly configured.


    # clresourcegroup show rac-storage-rg-list
    
    rac-storage-rg-list

    Specifies a comma-separated list of resource groups that contain storage resources for Oracle files.

  3. Take offline the resource group that contains the resources on which the RAC database resource depends.


    # clresourcegroup offline rac-storage-rg
    
    rac-storage-rg

    Specifies the name of the resource group that contains the resources on which the RAC database resource depends. The resource group to take offline depends on your choice of storage management schemes for Oracle files.

    • If you are using a shared file system for Oracle files, take offline the resource group that contains scalable file-system mount-point resources.

    • If you are using a volume manager without a file system for Oracle files, take offline the resource group that contains scalable device-group resources.

    This step might require several minutes to complete.

  4. Verify that the resource groups for Oracle RAC behave as follows:

    • The status of the resource group that you took offline in Step 3 is offline.

    • The status of the RAC database resource group is offline.

    • The status of the RAC framework resource group depends on the version of Oracle that you are using:

      • If you are using Oracle 10g R2, the status of the RAC framework resource group is pending online blocked.

      • If you are using Oracle 10g R1 or Oracle 9i, the status of the RAC framework resource group remains online.


    # clresourcegroup status
    
  5. (Oracle 10g R2 only) Verify that the Oracle CRS are offline.

    To verify that the Oracle CRS are offline, consult the system messages file to find messages to indicate that CRS are being shut down.

  6. Bring online the resource group that you took offline in Step 3.


    # clresourcegroup online rac-storage-rg
    
    rac-storage-rg

    Specifies the name of the resource group that you took offline in Step 3.

    This step might require several minutes to complete.

  7. (Oracle 10g R2 only) On each node, restart the Oracle CRS.


    # /etc/init.d/init.crs start
    Startup will be queued to init within 30 seconds.

    This step might require several minutes to complete.

  8. (Oracle 10g R2 only) On each node, verify that the Oracle CRS are online.

    Use the Oracle command crstat for this purpose.


    # crs-home/bin/crs_stat
    
    crs-home

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


    Note –

    The startup of Oracle CRS on all nodes might require several minutes to complete. If you perform this step before the Oracle CRS are online on all nodes, the status on some nodes might be offline. In this situation, repeat this step until the status of the Oracle CRS is online on all nodes.


  9. Verify that all resource groups for Oracle RAC are online.


    # clresourcegroup status
    

    Note –

    Bringing online the resource group that contains the resources on which the RAC database resource depends also brings online the RAC database resource group. If you perform this step before the RAC database resource group is online on all nodes, the status on some nodes might be online faulted. In this situation, repeat this step until the status of the RAC database resource group is online on all nodes.