Skip Navigation Links | |
Exit Print View | |
![]() |
Oracle Solaris Cluster Data Service for Oracle Real Application Clusters Guide Oracle Solaris Cluster |
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
Oracle RAC Framework Resource Group
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 Version 9i, 10g Release 2, 11g, or 12c
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 an Oracle Clusterware Resource for Interoperation With Oracle Solaris Cluster
How to Create an Oracle Grid Infrastructure Resource for Interoperation With Oracle Solaris Cluster
Oracle 9i RAC Server Resources
The SUNW.scalable_rac_server resource type represents the Oracle RAC server in an Oracle Solaris Cluster configuration.
Oracle RAC server instances should be started only after the Oracle RAC framework is enabled on a cluster node. You ensure that this requirement is met by creating the following affinities and dependencies:
A strong positive affinity between the Oracle RAC server resource group and the Oracle RAC framework resource group
A dependency between the Oracle RAC server resource and the Oracle RAC framework resource
Perform this procedure on only one node of the cluster.
Each node where Support for Oracle RAC can run requires a logical hostname resource. Create each logical hostname resource as follows:
Set the properties of the resource group as follows:
Specify the node for which you are creating the logical hostname resource as the primary node.
Specify the remaining nodes where Support for Oracle RAC can run as potential primary nodes.
Choose an order for the potential primary nodes that ensures that the logical hostname resources are distributed equally throughout the cluster.
Ensure that the resource group is failed back to the primary node when the database instance on the primary node recovers after a failure.
# clresourcegroup create -n nodelist -p failback=true \ [-p rg_description="description"] \ lh-name-rg
Specifies a comma-separated list of names of the nodes that can master this resource group. Ensure that the node for which you are creating the logical hostname resource appears first in the list. Choose an order for the remaining nodes that ensures that the logical hostname resources are distributed equally throughout the cluster.
Specifies an optional brief description of the resource group. This description is displayed when you use Oracle Solaris Cluster maintenance commands to obtain information about the resource group.
Specifies your choice of name to assign to the resource group.
# clreslogicalhostname create -h lh-name -g lh-name-rg lh-name-rs
Specifies the logical hostname that this resource is to make available. An entry for this logical hostname must exist in the name service database.
Specifies that you are adding the resource to the resource group that you created in Step 2.
Specifies your choice of name to assign to the logical hostname resource.
# clresourcegroup create -n nodelist \ -p maximum_primaries=num-in-list \ -p desired_primaries=num-in-list \ -p rg_affinities=++rac-fmwk-rg \ [-p rg_description="description"] \ -p rg_mode=Scalable rac-db-rg
Specifies a comma-separated list of cluster nodes on which Support for Oracle RAC is to be enabled. The Support for Oracle RAC software packages must be installed on each node in this list.
Specifies the number of nodes on which Support for Oracle RAC is to be enabled. This number must equal the number of nodes in nodelist.
Specifies the number of nodes on which Support for Oracle RAC is to be enabled. This number must equal the number of nodes in nodelist.
Creates a strong positive affinity to the Oracle RAC framework resource group. If the Oracle RAC framework resource group was created by using the clsetup utility, the Oracle RAC framework resource group is named rac-framework-rg.
Specifies an optional brief description of the resource group. This description is displayed when you use Oracle Solaris Cluster maintenance commands to obtain information about the resource group.
Specifies that the resource group is scalable.
Specifies the name that you are assigning to the resource group.
# clresourcetype register SUNW.scalable_rac_listener
When you create this resource, specify the following information about the resource:
The name of the Oracle listener on each node where Oracle RAC is to run. This name must match the corresponding entry in the listener.ora file for the node.
The Oracle home directory. The Oracle home directory contains the binary files, log files, and parameter files for the Oracle software.
# clresource create -g rac-db-rg \ -t SUNW.scalable_rac_listener \ -p resource_dependencies_weak=lh-rs-list \ [-p resource_dependencies=db-bin-rs] \ -p listener_name{node}=listener[…] \ -p oracle_home=ora-home \ rac-lsnr-rs
Specifies the resource group to which you are adding the resource. This resource group must be the resource group that you created in Step 3.
Specifies that this Oracle listener resource has a strong dependency on the storage resource for binary files. Specify this dependency only if you are using the Sun QFS shared file system or a qualified NAS device for Oracle binary files. The storage resource for Oracle binary files is created when you perform the tasks in Registering and Configuring Storage Resources for Oracle Files.
Specifies the name of the Oracle listener instance on node node. This name must match the corresponding entry in the listener.ora file.
Specifies a comma-separated list of resources on which this resource is to have a weak dependency. The list must contain all the logical hostname resources that you created in Step 2.
Specifies the path to the Oracle home directory. The Oracle home directory contains the binary files, log files, and parameter files for the Oracle software.
Specifies the name that you are assigning to the SUNW.scalable_rac_listener resource.
# clresourcetype register SUNW.scalable_rac_server
When you create this resource, specify the following information about the resource:
The Oracle home directory. The Oracle home directory contains the binary files, log files, and parameter files for the Oracle software.
The Oracle system identifier on each node where Oracle RAC is to run. This identifier is the name of the Oracle database instance on the node.
The full path to the alert log file on each node where Oracle RAC is to run.
# clresource create -g rac-db-rg \ -t SUNW.scalable_rac_server \ -p resource_dependencies=rac-fmwk-rs \ -p resource_dependencies_offline_restart=[db-storage-rs][,db-bin-rs] \ -p resource_dependencies_weak=rac-lsnr-rs \ -p oracle_home=ora-home \ -p connect_string=string \ -p oracle_sid{node}=ora-sid[…] \ -p alert_log_file{node}=al-file[…] \ rac-srvr-rs
Specifies the resource group to which you are adding the resource. This resource group must be the resource group that you created in Step 3.
Specifies the resources on which this Oracle RAC server resource has a strong dependency.
You must specify the Oracle RAC framework resource. If the Oracle RAC framework resource group is created by using the clsetup utility or Oracle Solaris Cluster Manager, this resource is named rac-framework-rs.
If you are using a volume manager or the Sun QFS shared file system for database files, you must also specify the storage resource for database files.
If you are using the Sun QFS shared file system for Oracle binary files, you must also specify the storage resource for binary files.
The storage resources for Oracle files are created when you perform the tasks in Registering and Configuring Storage Resources for Oracle Files.
Specifies a weak dependency by this Oracle RAC server resource on the Oracle listener resource that you created in Step 5.
Specifies the Oracle system identifier on node node. This identifier is the name of the Oracle database instance on the node. You must set a different value for this property on each node where Oracle RAC is to run.
Specifies the path to the Oracle home directory. The Oracle home directory contains the binary files, log files, and parameter files for the Oracle software.
Specifies the Oracle database user ID and password that the fault monitor uses to connect to the Oracle database. string is specified as follows:
userid/password
Specifies the Oracle database user ID that the fault monitor uses to connect to the Oracle database.
Specifies the password that is set for the Oracle database user userid.
The database user ID and password are defined during the setup of Oracle RAC. To use Solaris authentication, type a slash (/) instead of a user ID and password.
Specifies the name that you are assigning to the SUNW.scalable_rac_server resource.
# clresourcegroup online -emM rac-db-rg
Specifies that a resource group that you created in Step 3 is to be moved to the MANAGED state and brought online.
Example D-1 Registering and Configuring Oracle Solaris Cluster Resources for Interoperation With Oracle 9i
This example shows the sequence of operations that is required to register and configure Oracle Solaris Cluster resources for interoperation with Oracle 9i on a two-node cluster.
The example makes the following assumptions:
Support for Oracle RAC is to run on all cluster nodes.
The C shell is used.
An Oracle RAC framework resource group that is named rac-framework-rg exists and contains a resource of type SUNW.rac_framework that is named rac_framework-rs.
A resource of type SUNW.ScalDeviceGroup that is named db-storage-rs represents the Solaris Volume Manager for Sun Cluster multi-owner disk set where the Oracle database files are stored.
The Oracle binary files are installed on the cluster file system, for which no storage resource is required.
To create the logical hostname resource for node phys-schost-1, the following commands are run:
# clresourcegroup create -n phys-schost-1,phys-schost-2 -p failback=true \ -p rg_description="Logical hostname schost-1 RG" \ schost-1-rg # clreslogicalhostname create -h schost-1 -g schost-1-rg schost-1
To create the logical hostname resource for node phys-schost-2, the following commands are run:
# clresourcegroup create -n phys-schost-2,phys-schost-1 -p failback=true \ -p rg_description="Logical hostname schost-2 RG" \ schost-2-rg # clreslogicalhostname create -h schost-2 -g schost-2-rg schost-2
To create a scalable resource group to contain the Oracle RAC server resource and Oracle listener resource, the following command is run:
# clresourcegroup create -S \ -p rg_affinities=++rac_framework-rg \ -p rg_description="RAC 9i server and listener RG" \ rac-db-rg
To register the SUNW.scalable_rac_listener resource type, the following command is run:
# clresourcetype register SUNW.scalable_rac_listener
To add an instance of the SUNW.scalable_rac_listener resource type to the rac-db-rg resource group, the following command is run:
# clresource create -g rac-db-rg \ -t SUNW.scalable_rac_listener \ -p resource_dependencies_weak=schost-1,schost-2 \ -p listener_name\{phys-schost-1\}=LISTENER1 \ -p listener_name\{phys-schost-2\}=LISTENER2 \ -p oracle_home=/home/oracle/product/9.2.0 \ scalable_rac_listener-rs
A different value of the listener_name extension property is set for each node that can master the resource.
To register the SUNW.scalable_rac_server resource type, the following command is run:
# clresourcetype register SUNW.scalable_rac_server
To add an instance of the SUNW.scalable_rac_listener resource type to the rac-db-rg resource group, the following command is run:
# clresource create -g rac-db-rg \ -t SUNW.scalable_rac_server \ -p resource_dependencies=rac_framework-rs, db-storage-rs \ -p resource_dependencies_weak=scalable_rac_listener-rs \ -p oracle_home=/home/oracle/product/9.2.0 \ -p connect_string=scooter/t!g3r \ -p oracle_sid\{phys-schost-1\}=V920RAC1 \ -p oracle_sid\{phys-schost-2\}=V920RAC2 \ -p alert_log_file\{phys-schost-1\}=/home/oracle/9.2.0/rdbms/log/alert_V920RAC1.log \ -p alert_log_file\{phys-schost-2\}=/home/oracle/9.2.0/rdbms/log/alert_V920RAC2.log \ scalable_rac_server-rs
A different value of the following extension properties is set for each node that can master the resource:
alert_log_file
oracle_sid
To bring online the resource group that contains the Oracle RAC server resource and Oracle listener resource, the following command is run:
# clresourcegroup online -emM rac-db-rg
Next Steps
Go to Verifying the Installation and Configuration of Support for Oracle RAC.