Skip Navigation Links
Exit Print View
| Oracle Solaris Cluster Data Services Reference Manual Oracle Solaris Cluster 4.1

Search Scope:

- This Document
- Entire Library

### 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.

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 inter-operate.

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:

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

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.

### 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`

    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:

ATTRIBUTE TYPE | ATTRIBUTE VALUE
--- | ---
Availability | `ha-cluster/data-service/oracle-database`

## See Also

`clresource`(1CL), `clresourcetype`(1CL), `clsetup`(1CL), `attributes`(5), `r_properties`(5), Broken Link (Target ID: 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

Copyright © 2000, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices |