How to configure VCS service groups for Oracle RAC

This section describes how to configure the Oracle service group using the CLI.

The following procedure assumes that you have created the database.

To configure the Oracle service group using the CLI

Change the cluster configuration to read-write mode:

# haconf -makerw

Add the service group to the VCS configuration:

# hagrp -add oradb1_grp

Modify the attributes of the service group:

# hagrp -modify oradb1_grp Parallel 1
# hagrp -modify oradb1_grp SystemList galaxy 0  nebula 1
# hagrp -modify oradb1_grp AutoStartList galaxy nebula

Add the CVMVolDg resource for the service group:

# hares -add oradata_voldg CVMVolDg oradb1_grp

Modify the attributes of the CVMVolDg resource for the service group:

# hares -modify oradata_voldg CVMDiskGroup oradatadg
# hares -modify oradata_voldg CVMActivation sw
# hares -modify oradata_voldg CVMVolume oradatavol

Add the CFSMount resource for the service group:

# hares -add oradata_mnt CFSMount oradb1_grp

Modify the attributes of the CFSMount resource for the service group:

# hares -modify oradata_mnt MountPoint "/oradata"
# hares -modify oradata_mnt BlockDevice \
"/dev/vx/dsk/oradatadg/oradatavol"

Add the Oracle RAC database instance to the service group:

# hares -add ora1 Oracle oradb1_grp

Modify the attributes of the Oracle resource for the service group:

# hares -modify ora1 Owner oracle
# hares -modify ora1 Home "/app/oracle/orahome"
# hares -modify ora1 StartUpOpt SRVCTLSTART
# hares -modify ora1 ShutDownOpt SRVCTLSTOP

Localize the Sid attribute for the Oracle resource:

# hares -local ora1 Sid

Set the Sid attributes for the Oracle resource on each system:

# hares -modify ora1 Sid vrts1 -sys galaxy
# hares -modify ora1 Sid vrts2 -sys nebula

Set the dependencies between the CFSMount resource and the CVMVolDg resource for the Oracle service group:

# hares -link oradata_mnt oradata_voldg

Set the dependencies between the Oracle resource and the CFSMount resource for the Oracle service group:

# hares -link ora1 oradata_mnt

Create an online local firm dependency between the oradb1_grp service group and the cvm service group:

# hagrp -link oradb1_grp cvm online local firm

Enable the Oracle service group:

# hagrp -enableresources oradb1_grp

Change the cluster configuration to the read-only mode:

# haconf -dump -makero

Bring the Oracle service group online on all the nodes:

# hagrp -online oradb1_grp -any