How to Create Sun Cluster Resources for Interoperation With Oracle 10g

Perform this procedure on only one node of the cluster.

1. Become superuser or assume a role that provides solaris.cluster.admin and solaris.cluster.modify RBAC authorizations.

2. Register the SUNW.crs_framework resource type.

   # clresourcetype register SUNW.crs_framework

3. Add an instance of the SUNW.crs_framework resource type to the RAC framework resource group.

   For information about this resource group, see Registering and Configuring the RAC Framework Resource Group.

   Set a strong dependency by the instance of SUNW.crs_framework on the instance of SUNW.rac_framework in the RAC framework resource group.

   You might have configured a storage resource for the storage that you are using for database files. In this situation, set an offline-restart dependency by the instance of SUNW.crs_framework on the storage resource. Limit the scope of this dependency to only the node where the storage resource is running.

   • If you are using a volume manager for database files, set the dependency on the resource that you created in How to Create a Resource for a Scalable Device Group in the Global Cluster.

   • If you are using a file system for database files, set the dependency on the resource that you created in How to Create a Resource for a File-System Mountpoint in the Global Cluster.

   You might have configured a storage resource for the file system that you are using for binary files. In this situation, set an offline-restart dependency by the instance of SUNW.crs_framework on the storage resource. Limit the scope of this dependency to only the node where the storage resource is running. Set the dependency on the resource that you created in How to Create a Resource for a File-System Mountpoint in the Global Cluster.

   # clresource create -t SUNW.crs_framework \ -g rac-fmwk-rg \ -p resource_dependencies=rac-fmwk-rs \ [-p resource_dependencies_offline_restart=db-storage-rs{local_node}\ [,bin-storage-rs{local_node}]] \ crs-fmwk-rs

4. Create a scalable resource group to contain the proxy resource for the Oracle RAC database server.

   Set a strong positive affinity by the scalable resource group for the RAC framework resource group.

   You might have configured a storage resource for the storage that you are using for database files. In this situation, set a strong positive affinity by the scalable resource group for the resource group that contains the storage resource for database files.

   • If you are using a volume manager for database files, set a strong positive for the resource group that you created in How to Create a Resource for a Scalable Device Group in the Global Cluster.

   • If you are using a file system for database files, set a strong positive affinity for the resource group that you created in How to Create a Resource for a File-System Mountpoint in the Global Cluster.

   ---

   Tip –

   If you require Sun Cluster Support for Oracle RAC to run on all cluster nodes, specify the -S option in the command that follows and omit the options -n, -p maximum_primaries, -p desired_primaries, and -p rg_mode.

   ---

   # clresourcegroup create -n nodelist \ -p maximum_primaries=num-in-list \ -p desired_primaries=num-in-list \ -p rg_affinities=++rac-fmwk-rg[,db-storage-rg] \ [-p rg_description="description" \] -p rg_mode=Scalable \ rac-db-rg

5. Register the SUNW.scalable_rac_server_proxy resource type.

   # clresourcetype register SUNW.scalable_rac_server_proxy

6. Add an instance of the SUNW.scalable_rac_server_proxy resource type to the resource group that you created in Step 4.

   Set a strong dependency by the instance of SUNW.scalable_rac_server_proxy on the instance of SUNW.rac_framework in the RAC framework resource group.

   Set an offline-restart dependency by the instance of SUNW.scalable_rac_server_proxy on the instance of SUNW.crs_framework that you created in Step 3.

   You might have configured a storage resource for the storage that you are using for database files. In this situation, set an offline-restart dependency by the instance of SUNW.scalable_rac_server_proxy on the storage resource. Limit the scope of this dependency to only the node where the storage resource is running.

   • If you are using a volume manager for database files, set the dependency on the resource that you created in How to Create a Resource for a Scalable Device Group in the Global Cluster.

   • If you are using a file system for database files, set the dependency on the resource that you created in How to Create a Resource for a File-System Mountpoint in the Global Cluster.

   Set a different value of the oracle_sid extension property for each node that can master the resource.

   # clresource create -g rac-db-rg \ -t SUNW.scalable_rac_server_proxy \ -p resource_dependencies=rac-fmwk-rs \ -p resource_dependencies_offline_restart=crs-fmk-rs[, db-storage-rs] \ -p oracle_home=ora-home \ -p crs_home=crs-home \ -p db_name=db-name \ -p oracle_sid{node1-id}=sid-node1 \ [ -p oracle_sid{node2-id}=sid-node2 \…] rac-srvr-proxy-rs

7. Bring online the resource group that you created in Step 4.

   # clresourcegroup online -emM rac-db-rg