Using Serviceguard Extension for RAC, 9th Edition, September 2010
3 Serviceguard Configuration for Oracle 9i RAC
This chapter shows the additional planning and configuration that is needed to use Oracle Real
Application Clusters 9i with Serviceguard. The following topics are presented:
• “Planning Database Storage”
• “Installing Serviceguard Extension for RAC ”
• “Creating a Storage Infrastructure with LVM”
• “Installing Oracle Real Application Clusters”
• “Creating a Storage Infrastructure with CFS”
• “Creating a Storage Infrastructure with CVM”
• “Configuring Packages that Access the Oracle RAC Database”
• “Using Packages to Configure Startup and Shutdown of RAC Instances”
Planning Database Storage
The files needed by the Oracle database must be placed on shared storage that is accessible to
all RAC cluster nodes. This section shows how to plan the storage using SLVM, Veritas CFS, or
Veritas CVM.
Volume Planning with SLVM
Storage capacity for the Oracle database must be provided in the form of logical volumes located
in shared volume groups. The Oracle software requires at least two log files (and one undo
tablespace for Oracle 9) for each Oracle instance, several Oracle control files, and data files for
the database itself. For all these files, Serviceguard Extension for RAC uses HP-UX raw logical
volumes that are located in volume groups shared between the nodes in the cluster. High
availability is achieved by using high-availability disk arrays in RAID modes. The logical units
of storage on the arrays are accessed from each node through multiple physical volume links
(PV links, also known as alternate links) that provide redundant paths to each unit of storage.
Fill out a Logical Volume worksheet to provide logical volume names for logical volumes that
you will create with the lvcreate command. The Oracle DBA and the HP-UX system
administrator should prepare this worksheet together. Create entries for shared volumes only.
For each logical volume, enter the full pathname of the raw logical volume device file. Be sure
to include the desired size in MB. Following is a sample worksheet filled out. However, this
sample is only representative. For different versions of the Oracle database, the size of files are
different. Refer to Appendix B: “Blank Planning Worksheets”, for samples of blank worksheets.
Make as many copies as you need. Fill out the worksheet and keep it for future reference.
ORACLE LOGICAL VOLUME WORKSHEET FOR LVM Page ___ of ____
===============================================================================
RAW LOGICAL VOLUME NAME SIZE (MB)
Oracle Control File 1:_____/dev/vg_ops/ropsctl1.ctl_______108______
Oracle Control File 2: ___/dev/vg_ops/ropsctl2.ctl______108______
Oracle Control File 3: ___/dev/vg_ops/ropsctl3.ctl______104______
Instance 1 Redo Log 1: ___/dev/vg_ops/rops1log1.log_____20______
Instance 1 Redo Log 2: ___/dev/vg_ops/rops1log2.log_____20_______
Instance 1 Redo Log 3: ___/dev/vg_ops/rops1log3.log_____20_______
Instance 1 Redo Log: __________________________________________________
Instance 1 Redo Log: __________________________________________________
Instance 2 Redo Log 1: ___/dev/vg_ops/rops2log1.log____20________
Instance 2 Redo Log 2: ___/dev/vg_ops/rops2log2.log____20________
Instance 2 Redo Log 3: ___/dev/vg_ops/rops2log3.log____20_________
Instance 2 Redo Log: _________________________________________________
Instance 2 Redo Log: __________________________________________________
Data: System ___/dev/vg_ops/ropssystem.dbf___400__________
Data: Temp ___/dev/vg_ops/ropstemp.dbf______100_______
Data: Users ___/dev/vg_ops/ropsusers.dbf_____120_________
Data: Tools ___/dev/vg_ops/ropstools.dbf____15___________
Planning Database Storage 71