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, become superuser 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 zones 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.