NAME | Description | Examples | Attributes | See Also
The SUNW.scalable_rac_server_proxy resource type represents a proxy for the Oracle 10g R2 RAC server in a Sun Cluster configuration.
Use the SUNW.scalable_rac_server_proxy resource type only if you are using Oracle 10g R2 RAC. If you are using Oracle 9i, use the SUNW.scalable_rac_server(5) resource type.
In Oracle 10g, Oracle Cluster Ready Services (CRS) manage the startup and shutdown of RAC server instances. To be managed by the CRS, these instances must be registered with the CRS. The Oracle CRS software also provides automatic fault monitoring and failure recovery for RAC server instances. These instances are represented as resources to Oracle CRS.
A resource of type SUNW.scalable_rac_server_proxy is a proxy resource: The proxy resource acts as a substitute for a resource that is managed by Oracle CRS. The proxy resource enables Sun Cluster utilities to manage Oracle RAC server instances through Oracle CRS. In this way, the SUNW.scalable_rac_server_proxy resource type enables the clustering frameworks that are provided by Sun Cluster and Oracle Cluster Ready Services (CRS) to interoperate.
The SUNW.scalable_rac_server_proxy resource type enables you to use Sun Cluster utilities as an alternative to Oracle utilities to start and stop Oracle RAC database instances.
Each resource of type SUNW.scalable_rac_server_proxy has a monitor that obtains the following status information from the CRS resource for which the SUNW.scalable_rac_server_proxy resource is acting as a proxy.
The online or offline status of Oracle CRS
The status of an Oracle RAC database instance:
Online and enabled
Online but disabled
Offline and disabled
The success or failure of an attempt to start or stop a database instance
The ability of Oracle CRS to manage the Oracle RAC database instance
The monitor probes the Oracle CRS determine if the CRS are managing the RAC database instance. If the CRS does not indicate that the CRS are managing the RAC database instance, the monitor warns that the instance is invalid. However, the Oracle CRS might not be managing the RAC database instance because the instance is unregistered with the CRS. In this situation, the RAC database instance might be valid, despite the warning.
The timeout period that the monitor uses for obtaining status information is determined by the proxy_probe_timeout extension property. If the timeout period is too short, timeouts might cause the monitor to report the status of a valid RAC database instance as invalid. In this situation, consider increasing the value of the he proxy_probe_timeout extension property.
This monitor only enables the status of Oracle RAC database instances to be monitored by Sun Cluster utilities. This monitor does not provide fault monitoring and automatic fault recovery for Oracle RAC database instances. The Oracle CRS software provides this functionality.
Oracle RAC server instances should be started only after the RAC framework and any storage resources are enabled on the cluster node. To ensure that this requirement is met, configure the Oracle RAC server proxy resource as follows:
Create a strong positive affinity between the Oracle RAC server proxy resource group and the following resource groups:
The RAC framework resource group
Any resource group that contains storage resources for Oracle files
Create a strong dependency between the Oracle RAC server proxy resource and the RAC framework resource.
Create an offline-restart dependency between the Oracle RAC server proxy resource and the following resources:
The CRS framework resource
Any storage resources for Oracle files that you are using
Create these dependencies and affinities when you configure database resources for the Sun Cluster Support for Oracle RAC data service. For more information, see Configuring Resources for Oracle RAC Database Instances in Sun Cluster Data Service for Oracle RAC Guide for Solaris OS in Sun Cluster Data Service for Oracle RAC Guide for Solaris OS.
To register this resource type and create instances of this resource type, use one of the following means:
Sun Cluster Manager
The clsetup(1CL) utility, specifying the option for configuring Sun Cluster Support for Oracle Real Application Clusters
The following sequence of Sun Cluster maintenance commands:
To register this resource type, use the clresourcetype(1CL) command.
To create instances of this resource type, use the clresource(1CL) command.
A Solaris project might be specified for a SUNW.scalable_rac_server_proxy resource or the resource group that contains a SUNW.scalable_rac_server_proxy resource. In this situation, the project affects only the processes for the SUNW.scalable_rac_server_proxy resource. The project does not affect the processes for any resources that Oracle CRS control, including processes for RAC database instances.
For a description of all standard resource properties, see the r_properties(5) man page.
Standard resource properties are overridden for this resource type as follows:
5
30
None
Any time
5
30
5
30
LB_weighted
At creation
Empty string
Any time
When disabled
Empty string
None
At creation
10
2
Any time
3600
300
Any time
5
600
5
600
1
2592000
20
Any time
5
240
5
120
The extension properties of the SUNW.scalable_rac_server_proxy resource type are as follows.
This property specifies the maximum number of attempts by the resource's remote procedure call (RPC) client to connect to the proxy daemon.
Integer
1–25
3
When disabled
This property specifies the interval, in seconds, between attempts by the resource's remote procedure call (RPC) client to connect to the proxy daemon.
Integer
1–25
5
When disabled
This property specifies the directory in which the Oracle CRS software is located.
String
Not applicable
No default defined
When disabled
This property specifies the name that uniquely identifies the specific Oracle RAC database that is associated with this resource. This identifier distinguishes the database from other databases that might run simultaneously on your system. The name of the Oracle RAC database is specified during the installation of Oracle RAC.
String
Not applicable
When disabled
This property indicates the level to which debug messages from the monitor for the Oracle RAC proxy server are logged. When the debug level is increased, more debug messages are written to the log files.
The messages are logged to files in the directory /var/opt/SUNWscor/oracle_server/proxyrs. Messages for server-side components and client-side components of the proxy server resource are written to separate files:
Messages for server-side components are written to the file message_log.rs.
Messages for client-side components are written to the file message_log.client.rs.
In these file names and directory names, rs is the name of the resource that represents the Oracle RAC server component.
You can specify a different value of the debug_level extension property for each node that can master the resource.
Integer
0–100
1, which logs syslog messages
Any time
This property specifies the interval, in seconds, between probes of the CRS resource for which this resource is acting as a proxy.
Integer
10–600
120
Any time
This property specifies the full path to the Oracle home directory. The Oracle home directory contains the binary files, log files, and parameter files for the Oracle software.
String
Not applicable
No default defined
When disabled
This property specifies the Oracle System Identifier (SID). The Oracle SID uniquely identifies the Oracle RAC database instance on the node where the instance is running.
You must specify a different value of the oracle_sid extension property for each node that can master the resource. The value for each node must correctly identify the instance that is running on the node.
String
Not applicable
NULL
When disabled
This property specifies the timeout value, in seconds, that the proxy monitor uses when checking the status of the CRS resource for which this resource is acting as a proxy.
Integer
5–100
25
Any time
This property specifies the maximum number of attempts by this resource to confirm that the Oracle CRS software is started completely. The interval between attempts is twice the value of the proxy_probe_timeout extension property.
The resource requires confirmation that Oracle CRS software is started before attempting to start an Oracle RAC database instance. If the maximum number of attempts is exceeded, the resource does not attempt to start the database instance.
Integer
10–600
20
When disabled
This property specifies the name of the file that contains the environment variables that are to be set before the database starts up or shuts down. You must define all environment variables whose values differ from Oracle defaults in this file.
For example, a user's listener.ora file might not be located under the /var/opt/oracle directory or the oracle-home/network/admin directory. In this situation, the TNS_ADMIN environment variable must be defined.
The definition of each environment variable that is defined must follow the format variable-name=value. Each definition must start on a new line in the environment file.
You can specify a different value of the user_env extension property for each node that can master the resource.
String
Not applicable
No default defined
Any time
This example shows the commands for performing the following operations to create a scalable_rac_server_proxy resource on a two-node cluster:
Creating the rac-proxy-db-rg resource group
Registering the SUNW.scalable_rac_server_proxy resource type
Adding the scalable_rac_server_proxy-rs resource to the rac-proxy-db-rg resource group
A different value of the oracle_sid extension property is set for each node that can master the resource.
The example makes the following assumptions:
The C shell is used.
A RAC database that is named V1020RAC is registered with the Oracle CRS.
A resource group that is named scal-dg-rg exists and contains a resource of type SUNW.ScalDeviceGroup that is named scal-dg-rs.
A RAC framework resource group that is named rac-framework-rg exists and contains resources that are shown in the following table:
Resource Type |
Resource Name |
---|---|
SUNW.crs_framework |
crs_framework-rs |
SUNW.rac_framework |
rac_framework-rs |
SUNW.rac_udlm |
rac_udlm-rs |
SUNW.rac_svm |
rac_svm-rs |
phys-schost-1# clresourcegroup create \ -p rg_affinities=++rac-framework-rg,++scal-dg-rg \ -p desired_primaries=2 \ -p maximum_primaries=2 \ rac-proxy-db-rg phys-schost-1# clresourcetype register \ SUNW.scalable_rac_server_proxy phys-schost-1# clresource create -g rac-proxy-db-rg \ -t SUNW.scalable_rac_server_proxy \ -p resource_dependencies=rac_framework-rs \ -p resource_dependencies_offline_restart=crs-framework-rs,scal-dg-rs \ -p oracle_home=/home/oracle/product/10.2.0/oracle_install \ -p crs_home=/home/oracle/product/10.2.0/crs_install \ -p db_name=V1020RAC \ -p oracle_sid\{1\}=V1020RAC1 \ -p oracle_sid\{2\}=V1020RAC2 \ scalable_rac_server_proxy-rs |
See attributes(5) for descriptions of the following attributes:
ATTRIBUTE TYPE |
ATTRIBUTE VALUE |
---|---|
Availability |
SUNWscor |
clresource(1CL), clresourcetype(1CL), clsetup(1CL), attributes(5), r_properties(5), SUNW.rac_cvm(5), SUNW.rac_framework(5), SUNW.rac_svm(5), SUNW.rac_udlm(5), SUNW.scalable_rac_server(5)
Sun Cluster Data Service for Oracle RAC Guide for Solaris OS, Sun Cluster Data Services Planning and Administration Guide for Solaris OS
NAME | Description | Examples | Attributes | See Also