Cluster Server 7.4.2 Database Agent for Oracle Configuration Guide - Windows

To create an Oracle service group

1. Start the Oracle configuration wizard.

   In case of VCS, launch the Oracle Configuration Wizard from the Apps menu on the Start screen.

   In case of SFW HA, open the Solutions Configuration Center from the Apps menu. In the SCC, click the Solutions tab, expand High Availability Configuration Wizards, and click the Launch button for the Oracle Agent Configuration Wizard.

2. On the Welcome panel click Next.
3. On the Wizard Options panel, select Create service group and click Next.
4. On the Service Group Configuration panel, use the following fields as appropriate:

   Service Group Name	Type a name for the Oracle service group.
   Group System List	In the Available Cluster Systems list, select the systems on which to configure the service group and click the right arrow to move the systems to the Systems in Priority Order list. The Systems in Priority Order box represents the service group's system list. The system at the top of the list has the highest priority while the system at the bottom of the list has the lowest priority. To remove a system from the service group's system list, select a system in the Systems in Priority Order box and click the left arrow. To change a system's priority in the service group's system list, select the system from the Systems in Priority Order box, and click the up and down arrows.
   Include selected systems in the service group's AutoStartList attribute	To enable the service group to automatically come online on one of the systems, select this checkbox. For information about the AutoStartList attribute, see the Cluster Server Administrator's Guide.

   Click Next. The wizard starts validating your configuration. Various messages indicate the validation status.

5. On the Oracle Configuration panel, complete the following and then click Next.

   • Select the SIDs and the associated listeners to be added to the service group. The SID is a system identifier that uniquely identifies the Oracle database instance, while the listener is the name of the corresponding listener service.

6. On the Detail Monitoring panel, configure detail monitoring for the Oracle database if required, and click Next.

   Enter the appropriate information in the following fields:

   Detail Monitor	Check the Detail Monitor option corresponding to each database that you want to configure detail monitoring for.
   SQL Path	Type the path of the SQL file that will query the database to validate the status. Click the icon next to the field to browse for the SQL file. A sample SQL file, check.sql, is located at %vcs_home%\bin\Oracle\. Here, %vcs_home% is the installation directory, typically C:\Program Files\Veritas\Cluster Server.

7. In the Domain and User selection panel, type a valid domain name, user name, and password with which the database service was configured for the database and click Next.

8. On the Network Configuration panel, specify the network related information and click Next.

   The wizard discovers and displays the virtual IP address for the Oracle Server.

   Do the following:

   • In case of IPv4, select IPV4 and then enter the IP address and associated subnet mask. Make sure that the specified IP address has a DNS entry.

   • In case of IPv6, select IPV6 and select the IPv6 network from the drop-down list.

     The wizard uses the network prefix and automatically generates a unique IPv6 address that is valid on the network.

     The IPv6 option is disabled if the network does not support IPv6.

   • For each system in the cluster, select the public network adapter name. The Adapter Display Name field displays the TCP/IP enabled adapters on a system, including the private network adapters, if applicable. To view the adapters associated with a system, click the Adapter Display Name field and click the arrow. Verify that you select the adapters assigned to the public network, not the private.

   Note:

   If you have a tagged VLAN network configuration having multiple logical network interfaces or a teamed network interface that have the same MAC address, then you must edit the "MACAddress" attribute of the NIC agent and the IP agent, after you configure the application service group.

   See About the modifications required for tagged VLAN or teamed network.

9. Review the configuration on the Summary panel.

   Resources	Lists the configured resources. The wizard assigns unique names to the resources. Click on a resource to view its attributes and their configured values in the Attributes box.
   Attributes	Enables you to edit a resource name. Click the resource name or press the F2 key. After editing, press the Esc key to cancel the changes, or press the Enter key to confirm the changes.

   Click Next.

10. On the confirmation dialog box, click Yes. Click No if you wish to review your settings.

    The wizard starts running commands to create the Oracle service group.

11. On the Completing the Oracle Configuration panel, check Bring the service group online to bring the service group online on the local system, and click Finish. The Oracle service group is created in your cluster.