Oracle^® Solaris Cluster Data Service for Oracle Database Guide

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

This procedure uses the clsetup configuration wizard for HA for Oracle Database, with HAStoragePlus 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 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 project you created to run Oracle Database exists in the projects name service database for the user that runs that application. 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.

• The logical hostnames that you plan to add to the resource group.

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 HA Oracle Database Instance Resources.

   The clsetup utility displays a list of the cluster nodes.

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

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

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

11. Type the option number to choose 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).

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

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

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

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

15. Type the number that corresponds to HAStoragePlus.

    The clsetup utility lists all configured highly available storage resources.

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

      The clsetup utility lists the types of shared storage that you can configure. Proceed to Step 16.

    • If the storage resource you need already exists, skip to Step 18.
16. Type the option number that corresponds to the type of shared storage that you want to create.
    • If you select Shared File System, the clsetup utility displays the file-system mount points that are configured in the cluster.

      Proceed to Step 17.

    • If you select a storage type other than Shared File System, skip to Step 18.
17. Select the file system mount points.
    • To accept the default selection of all listed file-system mount points in an arbitrary order, type a.
    • 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.
    • If no file-system mount points exist, follow the prompts to specify one manually.

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

18. Select the device groups.
    • To accept the default selection of all listed device groups in an arbitrary order, type a.
    • 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.
    • If no device groups exist, follow the prompts to specify one manually.

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

19. Type a comma-separated or space-separated list of the numbers that correspond to the storage resources that your data service requires,.

    The clsetup utility displays the selected storage resources.

20. 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 21.

    • If the logical hostname resources you need already exist, skip to Step 23.
21. 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 22.

    • If only one PNM object is configured for the specified logical hostname, the clsetup utility lists the names of the Oracle Solaris Cluster logical hostname resources that the utility will create.

      Skip to Step 23.

22. 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 that the utility will create.

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

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

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

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

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

26. To confirm your selection of Oracle Solaris Cluster object names, type d.
27. 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.

28. Press Return to continue.
29. (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.