Configuring Resources for Oracle RAC Database Instances

Resources for Oracle RAC database instances enable the database instances to be administered from Oracle Solaris Cluster. These resources also enable Oracle Solaris Cluster and Oracle Grid Infrastructure to interoperate.

This section contains the following information about configuring resources for Oracle RAC database instances:

Tools for Registering and Configuring Resources for Oracle RAC Database Instances
How to Enable Oracle Solaris Cluster and Oracle Grid Infrastructure to Interoperate

Tools for Registering and Configuring Resources for Oracle RAC Database Instances

Oracle Solaris Cluster provides the following tools for registering and configuring resources for Oracle RAC database instances in the global cluster or in a zone cluster:

The clsetup utility. For more information, see the following sections:
- How to Enable Oracle Solaris Cluster and Oracle Grid Infrastructure to Interoperate
Oracle Solaris Cluster maintenance commands. For more information, see the following sections:
- Creating Resources for Interoperation With Oracle Grid Infrastructure by Using Oracle Solaris Cluster Maintenance Commands

The clsetup utility provides a wizard for configuring resources for Oracle RAC database instances. The wizard reduces the possibility of configuration errors that might result from command syntax errors or omissions. This wizard also ensures that all required resources are created and that all required dependencies between resources are set.

How to Enable Oracle Solaris Cluster and Oracle Grid Infrastructure to Interoperate

When you perform this task, the clsetup utility creates the following resources for interoperation with Oracle Grid Infrastructure:

An Oracle Solaris Cluster resource to act as a proxy for the Oracle RAC database
An Oracle Solaris Cluster resource to represent the Oracle Grid Infrastructure framework
One of the following storage choices:
- Oracle Grid Infrastructure resources to represent scalable device groups and scalable file-system mount points
- Oracle Grid Infrastructure resources to represent Oracle ASM disk groups

Before You Begin

Ensure that the following prerequisites are met:

The Oracle RAC framework resource group is created and is online. See Registering and Configuring the Oracle RAC Framework Resource Group.
Storage resources for Oracle files are configured. See Registering and Configuring Storage Resources for Oracle Files.
The Oracle RAC software is installed. See Installing Oracle RAC Software.
The installation of the Oracle RAC software is verified. See Verifying the Installation of Oracle RAC.
The Oracle database is created. See Creating an Oracle Database.
The Oracle database is running.

To determine whether the Oracle database is running, use the Oracle srvctl command as follows:

$ srvctl status database -d db-name

db-name specifies the name of the Oracle database.

Ensure that you have the following information:

The full path to the Oracle Grid Infrastructure home directory
The full path to the Oracle home directory
The Oracle system identifier (SID) for each instance of the database for which you are configuring resources
The names of all Oracle Solaris Cluster storage resources for Oracle files that you are using

On one node of the cluster, become superuser.
Start the clsetup utility.
```
# clsetup
```
The clsetup main menu is displayed.
Choose the menu item, Data Services.
The Data Services menu is displayed.
Choose the menu item, Oracle Real Application Clusters.
The clsetup utility displays information about Support for Oracle RAC.
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.
Choose the menu item, Oracle RAC Create Configuration.
The clsetup utility prompts you to select the Oracle RAC cluster location. This location can be the global cluster or a zone cluster.
Type the option number for the location of the Oracle RAC cluster and press Return.
- If you select the global cluster option, the clsetup utility displays the list of components of Oracle RAC 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 Step 8.
Type the option number for the required zone cluster and press Return.
The clsetup utility displays the list of components of Oracle RAC to configure.
Choose the menu item, Resources for Oracle Real Application Clusters Database Instances.
The clsetup utility displays a list of names of Oracle RAC databases that are configured on the cluster.
Specify the name of the Oracle RAC database that you are configuring.
- If the name is listed, type the number that corresponds to the name that you are selecting and press Return.
  The clsetup utility displays a list of Oracle home directories that exist on the cluster.
- If the name is not listed, specify the name explicitly:
  1. Type e and press Return.
    The clsetup utility prompts you for the name of the Oracle RACdatabase that you are configuring.
  2. Type the name of the Oracle RAC database that you are configuring and press Return.
    The clsetup utility displays a list of Oracle home directories that exist on the cluster.
Specify the Oracle home directory for your installation of the Oracle RAC software.
- If the directory is listed, type the number that corresponds to the directory that you are selecting and press Return.
  The clsetup utility displays a list of Oracle system identifiers that are configured on the cluster. The utility also prompts you to specify the system identifier for the first node in the list of nodes where Oracle RAC is to run.
- If the directory is not listed, specify the directory explicitly:
  1. Type e and press Return.
    The clsetup utility prompts you for the Oracle home directory.
  2. Type the full path to the Oracle home directory and press Return.
    The clsetup utility displays a list of Oracle system identifiers that are configured on the cluster. The utility also prompts you to specify the system identifier for the first node in the list of nodes where Oracle RAC is to run.
Specify the Oracle SID of the Oracle RAC database instance for the node that you are configuring.
Perform this step for each node in the list of nodes where Oracle RAC is to run.

Note - You must specify a unique Oracle SID for each node. If you specify a duplicate SID, the clsetup utility warns you that the SID is a duplicate and prompts you to specify the SID again.
- If the SID is listed, type the number that corresponds to the SID that you are selecting and press Return.
  The response of the clsetup utility depends on whether you have specified the Oracle SID for all nodes where Oracle RAC is to run.
  - If you have not specified the Oracle SID for all nodes, the clsetup utility prompts you for the SID of the next node in the node list.
  - If you have specified the Oracle SID for all nodes, the clsetup utility displays a list of Oracle Solaris Cluster storage resources for Oracle files that are configured. For information about these resources, see Registering and Configuring Storage Resources for Oracle Files.
- If the SID is not listed, specify the SID explicitly.
  1. Type e and press Return.
    The clsetup utility prompts you for the SID.
  2. Type the SID and press Return.
    The response of the clsetup utility depends on whether you have specified the Oracle SID for all nodes where Oracle RAC is to run.
    - If you have not specified the Oracle SID for all nodes, the clsetup utility prompts you for the SID of the next node in the node list.
    - If you have specified the Oracle SID for all nodes, the clsetup utility displays a list of Oracle Solaris Cluster storage resources for Oracle files that are configured. For information about these resources, see Registering and Configuring Storage Resources for Oracle Files.
Type a comma-separated or space-separated list of the numbers that correspond to the storage resources that you are using, and press Return.
- If you choose Oracle Automatic Storage Management (Oracle ASM), the clsetup utility displays the names of the Oracle ASM disk group resources.
- If you choose Other, the clsetup utility displays available scalable device group and scalable mount point resources.
Type the option number for the storage resources to use.
The clsetup utility displays the names of the Oracle Solaris Cluster objects that the utility will create.
If you require a different name for any Oracle Solaris Cluster objects, change the name.
1. Type the option number for the name to change and press Return.
  The clsetup utility displays a screen where you can specify the new name.
2. At the New Value prompt, type the new name and press Return.
The clsetup utility returns you to the list of the names of the Oracle Solaris Cluster objects that the utility will create.
To confirm your selection of Oracle Solaris Cluster object names, press Return.
The clsetup utility displays information about the Oracle Solaris Cluster configuration that the utility will create.
To create the configuration, type c and Press Return.
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.
Press Return to continue.
The clsetup utility returns you to the list of options for configuring Support for Oracle RAC.
(Optional) Type q and press Return repeatedly until you quit the clsetup utility.

Resource Configuration

The following table lists the default configuration of Oracle Solaris Cluster resources that the clsetup utility creates when you complete this task.

Resource Type, Resource Name, and Resource Group	Dependencies	Description
Resource type: `SUNW.crs_framework` Resource name: `crs_framework-rs` Resource group: `rac-framework-rg`	Strong dependency on the Oracle RAC framework resource. Offline-restart dependencies on all scalable device-group resources for Oracle files, if any. If you are using a shared file system without a volume manager, this resource has an offline-restart dependency on all scalable file-system mount-point resources for Oracle files. If you are not using a shared file system or a volume manager, this resource has no offline-restart dependencies on any other resources.	Oracle Grid Infrastructure framework resource.
Resource type: `SUNW.scalable_rac_server_proxy` Resource name: `rac_server_proxy-rs` Resource group: `rac_server_proxy-rg`	Strong dependency on the Oracle RAC framework resource. Offline-restart dependency on the Oracle Grid Infrastructure framework resource.	Proxy resource for the Oracle RAC database server.

Note - For detailed information for the resource configuration for zone clusters, see the figures in Appendix A, Sample Configurations of This Data Service.

The clsetup utility also creates 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.

The name of each Oracle Grid Infrastructure resource that the clsetup utility creates is as follows:

sun.node.sc-rs

The replaceable items in this name are as follows:

node specifies the name of the node where the Oracle Grid Infrastructure resource is to run.
sc-rs specifies the name of the Oracle Solaris Cluster resource that the Oracle Grid Infrastructure resource represents. This resource is created when the task in Registering and Configuring Storage Resources for Oracle Files is performed.

The Oracle Grid Infrastructure resource for the database instance on node depends on the Oracle Grid Infrastructure resource that the clsetup utility creates for that node. Oracle Grid Infrastructure resources for database instances are created during the installation and configuration of the Oracle RAC

The name of the Oracle Grid Infrastructure resource for the database instance on a node is as follows:

ora.dbname.db

The dbname portion of the name specifies the database name of the database instance that the Oracle Grid Infrastructure resource represents.

Next Steps

Go to Verifying the Installation and Configuration of Support for Oracle RAC.

Skip Navigation Links
Exit Print View
	Oracle Solaris Cluster Data Service for Oracle Real Application Clusters Guide Oracle Solaris Cluster 4.0