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

This procedure uses the clsetup configuration wizard for HA for Oracle Database.

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.

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 number that corresponds to the option for data services and press Return.

   The Data Services menu is displayed.

4. Type the number that corresponds to the option for configuring HA for Oracle Database and press Return.

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

5. Verify that the prerequisites are met, and press Return.

   The clsetup utility displays a list of the cluster nodes.

6. Select the nodes where you require Oracle Database to run.
   • 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.

     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 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 and press Return.

     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.

7. To confirm your selection of cluster nodes, type d and press Return.

   The clsetup utility displays the types of Oracle Database components that are to be configured.

8. Type the numbers of the Oracle Database components you want to configure and press Return.

   The clsetup utility lists the Oracle Database home directory.

9. 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.

        The clsetup utility displays a list of Oracle Database system identifiers that are configured on the cluster. The utility also prompts you to specify the system identifier for your installation of Oracle Database.

   • If the directory is not listed, specify the directory explicitly.
     1. Type e and press Return.

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

     2. Type the full path to the Oracle Database home directory and press Return.

        The clsetup utility displays a list of Oracle Database system identifiers that are configured on the cluster. The utility also prompts you to specify the system identifier for your installation of Oracle Database.

10. 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 and press Return.

         The clsetup utility prompts you for the SID.

      2. Type the SID and press Return.

         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.

11. If you require a different name for any Oracle Solaris Cluster resources properties, change each value as follows.
    1. Type the number that corresponds to the name that you are changing and press Return.

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

    2. At the New Value prompt, type the new name and press Return.

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

12. To confirm your selection of Oracle Solaris Cluster resource properties, type d and press Return.

    The clsetup utility displays a list of existing storage resources. If no storage resources are available, the clsetup utility displays a list of shared storage types where data is to be stored.

13. Type the numbers that correspond to type of shared storage that you are using for storing the data and press Return.

    The clsetup utility displays the file-system mount points that are configured in the cluster.

14. Select the file system mount points as follows.
    • To accept the default selection of all listed file-system mount points in an arbitrary order, type a. Then press Return.
    • To select a subset of the listed file system mount points, type a comma-separated or space-separated list of the numbers that correspond to the file-system mount points. Then press Return.

    The clsetup utility displays the global disk sets and device groups that are configured in the cluster.

15. Select the device groups as follows.
    • To accept the default selection of all listed device groups in an arbitrary order, type a and press Return.
    • To select a subset of the listed device groups, type a comma-separated or space-separated list of the numbers that correspond to the device groups and press Return.

    The clsetup utility returns to you the list of highly available storage resources.

16. Type a comma-separated or space-separated list of the numbers that correspond to the storage resources that your data service requires, and press Return.
17. To confirm your selection of Oracle Solaris Cluster storage resources, type d and press Return.

    The clsetup utility displays all the existing logical hostname resources in the cluster. If there are no logical hostname resources available, the clsetup utility prompts for the logical hostname that the resource will make highly available.

18. Specify the logical hostname and press Return.

    The clsetup utility returns to you the list of available logical hostname resources.

19. Type a comma-separated or space-separated list of the numbers that correspond to the logical hostname resources that your data service requires, and press Return.
20. To confirm your selection of Oracle Solaris Cluster logical hostname resources, type d and press Return.

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

21. 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 and press Return.

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

    • At the New Value prompt, type the new name and press Return.

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

22. To confirm your selection of Oracle Solaris Cluster object names, type d and press Return.
23. To create the configuration, type c and Press Return.

    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.

24. Press Return to continue.
25. (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.