SUNW.scalable_rac_server_proxy

, scalable_rac_server_proxy

- resource type implementation for the Oracle Real Application Clusters (Oracle RAC) server proxy managed by Oracle Solaris Cluster

Description

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.

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:

  1. To register this resource type, use the clresourcetype command.

  2. To create instances of this resource type, use the clresource command.

Standard Properties

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:

Boot_timeout

Minimum

5

Default

30

Failover_mode

Default

None

Tunable

Any time

Fini_timeout

Minimum

5

Default

30

Init_timeout

Minimum

5

Default

30

Load_balancing_policy

Default

LB_weighted

Tunable

At creation

Load_balancing_weights

Default

Empty string

Tunable

Any time

Network_resources_used (string array)

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.

Category

Conditional/Optional

Default

The empty list

Tunable

When disabled

Resource_dependencies (string array)

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.

Category

Optional

Default

The empty list

Tunable

Any time

Port_list

Default

None

Tunable

At creation

Retry_Count

Maximum

10

Default

2

Tunable

Any time

Retry_Interval

Maximum

3600

Default

300

Tunable

Any time

Start_timeout

Minimum

5

Default

600

Stop_timeout

Minimum

5

Default

600

Thorough_probe_interval

Minimum

1

Maximum

2592000

Default

20

Tunable

Any time

Update_timeout

Minimum

5

Default

240

Validate_timeout

Minimum

5

Default

120

Extension Properties

The extension properties of the SUNW.scalable_rac_server_proxy resource type are as follows.

client_retries

This property specifies the maximum number of attempts by the resource's remote procedure call (RPC) client to connect to the proxy daemon.

Data Type

Integer

Range

1–25

Default

3

Tunable

When disabled

client_retry_interval

This property specifies the interval, in seconds, between attempts by the resource's remote procedure call (RPC) client to connect to the proxy daemon.

Data Type

Integer

Range

1–3600

Default

5

Tunable

When disabled

crs_home

This property specifies the directory in which the Oracle Clusterware software is located.

Data Type

String

Range

Not applicable

Default

No default defined

Tunable

When disabled

db_name

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.

Data Type

String

Range

Not applicable

Tunable

When disabled

debug_level

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.

Data Type

Integer

Range

0–100

Default

1, which logs syslog messages

Tunable

Any time

monitor_probe_interval

This property specifies the interval, in seconds, between probes of the Oracle Clusterware resource for which this resource is acting as a proxy.

Data Type

Integer

Range

10–3600

Default

300

Tunable

Any time

oracle_home

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.

Data Type

String

Range

Not applicable

Default

No default defined

Tunable

When disabled

oracle_sid

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.

Data Type

String

Range

Not applicable

Default

NULL

Tunable

When disabled

proxy_probe_timeout

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.

Data Type

Integer

Range

5–3600

Default

120

Tunable

Any time

startup_wait_count

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.

Data Type

Integer

Range

10–600

Default

20

Tunable

When disabled

user_env

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.

Data Type

String

Range

Not applicable

Default

No default defined

Tunable

Any time

Examples

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:

1. Creating the rac-proxy-db-rg resource group

2. Registering the SUNW.scalable_rac_server_proxy resource type

3. 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:

  Resource Type Resource Name SUNW.crs_framework crs_framework-rs SUNW.rac_framework rac_framework-rs SUNW.rac_udlm rac_udlm-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

Attributes

See attributes(5) for descriptions of the following attributes:

See Also

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