Skip Navigation Links | |
Exit Print View | |
Oracle Solaris Cluster Data Service for Oracle Real Application Clusters Guide |
1. Installing Support for Oracle RAC
2. Configuring Storage for Oracle Files
3. Registering and Configuring the Resource Groups
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
Setting Support for Oracle RAC Extension Properties
Overview of the Framework Resource Groups
Multiple-Owner Volume-Manager Framework Resource Group
Registering and Configuring Oracle ASM Resource Groups (CLI)
How to Register and Configure Oracle ASM Resource Groups in the Global Cluster (CLI)
How to Register and Configure Oracle ASM Resource Groups in a Zone Cluster (CLI)
Creating Storage Management Resources by Using Oracle Solaris Cluster Maintenance Commands
Resources for Scalable Device Groups and Scalable File-System Mount Points
Resources for the Sun QFS Metadata Server
Configuration of Sun QFS Resource Groups With Oracle 9i and Oracle 10g Release 2 or 11g
Configuration of Sun QFS Resource Groups With Oracle 10g Release 1
How to Create a Resource for a Scalable Device Group in the Global Cluster
How to Create a Resource for a Scalable Device Group in a Zone Cluster
How to Register and Configure Resources for the Sun QFS Metadata Server in the Global Cluster
How to Register and Configure Resources for the Sun QFS Metadata Server for a Zone Cluster
How to Create a Resource for a File-System Mount Point in the Global Cluster
How to Create a Resource for a File-System Mount Point in Zone Cluster
How to Create Oracle Solaris Cluster Resources for Interoperation With Oracle 10g or 11g
How to Create an Oracle Clusterware Resource for Interoperation With Sun Cluster
How to Create an Oracle Clusterware Oracle ASM Resource for Interoperation With Sun Cluster Software
Oracle 9i RAC Server Resources
Perform this procedure on only one node of the cluster.
Note - When a step in the procedure requires running the Oracle Solaris Cluster commands in a zone cluster, you should run the command from the global cluster and use the -Z option to specify the zone cluster.
# clresourcetype register -Z zcname SUNW.crs_framework
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 Mount Point in Zone 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 Mount Point in Zone Cluster.
# clresource create -Z zcname -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
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 affinity 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 Mount Point in Zone Cluster.
Tip - If you require 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 -Z zcname -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
# clresourcetype register -Z zcname SUNW.scalable_rac_server_proxy
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 Mount Point in Zone Cluster.
Set a different value of the oracle_sid extension property for each node that can master the resource.
# clresource create -Z zcname -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, bin-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
# clresourcegroup online -Z zcname -emM rac-db-rg