JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Oracle Solaris Cluster Data Service for Oracle Real Application Clusters Guide     Oracle Solaris Cluster
search filter icon
search icon

Document Information

Preface

1.  Installing Support for Oracle RAC

2.  Configuring Storage for Oracle Files

3.  Registering and Configuring the Resource Groups

Registering and Configuring the Oracle RAC Framework Resource Group

Tools for Registering and Configuring the Oracle RAC Framework Resource Group

How to Register and Configure the Oracle RAC Framework Resource Group by Using clsetup

Registering and Configuring the Multiple-Owner Volume-Manager Framework Resource Group

Tools for Registering and Configuring the Multiple-Owner Volume-Manager Framework Resource Group

How to Register and Configure the Multiple-Owner Volume-Manager Framework Resource Group by Using clsetup

Creating a Global Device Group for the Oracle RAC Database

How to Create a Multi-Owner Disk Set in Solaris Volume Manager for Sun Cluster for the Oracle RAC Database

How to Create a VxVM Shared-Disk Group for the Oracle RAC Database

Registering and Configuring Storage Resources for Oracle Files

Tools for Registering and Configuring Storage Resources for Oracle Files

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

Registering and Configuring the Oracle ASM Resource Group

Tools for Registering and Configuring the Oracle ASM Resource Group

How to Register and Configure the Oracle ASM Resource Group by Using clsetup

4.  Enabling Oracle RAC to Run in a Cluster

5.  Administering Support for Oracle RAC

6.  Troubleshooting Support for Oracle RAC

7.  Modifying an Existing Configuration of Support for Oracle RAC

8.  Upgrading Support for Oracle RAC

A.  Sample Configurations of This Data Service

B.  Preset Actions for DBMS Errors and Logged Alerts

C.  Support for Oracle RAC Extension Properties

D.  Command-Line Alternatives

Index

Creating a Global Device Group for the Oracle RAC Database

If you are using a volume manager for Oracle database files, the volume manager requires a global device group for the Oracle RAC database to use.

The type of global device group to create depends on the volume manager that you are using:

How to Create a Multi-Owner Disk Set in Solaris Volume Manager for Sun Cluster for the Oracle RAC Database


Note - Perform this task only if you are using Solaris Volume Manager for Sun Cluster.


If you are using Solaris Volume Manager for Sun Cluster, Solaris Volume Manager requires a multi-owner disk set for the Oracle RAC database, the Sun QFS shared file system, or Oracle ASM to use. For information about Solaris Volume Manager for Sun Cluster multi–owner disk sets, see Multi-Owner Disk Set Concepts in Solaris Volume Manager Administration Guide.

Before You Begin

Note the following points.

  1. Create a multi-owner disk set.

    Use the metaset(1M) command for this purpose.

    # metaset -s setname -M -a -h nodelist
    -s setname

    Specifies the name of the disk set that you are creating.

    -M

    Specifies that the disk set that you are creating is a multi-owner disk set.

    -a

    Specifies that the nodes that the -h option specifies are to be added to the disk set.

    -h nodelist

    Specifies a space-separated list of nodes that are to be added to the disk set. The Support for Oracle RAC software packages must be installed on each node in the list.

  2. Add global devices to the disk set that you created in Step 1.
    # metaset -s setname -a devicelist
    -s setname

    Specifies that you are modifying the disk set that you created in Step 1.

    -a

    Specifies that the devices that devicelist specifies are to be added to the disk set.

    devicelist

    Specifies a space-separated list of full device ID path names for the global devices that are to be added to the disk set. To enable consistent access to each device from any node in the cluster, ensure that each device ID path name is of the form /dev/did/dsk/dN, where N is the device number.

  3. For the disk set that you created in Step 1, create the volumes that the Oracle RAC database or Sun QFS shared file system will use.

    Tip - If you are creating many volumes for Oracle data files, you can simplify this step by using soft partitions. However, if you are using the Sun QFS shared file system and the I/O load on your system is heavy, use separate partitions for data and metadata. Otherwise, the performance of your system might be impaired. For information about soft partitions, see Chapter 12, Soft Partitions (Overview), in Solaris Volume Manager Administration Guide and Chapter 13, Soft Partitions (Tasks), in Solaris Volume Manager Administration Guide.


    Create each volume by concatenating slices on global devices that you added in Step 2. Use the metainit(1M) command for this purpose.

    # metainit -s setname volume-abbrev numstripes width slicelist
    -s setname

    Specifies that you are creating a volume for the disk set that you created in Step 1.

    volume-abbrev

    Specifies the abbreviated name of the volume that you are creating. An abbreviated volume name has the format dV, where V is the volume number.

    numstripes

    Specifies the number of stripes in the volume.

    width

    Specifies the number of slices in each stripe. If you set width to greater than 1, the slices are striped.

    slicelist

    Specifies a space-separated list of slices that the volume contains. Each slice must reside on a global device that you added in Step 2.

  4. If you are using mirrored devices, create the mirrors by using volumes that you created in Step 3 as submirrors.

    If you are not using mirrored devices, omit this step.

    Use the metainit command to create each mirror as follows:

    # metainit -s setname mirror -m submirror-list
    -s setname

    Specifies that you are creating a mirror for the disk set that you created in Step 1.

    mirror

    Specifies the name of the mirror that you are creating in the form of an abbreviated volume name. An abbreviated volume name has the format dV, where V is the volume number.

    submirror-list

    Specifies a space-separated list of submirrors that the mirror is to contain. Each submirror must be a volume that you created in Step 3. Specify the name of each submirror in the form of an abbreviated volume name.


    Note - For information on configuring a Solaris Volume Manager disk set in a zone cluster, see How to Add a Disk Set to a Zone Cluster (Solaris Volume Manager) in Oracle Solaris Cluster Software Installation Guide.


  5. Verify that each node is correctly added to the multi-owner disk set.

    Use the metaset command for this purpose.

    # metaset -s setname
    -s setname

    Specifies that you are verifying the disk set that you created in Step 1.

    This command displays a table that contains the following information for each node that is correctly added to the disk set:

    • The Host column contains the node name.

    • The Owner column contains the text multi-owner.

    • The Member column contains the text Yes.

  6. Verify that the multi-owner disk set is correctly configured.
    # cldevicegroup show setname
    setname

    Specifies that configuration information only for the disk set that you created in Step 1 is displayed.

    This command displays the device group information for the disk set. For a multi-owner disk set, the device group type is Multi-owner_SVM.

  7. Verify the online status of the multi-owner disk set.
    # cldevicegroup status setname

    This command displays the status of the multi-owner disk set on each node in the multi-owner disk set.

  8. (Configurations without the Sun QFS shared file system only) On each node that can own the disk set, change the ownership of each volume that you created in Step 3.

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


    Note - For a zone cluster, perform this step in the zone cluster.


    Change the volume ownership as follows:

    • Owner: the DBA user

    • Group: the DBA group

    The DBA user and the DBA group are created as explained in How to Create the DBA Group and the DBA User Accounts.

    Ensure that you change ownership only of volumes that the Oracle RAC database will use.

    # chown user-name:group-name volume-list
    user-name

    Specifies the user name of the DBA user. This user is normally named oracle.

    group-name

    Specifies the name of the DBA group. This group is normally named dba.

    volume-list

    Specifies a space-separated list of the logical names of the volumes that you created for the disk set. The format of these names depends on the type of device where the volume resides, as follows:

    • For block devices: /dev/md/setname/dsk/dV

    • For raw devices: /dev/md/setname/rdsk/dV

    The replaceable items in these names are as follows:

    setname

    Specifies the name of the multi-owner disk set that you created in Step 1.

    V

    Specifies the volume number of a volume that you created in Step 3.

    Ensure that this list specifies each volume that you created in Step 3.

  9. (Configurations without the Sun QFS shared file system only) Grant read access and write access to the owner of each volume whose ownership you changed in Step 8 .

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


    Note - For a zone cluster, perform this step in the zone cluster.


    Grant access to the volume on each node that can own the disk set. Ensure that you change access permissions only of volumes that the Oracle RAC database will use.

    # chmod u+rw volume-list
    volume-list

    Specifies a space-separated list of the logical names of the volumes to whose owners you are granting read access and write access. Ensure that this list contains the volumes that you specified in Step 8.

  10. If you are using Oracle ASM, specify the raw devices that you are using for the Oracle ASM disk group.

    Note - For 11g release 2 and 12c, Oracle ASM is only supported with hardware RAID. The use of Oracle ASM disk groups on devices that are managed by volume managers is not supported with version 11g release 2 or 12c.


    To specify the devices, modify the ASM_DISKSTRING Oracle ASM instance-initialization parameter.

    For example, to use the /dev/md/setname/rdsk/d path for the Oracle ASM disk group, add the value /dev/md/*/rdsk/d* to the ASM_DISKSTRING parameter. If you are modifying this parameter by editing the Oracle initialization parameter file, edit the parameter as follows:

    ASM_DISKSTRING = '/dev/md/*/rdsk/d*'

    If you are using mirrored devices, specify external redundancy in the Oracle ASM configuration.

    For more information, see your Oracle documentation.

Example 3-1 Creating a Multi-Owner Disk Set in Solaris Volume Manager for Sun Cluster

This example shows the sequence of operations that is required to create a multi-owner disk set in Solaris Volume Manager for Sun Cluster for a four-node cluster. The disk set uses mirrored devices.

The disk set is to be used with the Sun QFS shared file system. This example does not show the creation of the Sun QFS shared file system on the devices that are added to the disk set.

  1. To create the multi-owner disk set, the following command is run:

    # metaset -s oradg -M -a -h  pclus1 pclus2 pclus3 pclus4

    The multi-owner disk set is named oradg. The nodes pclus1, pclus2, pclus3, and pclus4 are added to this disk set.

  2. To add global devices to the disk set, the following command is run:

    # metaset -s oradg -a  /dev/did/dsk/d8  /dev/did/dsk/d9 /dev/did/dsk/d15 \
    /dev/did/dsk/d16

    The preceding command adds the following global devices to the disk set:

    • /dev/did/dsk/d8

    • /dev/did/dsk/d9

    • /dev/did/dsk/d15

    • /dev/did/dsk/d16

  3. To create volumes for the disk set, the following commands are run:

    # metainit -s oradg d10 1 1 /dev/did/dsk/d9s0
    # metainit -s oradg d11 1 1 /dev/did/dsk/d16s0
    # metainit -s oradg d20 1 1 /dev/did/dsk/d8s0
    # metainit -s oradg d21 1 1 /dev/did/dsk/d15s0

    Each volume is created by a one-on-one concatenation of a slice as shown in the following table. The slices are not striped.

    Volume
    Slice
    d10
    /dev/did/dsk/d9s0
    d11
    /dev/did/dsk/d16s0
    d20
    /dev/did/dsk/d8s0
    d21
    /dev/did/dsk/d15s0
  4. To create mirrors for the disk set, the following commands are run:

    # metainit -s oradg d1 -m d10 d11
    # metainit -s oradg d2 -m d20 d21

    The preceding commands create a mirror that is named d1 from volumes d10 and d11, and a mirror that is named d2 from volumes d20 and d21.

  5. To verify that each node is correctly added to the multi-owner disk set, the following command is run:

    # metaset -s oradgMulti-owner Set name = oradg, Set number = 1, Master = pclus2
    
    Host                Owner          Member
      pclus1             multi-owner   Yes 
      pclus2             multi-owner   Yes 
      pclus3             multi-owner   Yes 
      pclus4             multi-owner   Yes 
    
    Drive Dbase
    
    d8    Yes  
    
    d9    Yes  
    
    d15   Yes  
    
    d16   Yes  
  6. To verify that the multi-owner disk set is correctly configured, the following command is run:

    # cldevicegroup show oradg
    === Device Groups ===                          
    
    Device Group Name:                              oradg
      Type:                                            Multi-owner_SVM
      failback:                                        false
      Node List:                                       pclus1, pclus2, pclus3, pclus4
      preferenced:                                     false
      numsecondaries:                                  0
      diskset name:                                    oradg
  7. To verify the online status of the multi-owner disk set, the following command is run:

    # cldevicegroup status oradg
    
    === Cluster Device Groups ===
    
    --- Device Group Status ---
    
    Device Group Name     Primary     Secondary     Status
    -----------------     -------     ---------     ------
    
    
    --- Multi-owner Device Group Status ---
    
    Device Group Name           Node Name           Status
    -----------------           ---------           ------
    oradg                       pclus1              Online
                                pclus2              Online
                                pclus3              Online
                                pclus4              Online

Next Steps

Go to Registering and Configuring Storage Resources for Oracle Files.

How to Create a VxVM Shared-Disk Group for the Oracle RAC Database


Note - Perform this task only if you are using VxVM with the cluster feature.


If you are using VxVM with the cluster feature, VxVM requires a shared-disk group for the Oracle RAC database or Oracle ASM to use.

Before You Begin

Note the following points.

  1. Use Veritas commands that are provided for creating a VxVM shared-disk group.

    For information about VxVM shared-disk groups, see your VxVM documentation.

  2. If you are using Oracle ASM, specify the raw devices that you are using for the Oracle ASM disk group.

    Note - For 11g release 2 and 12c, Oracle ASM is only supported with hardware RAID. The use of Oracle ASM disk groups on devices that are managed by volume managers is not supported with version 11g release 2 or 12c.


    To specify the devices, modify the ASM_DISKSTRING Oracle ASM instance-initialization parameter.

    For example, to use the /dev/md/setname/rdsk/d path for the Oracle ASM disk group, add the value /dev/md/*/rdsk/d* to the ASM_DISKSTRING parameter. If you are modifying this parameter by editing the Oracle initialization parameter file, edit the parameter as follows:

    ASM_DISKSTRING = '/dev/md/*/rdsk/d*'

    If you are using mirrored devices, specify external redundancy in the Oracle ASM configuration.

    For more information, see your Oracle documentation.

Next Steps

Go to Registering and Configuring Storage Resources for Oracle Files.