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. Assume the root role on any cluster node.
2. Start the clsetup utility, verify prerequisites, and navigate to the HA for Oracle Database configuration section.

   # clsetup

   When using the clsetup utility, press the Return key to submit your choices.

3. Choose 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.

4. Choose 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.

5. Follow the prompts in the clsetup utility to provide the following information.

   Data to Provide Guidelines Your Values Cluster nodes on which to run Oracle ASM 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 choose nodes, type a comma-separated or space-separated list of the option numbers for the nodes to use. Oracle ASM instance resource to use If no Oracle ASM instance resources are available, the clsetup utility prompts you to create a resource. Oracle Grid Infrastructure home directory Supply the full path to the home directory. Project where Oracle ASM is to run If you did not create a project where Oracle ASM will run, select the default project. Oracle ASM SIDs If the list of Oracle ASM system identifiers (SIDs) that are discovered in the cluster is not correct, you can change the SIDs. Oracle ASM disk-group resources Choose whether to create a disk-group resource or to use an existing disk-group resource. Oracle ASM disk groups to use as storage resources Cluster nodes on which Oracle Database is to run Ensure that the cluster nodes are listed in the order in which they are to appear in the node list of the resource group in which the Oracle Database resource is to be placed. To choose nodes, type a comma-separated or space-separated list of the option numbers for the nodes to use. Oracle Database components to configure Choose whether to configure the Oracle Database server component, listener component, or both components. Database home directory If the directory does not yet exist, provide the full path to where you want it to be and clsetup will create it. Project where Oracle Database is to run If you did not create a project where Oracle Database will run, choose the default project. Oracle Database SID Oracle Database system identifiers (SID) that are discovered in the cluster. If the SID does not yet exist, clsetup will create it. Changed names for any cluster resources properties Depending on your environment, you might not need to change any resource property names. Highly-available HAStoragePlus storage resources Logical-hostname resources If you need to create a new logical hostname resource, know which PNM object you want to use for each cluster node. 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. To select multiple resources, type a comma-separated or space-separated list of the numbers.

6. Confirm the objects name.
   1. If you require a different name for any Oracle Solaris Cluster objects, choose the name to change and type the new name in response to the prompt.

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

   2. To confirm your selection of Oracle Solaris Cluster object names, type d.
7. 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 used to create the configuration.

   When the configuration process completes, press Return repeatedly to exit from the clsetup utility. If you prefer, you can leave the clsetup utility running while you perform other required tasks before using the utility again.