< Previous  | TOC | Index | Next  >

Adding Oracle resource groups in the main.cf file

For a complete description of the VCS Oracle enterprise agent, refer to the document, Veritas High Availability Agent for Oracle Installation and Configuration Guide. That document includes instructions for configuring the Oracle and Netlsnr agents.

The VCS Enterprise Agent for Oracle version 5.0 is installed when you run installsfrac. When you refer to the Veritas High Availability Agent for Oracle Installation and Configuration Guide, ignore the steps described in the section "Installing the Agent Software."

 To add Oracle resource groups in the main.cf file

1. Using the Oracle9i configuration as an example, add a service group to contain the resources for an Oracle database. For example, add the group oradb1_grp. Make sure you assign the Parallel attribute a value of 1.

   .

group oradb1_grp (

SystemList = { galaxy = 0, nebula = 1 }

AutoFailOver = 0

Parallel = 1

AutoStartList = { galaxy, nebula }

)

2. Create the CVMVolDg and CFSMount resource definitions. See Agent reference for a description of these agents and their attributes.

   .

   .

CVMVolDg oradata_voldg (

CVMDiskGroup = oradatadg

CVMVolume = { oradatavol }

CVMActivation = sw

)

CFSMount oradata_mnt (

Critical = 0

MountPoint = "/oradata"

BlockDevice = "/dev/vx/dsk/oradatadg/oradatavol"

)

.

.

3. Define the Oracle database resource. Refer to the Veritas High Availability Agent for Oracle Installation and Configuration Guide for information on the VCS enterprise agent for Oracle.

   ---

     Note   Oracle attributes Sid and Pfile must be set locally, that is, they must be defined for each cluster system.

   ---

   .

Oracle ora1 (

Critical = 0

Sid @galaxy = vrts1

Sid @nebula = vrts2

Owner = oracle

Home = "/app/oracle/orahome"

Pfile @galaxy = "/app/oracle/orahome/dbs/initvrts1.ora "

Pfile @nebula = "/app/oracle/orahome/dbs/initvrts2.ora"

)

.

4. Define the dependencies for the Oracle service group. Note that the Oracle database group is specified to require the cvm group, and that the required dependency is defined as "online local firm," meaning that the cvm group must be online and remain online on a system before the Oracle group can come online on the same system. Refer to the Veritas Cluster Server User's Guide for a description of group dependencies.

   Refer to VCS service groups for RAC: dependencies.

   .

   .

requires group cvm online local firm

ora1 requires oradata_mnt

oradata_mnt requires oradata_voldg

.

.

See the Sample VCS configuration files for SF Oracle RAC for a complete example. You can also find the complete file in /etc/VRTSvcs/conf/sample_rac/main.cf.

Additional RAC Processes Monitored by the VCS Oracle Agent

For shallow monitoring, the VCS Oracle agent monitors the ora_lmon and ora_lmd processes in addition to the ora_dbw, ora_smon, ora_pmon, and ora_lgwr processes.