Skip Navigation Links | |
Exit Print View | |
![]() |
Oracle Solaris Cluster Data Services Reference Manual Oracle Solaris Cluster |
ORCL.obiee_cluster_controller(5)
ORCL.obiee_presentation_service(5)
scalable_asm_diskgroup_proxy(5)
scalable_asm_instance_proxy(5)
SUNW.scalable_asm_diskgroup_proxy(5)
- resource type implementation for the Oracle Real Application Clusters (Oracle RAC) server proxy managed by Oracle Solaris Cluster
The SUNW.scalable_rac_server_proxy resource type represents a proxy for the Oracle RAC 10g release 2 or 11g server in an Oracle Solaris Cluster configuration.
Note - Use the SUNW.scalable_rac_server_proxy resource type only if you are using Oracle RAC 10g release 2 or 11g. If you are using Oracle 9i, use the SUNW.scalable_rac_server resource type.
Starting in Oracle 10g, Oracle Clusterware manages the startup and shutdown of Oracle RAC server instances. To be managed by the Oracle Clusterware, these instances must be registered with the Oracle Clusterware. The Oracle Clusterware software also provides automatic fault monitoring and failure recovery for Oracle RAC server instances. These instances are represented as resources to Oracle Clusterware.
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 Clusterware. The proxy resource enables Oracle Solaris Cluster utilities to manage Oracle RAC server instances through Oracle Clusterware. In this way, the SUNW.scalable_rac_server_proxy resource type enables the clustering frameworks that are provided by Oracle Solaris Cluster and Oracle Clusterware to interoperate.
The SUNW.scalable_rac_server_proxy resource type enables you to use Oracle Solaris 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 Oracle Clusterware resource for which the SUNW.scalable_rac_server_proxy resource is acting as a proxy.
The online or offline status of Oracle Clusterware
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 Clusterware to manage the Oracle RAC database instance
The monitor probes the Oracle Clusterware determine if the Oracle Clusterware are managing the Oracle RAC database instance. If the Oracle Clusterware does not indicate that the Oracle Clusterware are managing the Oracle RAC database instance, the monitor warns that the instance is invalid. However, the Oracle Clusterware might not be managing the Oracle RAC database instance because the instance is unregistered with the Oracle Clusterware. In this situation, the Oracle 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 Oracle 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 Oracle Solaris Cluster utilities. This monitor does not provide fault monitoring and automatic fault recovery for Oracle RAC database instances. The Oracle Clusterware software provides this functionality.
Oracle RAC server instances should be started only after the Oracle 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 Oracle 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 Oracle Clusterware framework resource
Any storage resources for Oracle files that you are using
Create these dependencies and affinities when you configure database resources for the Oracle Solaris Cluster Support for Oracle RAC data service. For more information, see Configuring Resources for Oracle RAC Database Instances in Oracle Solaris Cluster Data Service for Oracle Real Application Clusters Guide.
To register this resource type and create instances of this resource type, use one of the following means:
Oracle Solaris Cluster Manager
The clsetup(1CL) utility, specifying the option for configuring Oracle Solaris Cluster Support for Oracle Real Application Clusters
The following sequence of Oracle Solaris Cluster maintenance commands:
To register this resource type, use the clresourcetype command.
To create instances of this resource type, use the clresource command.
Note - 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 Clusterware control, including processes for Oracle 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
A list of logical-hostname or shared-address network resources upon which this resource has a dependency. This list contains all network-address resources that appear in the properties Resource_dependencies, Resource_dependencies_weak, Resource_dependencies_restart, or Resource_dependencies_offline_restart.
This property is updated automatically by the RGM, based on the setting of the resource-dependencies properties. You do not set this property directly. Instead, use the Resource_dependencies property.
Conditional/Optional
The empty list
When disabled
Specifies a list of resources upon which a resource depends. This list includes any logical-hostname or shared-address network resources that are used by a resource. The default value for this property is null.
You can specify one or more resource names. Each network resource can contain one or more logical host names. See the clreslogicalhostname(1CL) and clressharedaddress(1CL) man pages for more information.
You can specify an alternate kind of dependency by using the Resource_dependencies_weak, Resource_dependencies_restart, or Resource_dependencies_offline_restart property instead of the Resource_dependencies property. For more information, see the r_properties(5) man page.
Optional
The empty list
Any time
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–3600
5
When disabled
This property specifies the directory in which the Oracle Clusterware 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 Oracle Clusterware resource for which this resource is acting as a proxy.
Integer
10–3600
300
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 Oracle Clusterware resource for which this resource is acting as a proxy.
Integer
5–3600
120
Any time
This property specifies the maximum number of attempts by this resource to confirm that the Oracle Clusterware 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 Clusterware 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
Example 1 Creating a scalable_rac_server_proxy Resource
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.
An Oracle RAC database that is named V1020RAC is registered with the Oracle Clusterware.
A resource group that is named scal-dg-rg exists and contains a resource of type SUNW.ScalDeviceGroup that is named scal-dg-rs.
An Oracle RAC framework resource group that is named rac-framework-rg exists and contains resources that are shown in the following table:
|
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:
|
clresource(1CL), clresourcetype(1CL), clsetup(1CL), attributes(5), r_properties(5), SUNW.rac_udlm(5), SUNW.scalable_rac_server(5)
Oracle Solaris Cluster Data Service for Oracle Real Application Clusters Guide, Oracle Solaris Cluster Data Services Planning and Administration Guide