Configuring the service groups using the wizard
You can use a configuration wizard to configure the VCS service groups for SF Oracle RAC environment. The wizard enables you to create the service group for Oracle and modify the CVM service group.
The Oracle9i RAC configuration wizard guides you through the creation of an Oracle service group and the definition of the Oracle, CFSMount, and CVMVolDg resources. It adds the Netlsnr resources to the existing CVM group. If the listeners use the virtual IP, the wizard also adds the IP and NIC resources to the CVM group.
The wizard configures the Oracle service group to depend on CVM group with an online-local-firm dependency.
Verifying configuration requirements
Before starting the Wizard, you can verify that your Oracle installation can be configured. Review the requirements listed below. Also, you need to provide the wizard information as it proceeds. Make sure you have that information at hand.
Prerequisites
-
Oracle RAC instances and listeners must be running on all cluster nodes.
-
The database files of all instances must be on a cluster file system.
Note
The Wizard does not support using the same file system for the Oracle binary and Oracle datafiles.
-
The SRVM location must be on a raw volume or a cluster file system.
-
Each Oracle instance must be associated with a listener. The listener may be configured to listen to either the base IP or a virtual IP.
Note
The RAC configuration wizard requires that for the default listener, the listener parameter file, listener.ora, must reside in $ORACLE_HOME/network/admin. No such restriction applies for non-default listeners.
-
The IP addresses and host names specified in the files listener.ora and tnsnames.ora must be the same.
-
If detail monitoring is to be used for a database instance, the table used for detail monitoring must be set up, with user and password assigned.
Required information
-
The names of the database instances to be configured
-
The information to required for the detail monitoring configuration
-
The location of the Pfile for each instance
Establishing graphical access for the wizard
The configuration wizard requires graphical access to the VCS systems where you want to configure service groups. If your VCS systems do not have monitors, or if you want to run the wizards from a remote HP system, do the following:
To establish graphical access from a remote system
-
From the remote system, (
jupiter
, for example), run xhost
+
# xhost +
-
Complete one of the following operations (depending on your shell):
-
Verify the DISPLAY environment variable is updated:
# echo $DISPLAY
jupiter:0.0
-
Make sure to set the JRE_HOME variable to
/opt/VRTSjre/jre1.4
. If VRTSjre1.4 is not installed, the hawizard exits after displaying an error message.
Creating service groups using the configuration wizard
Start the configuration wizard for Oracle 9i RAC at the command-line.
To create service groups using the configuration wizard
-
Log on to one of your VCS systems as superuser.
-
Start the configuration wizard.
# /opt/VRTSvcs/bin/hawizard rac
-
Read the information on the Welcome screen.
-
If your configuration does not meet the requirements, click Cancel to stop the wizard. Start the wizard again after taking the necessary steps to meet the requirements.
-
If your configuration meets the requirements, click Next. The wizard begins discovering the current Oracle RAC information before proceeding.
If the wizard does not find all databases and listeners running on all nodes in the cluster, it halts with an error, indicating the problem. Click Cancel, and start the wizard again after you correct the problem.
-
In the Wizard Options dialog box, select the Create RAC Service Group option.
-
Enter a name for the RAC service group in the Service group name box and click Next.
-
In the Database Selection dialog box, select a database and click Next.
-
In the Instance Configuration dialog box, specify information for all instances of the database you selected.
Click the thumbnail above to view full-sized image.
Specify the following information for each Oracle instance that is displayed and click Next:
Oracle Parameter File (Pfile)
|
Verify the location of the Oracle Parameter File.
Edit the information if necessary.
|
Start Options
|
Choose the Start options, if desired. Default is STARTUP_FORCE.
|
Stop Options
|
Choose the Stop options, if desired. Default is IMMEDIATE.
|
Configure detail monitoring
|
Select the check box if you want to monitor the database in detail.
If you want to enable Detail Monitoring, be sure you have previously set up the database table, user, and password for the agent to use during monitoring.
|
Specify Advanced Options
|
Select the check box to enter advanced configuration information for the database instances.
|
-
If you chose to monitor the database in detail, the Detail Monitoring dialog box is displayed.
Click the thumbnail above to view full-sized image.
Specify the following information for the database instances that you want the agent to monitor in detail and click Next:
Select
|
Select the check box corresponding to the database to be monitored in detail.
|
User
|
Enter a valid user name for the database that the Oracle agent uses to log in to monitor the health of the database.
|
Password
|
Enter a valid password for the database user.
Note
Do not encrypt passwords when entering them through the Agent Configuration Wizard; the wizard takes care of encrypting passwords.
|
Table
|
Enter the name of a table that will be queried to validate the status of the database.
|
-
If you chose to specify advanced options, the Oracle Advanced Configuration dialog box is displayed.
Click the thumbnail above to view full-sized image.
Specify the following information for the Oracle instances that you want to configure advanced attributes and click Next:
Oracle EnvFile
|
Enter the location of the Oracle Envfile, the source file used by the agent entry point scripts.
|
Oracle Encoding
|
Enter the operating system encoding that corresponds to Oracle encoding for the displayed Oracle output.
The encoding value must match the encoding value used by the Netlsnr configuration.
|
AutoEndBkup
|
Select the check box, if desired.
Specifies that data files in the database are taken out of the backup mode when instance is brought online.
|
Refer to the Veritas High Availability Agent for Oracle Installation and Configuration Guide for a complete description of these attributes.
-
In the Monitor option Configuration dialog box, specify the monitor option for the Oracle instances, and click Next.
The default monitor option is Process check.
-
In the Database Configuration dialog box, verify the mount point of the database that the wizard displays. Confirm or modify the mount options displayed and click Next.
Note that the wizard discovers the mount point if the database is installed on a cluster file system. If the database exists on raw volumes, the wizard discovers the volumes.
Click the thumbnail above to view full-sized image.
-
In the Listener Configuration dialog box, verify the name of the listener corresponding to each database instance.
Click the thumbnail above to view full-sized image.
Specify the following information for the listeners and click Next:
Address
|
Verify the virtual IP address.
|
Device
|
For each system, select a device.
|
Enable detail monitoring
|
Select the check box to enable detail monitoring.
The wizard uses the monitor script /opt/VRTSvcs/bin/Netlsnr/LsnrTest.p1 to monitor the listeners in detail.
|
Specify Advanced Options
|
Select the check box to enter advanced configuration information for the listeners.
|
-
If you have set up the listener to use the base or host IP address, review the warning that the wizard will not configure IP and NIC resources in the service group. Click Yes if you want to proceed.
-
If you chose to specify advanced options for the listeners, the Listener Advanced Configuration dialog box is displayed.
Click the thumbnail above to view full-sized image.
Specify the following information for each listener and click Next:
Netlsnr EnvFile
|
Enter the path of the listener Envfile.
Envfile is the name of the source file used by the agent entry point scripts; this file must exist.
|
Netlsnr Encoding
|
Enter the operating system encoding that corresponds to Oracle encoding for the displayed Oracle output; the encoding value must match the encoding value used by the Oracle configuration.
|
Listener Password
|
Enter a valid password for the listener.
Specify the password as it appears in the listener.ora file.
Note
Do not encrypt passwords when entering them through the agent configuration wizard; the wizard takes care of encrypting passwords.
|
-
In the Service Group Summary dialog, review your configuration.
Click on a resource to view its attributes and their configured values in the Attributes box.
Click the thumbnail above to view full-sized image.
-
Click a resource within the service group to display its attributes and their values.
For example, if you click the name of the Oracle resource, Ora-rac, the wizard displays details of the Oracle resource.
Attributes for the CFSMount resource show dependencies.
The NetLsnr resource is configured as part of the CVM service group. The CVM service group also contains other resources, which may not be displayed by the wizard because the wizard does not control them.
-
Change names of resources, if desired; the wizard assigns unique names to resources based on their respective name rules.
To edit a resource name, select the resource name and click on it, press Enter after editing each attribute.
-
Review your configuration and click Finish.
The wizard starts running commands to create the Oracle RAC service group. Various messages indicate the status of these commands.
-
In the Completing the Oracle Configuration wizard dialog box, select the Bring the service group online check box to bring the service group online on the local system.
-
Click Close.
The wizard creates the Oracle RAC service group in your cluster and adds the Netlsnr resource to the CVM configuration.
Modifying Oracle RAC service groups using the wizard
After you create an Oracle RAC service group on a system, you can use the configuration wizard to modify the service group's Oracle, Netlsnr, and CVM components.
Note
If modification of underlying mount point or volume information is necessary, the mount points or volumes must be deleted and added in the Oracle database before the wizard is started. Then, the wizard discovers the new information.
Prerequisites
-
To modify some resources, you must make the changes in the Oracle database before you start the RAC configuration wizard. When you start the wizard, it discovers the the new information. This applies to:
-
Adding or removing the database mount points
-
Adding or removing shared volumes
-
To modify network resources, make sure that the service group is offline.
-
To add or remove database files from your configuration, make sure that the service group is online.
To modify the Oracle9i RAC service group configuration
-
Start the RAC configuration wizard as superuser on the VCS system.
# /opt/VRTSvcs/bin/hawizard rac
-
In the Welcome window, click Next.
-
In the Wizard Options window, select the Modify RAC service group option, select the service group to be modified, and click Next.
-
Follow the wizard instructions and make modifications as per your configuration.
See Configuring the service groups using the wizard