How to Register and Configure Sun Cluster HA for Oracle with Single Instance ASM Using Sun Cluster Maintenance Commands

This procedure explains the steps to register and configure single instance ASM using Sun Cluster maintenance commands where Oracle_Home for ASM is on a local file system.

ASM disk group and Oracle database can be configured in different resource groups. If the ASM disk group and Oracle database are configured in different resource groups, you should set a strong positive affinity(+++) between the ASM disk group resource group and Oracle database resource group.

1. On a cluster member, become superuser or assume a role that provides solaris.cluster.modify and solaris.cluster.admin RBAC authorizations.

2. Register the ASM resource types for the data service.

   # clresourcetype register SUNW.scalable_asm_instance # clresourcetype register SUNW.asm_diskgroup

3. Create a scalable resource group asm-inst-rg for the ASM instance.

   # clresourcegroup create -S asm-inst-rg

   -S asm-inst-rg

   Specifies the name of the scalable resource group for the ASM instance.

4. Add a logical hostname resource to the asm-dg-rg resource group.

   # clreslogicalhostname create -g asm-dg-rg [-h logicalhostname] \ logicalhotname-rs

   -h logicalhostname

   Specifies a logical hostname. This logical hostname must present in your name service database. If logicalhostname and logicalhostname-rs are identical, logicalhostname is optional.

   logicalhostname-rs

   Specifies the name that you are assigning to the logical hostname resource that you are creating.

5. Add a resource of type SUNW.scalable_asm_instance to the asm-inst-rg resource group.

   # clresource create -g asm-inst-rg -t SUNW.scalable_asm_instance -p ORACLE_HOME=oracle-home \ -d asm-inst-rs

   -g asm-inst-rg

   Specifies the name of the resource group for the ASM instance.

   -p ORACLE_HOME=oracle-home

   Sets the path to the Oracle home directory.

   -d asm-inst-rs

   Specifies the name of the ASM instance resource that you are creating.

6. Bring online the scalable resource group in a managed state on a cluster node.

   # clresourcegroup online -eM asm-inst-rg

7. Create an ASM disk resource group asm-dg–rg.

   # clresourcegroup create asm-dg-rg

8. Set a strong positive affinity on ASM disk group by the resource group asm-dg-rg.

   # clresourcegroup set -p rg_affinities=++asm-inst-rg asm-dg-rg

9. Add a resource of type SUNW.asm_diskgroup to the asm-dg-rg resource group.

   # clresource create -g asm-dg-rg -t SUNW.asm_diskgroup -p asm_diskgroups=dg \ -p resource_dependencies_offline_restart=asm-inst-rs -d asm-dg-rs

10. Bring online the ASM disk resource group in a managed state.

    # clresource online -eM asm-dg-rg

11. Verify the Oracle ASM installation by issuing the status command.

    # clresource status +

12. Register the resource types for the Sun Cluster HA for Oracle data service.

    For Sun Cluster HA for Oracle, you register the resource types SUNW.oracle_server and SUNW.oracle_listener as follows.

    # clresourcetype register SUNW.oracle_server # clresourcetype register SUNW.oracle_listener

13. Create Oracle application resources in the failover resource group.

    • Oracle server resource:

      # clresource create -g asm-dg-rg \ -t SUNW.oracle_server \ -p Connect_string=user/passwd \ -p ORACLE_SID=instance \ -p ORACLE_HOME=Oracle-home \ -p Alert_log_file=path-to-log \ -p Restart_type=entity-to-restart \ -p Resource_dependencies_offline_restart=asm-dg-rs \ -d ora-db-rs

    • Oracle listener resource:

      # clresource create -g asm-dg-rg \ -t SUNW.oracle_listener \ -p LISTENER_NAME=listener \ -p ORACLE_HOME=Oracle-home \ -p resource_dependencies_offline_restart=asm-dg-rs logicalhostname-rs \ -d ora-lsr-rs

    -g asm-dg-rg

    Specifies the name of the ASM disk resource group into which the resources are to be placed.

    -t SUNW.oracle_server/listener

    Specifies the type of the resource to add.

    -p Alert_log_file=path-to-log

    Sets the path under $ORACLE_HOME for the server message log.

    -p Connect_string=user/passwd

    Specifies the user and password that the fault monitor uses to connect to the database. These settings must agree with the permissions that you set up in How to Set Up Oracle Database Permissions. If you use Solaris authorization, type a slash (/) instead of the user name and password.

    -p ORACLE_SID=instance

    Sets the Oracle system identifier.

    -p LISTENER_NAME=listener

    Sets the name of the Oracle listener instance. This name must match the corresponding entry in listener.ora.

    -p ORACLE_HOME=Oracle-home

    Sets the path to the Oracle home directory.

    ---

    Note –

    Optionally, you can set additional extension properties that belong to the Oracle data service to override their default values. See Setting Sun Cluster HA for Oracle Extension Properties for a list of extension properties.

    ---

14. Bring online the Oracle server resource.

    # clresource enable ora-db-rs

15. Bring online the Oracle listener resource.

    # clresource enable ora-lsr-rs