JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Oracle Solaris Cluster Data Service for Oracle External Proxy Guide     Oracle Solaris Cluster 4.1
search filter icon
search icon

Document Information

Preface

1.  Installing and Configuring HA for Oracle External Proxy

Overview

Planning the Installation and Configuration

Configuration Requirements

Remote Database User

Secure Remote Database Password

tnsnames.ora File

Remote Oracle Notification Service

Overview of the Installation and Configuration Process for HA for Oracle External Proxy

Installing the HA for Oracle External Proxy Package

How to Install the HA for Oracle External Proxy Package

Registering and Configuring 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

Operations By HA for Oracle External Proxy

Actions in Response to Faults

Upgrading the ORCL.oracle_external_proxy Resource Type

Information for Registering the New Resource Type Version

Information for Migrating Existing Instances of the Resource Type

A.  HA for Oracle External Proxy Extension Properties

Index

Registering and Configuring HA for Oracle External Proxy

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

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:

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.

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.