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
Perform the steps in this procedure to register and configure Oracle Solaris Cluster resources in a zone cluster for interoperation with Oracle 9i.
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 -Z zcname -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 -Z zcname -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 -Z zcname -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 -Z zcname 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 -Z zcname -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 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 -Z zcname 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 -Z zcname -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 -Z zcname -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.