How to Create an Oracle Grid Infrastructure Resource for Interoperation With Oracle Solaris Cluster

For Oracle RAC without Oracle ASM, perform this procedure to manually create an Oracle Grid Infrastructure resource that proxies the Oracle Solaris Cluster SUNW.ScalDeviceGroup or SUNW.ScalMountPoint resource.

This Oracle Grid Infrastructure resource ensures that the corresponding Oracle database is not started until the Oracle Grid Infrastructure resource is online. The resource comes online only if the corresponding SUNW.ScalDeviceGroup or SUNW.ScalMountPoint resource is online. And the SUNW.ScalDeviceGroup or SUNW.ScalMountPoint resource only comes online if the actual volume-manager disk set or disk group or the mount point is online.

1. Become superuser on one node of the cluster.
2. Create the Oracle Grid Infrastructure sun.storage_proxy.type resource type.

   # Grid_home/bin/crsctl \ add type sun.storage_proxy.type \ -basetype cluster_resource \ -attr \ "ATTRIBUTE=ACTION_SCRIPT,TYPE=string", \ "ATTRIBUTE=HOSTING_MEMBERS,TYPE=string", \ "ATTRIBUTE=CARDINALITY,TYPE=string", \ "ATTRIBUTE=PLACEMENT,TYPE=string", \ "ATTRIBUTE=SCRIPT_TIMEOUT,TYPE=int", \ "ATTRIBUTE=RESTART_ATTEMPTS,TYPE=int", \ "ATTRIBUTE=ACL,TYPE=string", \ "ATTRIBUTE=VERSION,TYPE=string"

3. Create the Oracle Solaris Cluster sun.resource resource of type sun.storage_proxy.type.

   The Oracle Grid Infrastructure resource name uses the form sun.sc-resource, where sc-resource is the name of the SUNW.ScalDeviceGroup or SUNW.ScalMountPoint resource.

   # Grid_home/bin/crsctl add resource sun.sc-resource \ -type sun.storage_proxy.type \ -attr "ACTION_SCRIPT='/opt/SUNWscor/dsconfig/bin/scproxy_crs_action' \ CARDINALITY='number-nodes' \ SCRIPT_TIMEOUT='20' \ PLACEMENT='restricted' \ RESTART_ATTEMPTS='60' \ HOSTING_MEMBERS='nodelist' \ VERSION='1' "

   CARDINALITY

   The number of nodes in the cluster membership

   HOSTING_MEMBERS

   The space-separated list of nodes in the cluster membership

4. Determine the DBA group of the Oracle Grid Infrastructure installation.

   # Grid_home/bin/osdbagrp
   griddba-group

5. Set the primary group of the Oracle Grid Infrastructure storage proxy resource to the group determined in Step 4.

   # Grid_home/bin/crsctl setperm resource sun.sc-resource -g "griddba-group"

6. Determine the DBA group of the Oracle Database Software installation.

   # oracle_home/bin/osdbagrp
   dba-group

7. Set the group permissions of the Oracle Grid Infrastructure storage proxy resource to the group determined in Step 6.

   Omit this step if the Oracle Grid Infrastructure installation DBA group griddba-group, determined in Step 4, and the Oracle Database Software installation DBA group dba-group, determined in Step 6, are the same DBA group.

   # Grid_home/bin/crsctl setperm resource sun.sc-resource -u "group:dba-group:r-x"

8. Bring online the Oracle Grid Infrastructure storage proxy resource.

   # Grid_home/bin/crsctl start resource sun.sc-resource

See Also

If you need to remove an Oracle Grid Infrastructure resource, perform procedures in Removing an Oracle Grid Infrastructure Resource.