Skip Navigation Links
Exit Print View
| Oracle Solaris Cluster Data Service for Oracle External Proxy Guide Oracle Solaris Cluster 4.1

Search Scope:

- This Document
- Entire Library

## Registering and Configuring HA for Oracle External Proxy

The following sections describe how to register and configure HA for Oracle External Proxy.

- Setting HA for Oracle External Proxy Extension Properties

- Tools for Registering and Configuring HA for Oracle External Proxy

- How to Register and Configure HA for Oracle External Proxy

- Setting up Dependencies on Oracle External Proxy Resources

- How to Verify Data Service Installation and Configuration

You can configure HA for Oracle External Proxy as a failover service or as a scalable service.

### Setting HA for Oracle External Proxy Extension Properties

The sections that follow contain instructions for registering and configuring HA for Oracle External Proxy resources. For information about the extension properties, see Appendix A, HA for Oracle External Proxy Extension Properties. The Tunable entry indicates when you can update a property.

See the `rt_properties`(5), `r_properties`(5), and `rg_properties`(5) man pages for details on all of the Oracle Solaris Cluster extension properties.

To set an extension property of a resource, include the following option in the `clresource` command that creates or modifies the resource:

    -p property=value

`-p` property

  Identifies the extension property that you are setting.

value

  Specifies the value to which you are setting the extension property.

You can also use the procedures in Chapter 2, Administering Data Service Resources, in Oracle Solaris Cluster Data Services Planning and Administration Guide to configure resources after the resources are created.

### Tools for Registering and Configuring HA for Oracle External Proxy

Oracle Solaris Cluster provides the following tool for registering and configuring HA for Oracle External Proxy:

- Oracle Solaris Cluster maintenance commands. For more information, see How to Register and Configure HA for Oracle External Proxy .

## How to Register and Configure HA for Oracle External Proxy

Complete the registration and configuration on any cluster member.

Before You Begin

Ensure that you have completed the requirements as described in Configuration Requirements.

1. On a cluster member, assume a `root` role or assume a role that provides `solaris.cluster.admin` RBAC authorization.
2. Register the `ORCL.oracle_external_proxy` resource type for the data service.

       # clresourcetype register ORCL.oracle_external_proxy

3. Create either a scalable or a failover resource group for the Oracle External Proxy resource.

   For example, to create a scalable resource group, do the following:

       # clresourcegroup create -S [-n node-zone-list]  resource-group

   resource-group

     Specifies the name of the scalable service resource group to add.

   `-n` node-zone-list

     Specifies a comma-separated, ordered list of nodes that can master this resource group. This list is optional. If you omit this list, then all the nodes of the global cluster or zone cluster are used to master the resource group.

4. Create an Oracle External Proxy resource in the resource group that you created.

       # clresource create -g resource-group \
       -t ORCL.oracle_external_proxy
       -p service_name=service-name \
       -p ons_nodes=ons-nodes \
       -p dbuser=dbuser \
       [-p plugin_name=plugin-name] \
       [-p tns_admin=tns-admin] \
       -d  \
       resource

   `-g` resource-group

     Specifies the name of the resource group .

   `-t` resource-type

     Specifies the resource type to add.

   `-p` `service_name`=service-name

     Specifies the Oracle Database or Real Application Clusters (RAC) service name that the Oracle External Proxy uses to connect to the database.

   `-p` `ons_nodes`=ons-nodes

     Specifies the Remote Oracle Notification Service (ONS) nodes that the Oracle External Proxy uses to connect to the database, for example `node:port[node:port]`.

   `-p` `dbuser`=dbuser

     Specifies the server side Oracle database user that the Oracle External Proxy uses to connect to the database.

   `-p` `plugin_name`=plugin-name

     Specifies the plugin module that the Oracle External Proxy uses to connect to the database. You can omit this entry as it will default to `OracleExternalProxy`.

   `-p` `tns_admin`=tns-admin

     Specifies the client-side location for the Oracle `tns_admin` path that the Oracle External Proxy uses to connect to the database. Omit this entry so that it defaults to the `/var/opt/oracle` directory.

   `-d`

     Creates the resource in the disabled state.

   resource

     Specifies your choice for the name of the resource to add.

   Note - Optionally, you can set additional extension properties that belong to the Oracle External Proxy data service to override their default values. See Appendix A, HA for Oracle External Proxy Extension Properties for a list of extension properties.

5. Bring the resource group online.

       # clresourcegroup online -emM resource-group

   resource-group

     Specifies the name of the resource group.

   The Oracle Solaris Cluster resource is now configured and online, thereby interrogating the state of the remote database. .

Example 1-2 Creating an `ORCL.oracle_external_proxy` Resource

This example shows the commands for performing the following operations which create a scalable multi-master `ORCL.oracle_external_proxy` resource on a two-node cluster.

- Creating the `oep-rg` resource group

- Registering the `ORCL.oracle_external_proxy` resource type

- Adding the `oep-rs` resource to the `oep-rg` resource group

This example assumes that default values are being used for the `dbuser`, `tns_admin`, and `plugin_name` extension properties. It also assumes that the `dbuser` password has been encrypted on each cluster node.

    phys-schost-1# clresourcetype register ORCL.oracle_external_proxy
    phys-schost-1# clresourcegroup create -S oep-rg
    phys-schost-1# clresource create -g oep-rg \
    -t ORCL.oracle_external_proxy \
    -p service_name=orcl \
    -p ons_nodes=binks-scan-lh:6200 \
    -d \
    oep-rs
    phys-schost-1# clresourcegroup online -M oep-rg
    phys-schost-1# clresource enable oep-rs

Example 1-3 Registering Failover HA for Oracle External Proxy

The following example shows how to register a failover Oracle External Proxy service.

    phys-schost-1# clresourcetype register ORCL.oracle_external_proxy
    phys-schost-1# clresourcegroup create oep-rg
    phys-schost-1# clresource create -g oep-rg \
    -t ORCL.oracle_external_proxy \
    -p service_name=orcl \
    -p ons_nodes=binks-scan-lh:6200 \
    -d \
    oep-rs
    phys-schost-1# clresourcegroup online -M oep-rg
    phys-schost-1# clresource enable oep-rs

### Setting up Dependencies on Oracle External Proxy Resources

To use the Oracle Solaris Cluster resource as a dependency for an application resource, set up appropriate dependencies as shown in the following example.

Example 1-4 Setting Up Application Resource Group Dependencies

As an example, when the Oracle External Proxy resource is within a scalable resource group and the application resource is within a failover resource group, you can do the following:

    # clrg set -p RG_Affinities=++oep-rg app-rg
    # clrs set -p resource_dependencies_offline_restart=oep-rs{any_node} app-rs

As an example, when the Oracle External Proxy resource and the application resource are within the same failover resource group, you can do the following:

    # clrs set -p resource_dependencies_offline_restart=oep-rs app-rs

As an example, when the Oracle External Proxy resource and the application resource are in separate failover resource groups, you can do the following:

    # clrg set -p RG_Affinities=++oep-rg app-rg
    # clrs set -p resource_dependencies_offline_restart=oep-rs app-rs

### How to Verify Data Service Installation and Configuration

After the Oracle External Proxy resource has been installed, configured, and registered, verify it by enabling the Oracle External Proxy resource. Once the Oracle External Proxy resource has been enabled, the resource status will reflect the state and status of the server-side Oracle database. The presence of a resource status message is verification that the Oracle External Proxy has been installed and configured.

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