Oracle^® Solaris Cluster Data Service for Oracle Database Guide

How to Register and Configure HA for Oracle Database With Oracle ASM (clsetup)

This procedure uses the clsetup configuration wizard for HA for Oracle Database, with Oracle ASM to manage data storage.

Before You Begin

Ensure that the following prerequisites are met:

• The volume manager of the cluster is configured to provide volumes on shared storage that are accessible from any Oracle Solaris Cluster node where Oracle Database could potentially run.

• Raw devices and file systems on the storage volumes that Oracle Database will use for its database are created.

• Oracle Database software is installed to be accessible from all nodes where Oracle Database could potentially run.

• Kernel variables for the UNIX operating system are configured for Oracle Database.

• Oracle Database software is configured for all nodes that could potentially run Oracle Database.

• The data service packages are installed.

• An entry for each logical hostname that is to be made available by the resource is added to the name service database.

• If you will use an Oracle Grid Infrastructure SCAN listener, the listener IP address will be on the same subnet as the logical hostname IP address you will use for the Oracle Database resource. Otherwise, the Oracle Database resource will not fail over if the public network fails.

• If you are using PNM objects, the objects are configured on the nodes where the logical hostname resource can be brought online. Public network management (PNM) objects include Internet Protocol network multipathing (IPMP) groups, trunk and datalink multipathing (DLMP) link aggregations, and VNICs that are directly backed by link aggregations.

• Any projects you created to run one or both of the following applications exist in the projects name service database for the user that runs that application:

  • Oracle Database

  • Oracle ASM

  If no custom project is created for an application, the default project is used. For more information, see the projects(1) man page.

Ensure that you have the following information:

• The names of the cluster nodes that master the data service.

• The path to the Oracle Database application binaries for the resources that you plan to configure.

• The database type.

1. Become superuser on any cluster node.
2. Start the clsetup utility.

   # clsetup

   The clsetup main menu is displayed.

3. Type the option number for data services.

   The Data Services menu is displayed.

4. Type the option number for configuring HA for Oracle Database.

   The clsetup utility displays the list of prerequisites for performing this task.

5. Verify that the prerequisites are met.

   The clsetup utility prompts you to select the Oracle Database location, either the global cluster or a zone cluster.

6. Type the option number for the Oracle Database location.

   Select the global cluster or a zone cluster. The clsetup utility displays a list of HA for Oracle Database components to configure.

7. Type the option number for the HA for Oracle Database component to configure.
   • To configure an Oracle ASM resource, select Oracle Automatic Storage management (ASM) Resources.
   • To use an existing Oracle ASM resource, select HA Oracle Database Instance Resources.

   The clsetup utility displays a list of the cluster nodes.

8. Select the nodes where you require Oracle ASM to run.

   Ensure that the nodes you select are listed in the order in which the nodes are to appear in the HA for Oracle Database framework resource group node list.

   • To accept the default selection of all listed nodes in an arbitrary order, type a.
   • To select a subset of the listed nodes, type a comma-separated or space-separated list of the option numbers for the nodes you choose.
   • To select all nodes in a particular order, type a comma-separated or space-separated ordered list of the option numbers for the nodes you choose.

   If needed to end the selection of nodes, type d. The clsetup utility displays a list of Oracle ASM instance resources.

9. Type the option number that corresponds to the Oracle ASM instance resource to use.

   If no Oracle ASM instance resource is available and you are prompted to create a resource, press Return. Skip to Step 11.

10. To confirm your selection of an Oracle ASM instance resource, type d.

    The clsetup utility displays the selection screen for the Oracle Grid Infrastructure home directory.

11. Type the option number to choose a listed directory or to specify a directory explicitly.

    The clsetup utility prompts you for the project to use.

12. Type the option number to choose a listed project.

    If you did not create a project where Oracle ASM will run, select the default project. The clsetup utility displays the list of Oracle ASM system identifiers (SID) that are discovered in the cluster.

13. Review the list of SIDs.
    • If the list is correct, type d.
    • If the list is not correct, type the option number for the SID to change.

    The clsetup utility displays information about Oracle ASM disk-group resources.

14. Respond to the prompt that asks whether to create a disk-group resource.
    • To create a new disk-group resource, type y.

      The clsetup utility displays a list of existing Oracle ASM disk groups. Proceed to Step 15.

    • If you do not want to create a new disk-group resource, type n.

      The clsetup utility displays a list of discovered storage resources. Skip to Step 17.

15. Specify the Oracle ASM disk groups.

    Type the option number for each disk group to use. When all disk groups are selected, type d.

    The selected Oracle ASM disk groups are added to the Oracle ASM disk-group resources selection panel.

16. Review the list of Oracle ASM disk-group resources.
    • If the list is correct, type d.
    • If the list is not correct, type the option number or letter to edit the list of resources.

      When the list of disk-group resources is correct, type d.

    The clsetup utility displays a list of discovered storage resources.

17. Review the list of storage resources to manage the file-system mount point where the Oracle Grid Infrastructure home is installed.
    • If the list is correct, type d.
    • If no storage resource is listed, type d.

      The clsetup utility will create a new resource when you complete Oracle ASM configuration.

    • If the list is not correct, type the option number for the correct storage resource.

    The clsetup utility displays a list of Oracle ASM disk-group resources that manage Oracle ASM disk groups.

18. If no suitable disk-group resources exist, or if no resource exists for an Oracle ASM disk group that you are using, add a resource to the list.
    1. Type y.

       The clsetup utility discovers Oracle ASM disk groups.

    2. Type a comma-separated or space-separated list of the option numbers for the Oracle ASM disk groups to use.
    3. To confirm your selection of disk groups, type d.

       The clsetup utility returns you to the list of Oracle ASM disk-group resources. The resource that you are creating is added to the list.

19. Type the option numbers for the resources that you require, if not already selected.

    You can select existing resources, resources that are not yet created, or a combination of existing resources and new resources. If you select more than one existing resource, the selected resources must be in the same resource group.

20. To confirm your selection of resources for Oracle ASM disk groups, type d.

    The clsetup utility displays a list of discovered underlying disk sets or disk groups.

21. Type a comma-separated list of the option numbers for the Oracle ASM disk groups to use.
22. To confirm your selection of Oracle ASM disk groups, type d.

    The clsetup utility displays the names of the Oracle Solaris Cluster objects for Oracle ASM that the utility will create or add to your configuration.

23. Select the nodes where you require Oracle Database to run.

    Ensure that the cluster nodes are listed in the order in which the nodes are to appear in the node list of the resource group in which the Oracle Database resource is to be placed.

    • To accept the default selection of all listed nodes in an arbitrary order, press Return.
    • To select a subset of the listed nodes, type a comma-separated or space-separated list of the numbers that correspond to the nodes. Then press Return.
    • To select all cluster nodes in a particular order, type a comma-separated or space-separated ordered list of the numbers that correspond to the nodes. Then press Return.

    If necessary to confirm your selection of cluster nodes, type d.

    The clsetup utility displays the types of Oracle Database components that you can configure.

24. Type the option number for the Oracle Database components to configure.

    You can select the server, the listener, or both.

    The clsetup utility lists the Oracle Database home directory.

25. Specify the Oracle Database home directory for your installation of the Oracle Database software.
    • If the directory is listed, select the directory as follows:
      1. Type the number that corresponds the directory that you are selecting.
    • If the directory is not listed, specify the directory explicitly.
      1. Type e.

         The clsetup utility prompts you for the Oracle Database home directory.

      2. Type the full path to the Oracle Database home directory.

    The clsetup utility prompts you for the project to use.

26. Type the option number to select a listed project.

    If you did not create a project where Oracle Database will run, choose the default project. The clsetup utility prompts you for the Oracle Database system identifier (SID) for your installation of Oracle Database.

27. Specify the Oracle Database SID of the Oracle database that you are configuring.
    • If the SID is listed, select the SID as follows:
      1. Type the number that corresponds the SID that you are selecting.

         The clsetup utility displays the properties of the Oracle Solaris Cluster resources that the utility will create.

    • If the SID is not listed, specify the SID explicitly.
      1. Type e.

         The clsetup utility prompts you for the SID.

      2. Type the SID.

         The clsetup utility displays the properties of the Oracle Solaris Cluster resources that the utility will create.

    The clsetup utility displays the properties of the Oracle Solaris Cluster resources that the utility will create.

28. If you require a different name for any Oracle Solaris Cluster resources property, change the value as follows.
    1. Type the number that corresponds to the name that you are changing.

       The clsetup utility displays a screen where you can specify the new name.

    2. At the New Value prompt, type the new name.

    The clsetup utility returns you to the list of the properties of the Oracle Solaris Cluster resource that the utility will create.

29. To confirm your selection of Oracle Solaris Cluster resource properties, type d.

    The clsetup utility returns you to the storage selection for Oracle Database.

30. Type the option number for Oracle ASM.

    The clsetup utility lists all configured highly available storage resources.

31. Select the storage resource to use.

    The clsetup utility displays a list of Oracle ASM instance resources.

32. To confirm your selection of Oracle Solaris Cluster storage resources, type d.

    The clsetup utility displays the list of available logical hostname resources.

    • If you need to create a new logical hostname resource, type c.

      Proceed to Step 33.

    • If the logical hostname resources you need already exist, skip to Step 35.
33. Create a new logical hostname resource.

    At the prompt, type the logical hostname to use.

    • If more than one PNM object is configured for the specified logical hostname, the clsetup utility provides a screen where you can specify the PNM objects to use.

      Proceed to Step 34.

    • If only one PNM object is configured for the specified logical hostname, the clsetup utility displays the names of the Oracle Solaris Cluster logical hostname resources for selection.

      Skip to Step 35.

34. Select from the list of available PNM objects one object for each cluster node.

    The clsetup utility displays the names of the Oracle Solaris Cluster logical hostname resources for selection.

35. Type a comma-separated or space-separated list of the numbers that correspond to the logical hostname resources that your data service requires.

    ---

    Note -  If you use a SCAN listener, specify a logical hostname whose IP address will be on the same subnet as the SCAN listener IP address.

    ---

    The clsetup utility displays the numbers of the logical hostname resources you selected.

36. To confirm your selection of Oracle Solaris Cluster logical hostname resources, type d.

    The clsetup utility displays the names of the Oracle Solaris Cluster objects that the utility will create.

37. If you require a different name for any Oracle Solaris Cluster objects, change each name as follows.
    • Type the number that corresponds to the name that you are changing.

      The clsetup utility displays a screen where you can specify the new name.

    • At the New Value prompt, type the new name.

      The clsetup utility returns you to the list of the names of the Oracle Solaris Cluster objects that the utility will create.

38. To confirm your selection of Oracle Solaris Cluster object names, type d.
39. To create the configuration, type c.

    The clsetup utility displays a progress message to indicate that the utility is running commands to create the configuration. When configuration is complete, the clsetup utility displays the commands that the utility ran to create the configuration.

40. Press Return to continue.
41. (Optional) Type q and press Return repeatedly until you quit the clsetup utility.

    If you prefer, you can leave the clsetup utility running while you perform other required tasks before using the utility again.