Complete the registration and configuration on any cluster member.
Before You Begin
Ensure that you have completed the requirements as described in Configuration Requirements.
# clresourcetype register ORCL.oracle_external_proxy
For example, to create a scalable resource group, do the following:
# clresourcegroup create -S [-n node-zone-list] resource-group
Specifies the name of the scalable service resource group to add.
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.
# 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
Specifies the name of the resource group .
Specifies the resource type to add.
Specifies the Oracle Database or Real Application Clusters (RAC) service name that the Oracle External Proxy uses to connect to the database.
Specifies the Remote Oracle Notification Service (ONS) nodes that the Oracle External Proxy uses to connect to the database. For a remote Oracle database, specify ONS_NODES=scan:port or ONS_NODES=node:port[node:port]. For a local Oracle database, specify ONS_NODES=localhost:port.
Specifies the server side Oracle database user that the Oracle External Proxy uses to connect to the database. If the database is being used as a standby database, you must grant the sysdba privilege to the user, and specify dbuser="hauser as sysdba" where hauser represents your entry for dbuser. For information on how to grant the sysdba privilege to the user, see Database User.
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.
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.
Creates the resource in the disabled state.
Specifies your choice for the name of the resource to add.
# clresourcegroup online -emM 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.
This example shows the commands for performing the following operations which create a multi-master ORCL.oracle_external_proxy resource.
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-rsExample 7 Creating a Multi-master ORCL.oracle_external_proxy for a Remote Oracle Database 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-rsExample 8 Creating a Multi-master ORCL.oracle_external_proxy Resource for a Local Oracle Database Service
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=sales \ -p ons_nodes=localhost:6100 \ -p resource_dependencies_offline_restart=<OSC RAC resource>\ -d \ oep-rs phys-schost-1# clresourcegroup online -M oep-rg phys-schost-1# clresource enable oep-rsExample 9 Configuring ORCL.oracle_external_proxy for Pluggable Database (PDB) in a RAC Container Database (CDB)
In this example CDB name is orcl and has instances orcl1 and orcl2, PDB name is pdb1. The CDB is administrator-managed.
This example assumes that SUNW.scalable_rac_server_proxy resource named rac-server-proxy-rs exists for the CDB and the CDB instances run on all cluster nodes.
Add local service for PDB with same name as PDB and start the service.
$ srvctl add service -d orcl -s pdb1 -r orcl1,orcl2 $ srvctl start service -d orcl -s pdb1
In all nodes ensure that $ORACLE_HOME/network/admin/tnsnames.ora contains entry for the pdb1 service created in step 1 above.
Ensure that database user (for example, hauser) required to connect to the database has been created in the CDB.
Ensure that the database password has been provided using clpstring.
Create resource group and ORCL.oracle_external_proxy resource for the PDB and enable it.
# clrg -S create pdb1-rg # clrs create -t ORCL.oracle_external_proxy -g pdb1-rg \ -p resource_dependencies_offline_restart=rac-server-proxy-rs \ -p ons_nodes=localhost:6100 \ -p service_name=pdb1 \ -p tns_admin=$ORACLE-HOME/network/admin pdb1 # clrg online -eM pdb1-rg