Sample Configurations with SGeRAC and Oracle RAC 10gR2, March 2009

Configuring Oracle RAC 10g on CFS

The following sections describe the process for configuring Oracle RAC 10g on CFS.

Assumptions for this sample configuration

1. Cluster hardware configured

2. HP-UX 11i v2 0505 Enterprise Operating Environment

3. HP Serviceguard Storage Management Suite (A.01.00 or later) Installed

4. Same private interconnect used for all inter-node traffic (Serviceguard, RAC, CSS, GAB/LLT)

5. One shared disk for CFS

6. Two private disks (one disk per node for local file system for local Oracle storage)

CFS and ODM requirement

ODM is required when using Oracle RAC with CFS and SGeRAC.

Creating a SGeRAC cluster with CFS for Oracle 10g

In this sample, both the Oracle RAC software and datafiles reside on CFS. There is a single Oracle

home. Three CFS files systems are created for Oracle home, Oracle datafiles, and for the Oracle

Cluster Registry (OCR) and vote device. The Oracle Cluster Software home is on local file system.

/cfs/mnt1 – for Oracle Base and Home

/cfs/mnt2 – for Oracle datafiles

/cfs/mnt3 – for OCR and Vote device.

Initializing the VERITAS Volume Manager

If have not already done so, install VxVM license key on all nodes.

# vxinstall

Create Cluster ASCII file

# cd /etc/cmcluster

# cmquerycl –C clm.asc –n mo –n minie

Edit the cluster ASCII file. A two node configuration requires either a Serviceguard quorum server or

cluster lock device. In this sample, since there is no SLVM volume group to be used for a cluster lock

device, a quorum server is used.

CLUSTER_NAME cluster_mo

QS_HOST white

QS_POLLING_INTERVAL 120000000

QS_TIMEOUT_EXTENSION 2000000

NODE_NAME minie

NETWORK_INTERFACE lan0

STATIONARY_IP 15.13.170.82

NETWORK_INTERFACE lan3

NETWORK_INTERFACE lan1

HEARTBEAT_IP 192.1.1.3

NETWORK_INTERFACE lan2

NODE_NAME mo

NETWORK_INTERFACE lan0

STATIONARY_IP 15.13.171.137

NETWORK_INTERFACE lan3

NETWORK_INTERFACE lan1

HEARTBEAT_IP 192.1.1.4