Cluster Server 7.4 Agent for Oracle Installation and Configuration Guide - Linux

Sample VCS configuration file for single Oracle instance (LVM)

Figure: Dependency graph for single Oracle instance (LVM) shows a typical service group configured to monitor the state of an Oracle instance. In this example, the Oracle instance uses LVM volume as storage.

Figure: Dependency graph for single Oracle instance (LVM)

Review the sample configuration with a resource of type Oracle that is configured as follows in main.cf file.

include "types.cf"
include "OracleTypes.cf"

cluster vcs (
)

system sys1 (
)

system sys2 (
)

group ORA_PROD_Group (
    SystemList = { sys1 = 0, sys2 = 1 }
    AutoStartList = { sys1 }
)

    LVMVolumeGroup LVMVG_oraprod (
        LVMVolumeGroup = ora_prod_vg
    )

    IP IP_oraprod (
       Device = eth0
       Address = "192.168.1.22"
       Netmask = "255.255.255.0"
    )

    Mount Mount_oraprod_u01 (
        MountPoint = "/prod/u01"
        BlockDevice = "/dev/vx/dsk/ora_prod_dg/u01-vol"
        FSType = vxfs
        FsckOpt = "-n"
    )

    Mount Mount_oraprod_u02 (
        MountPoint = "/prod/u02"
        BlockDevice = "/dev/vx/dsk/ora_prod_dg/u02-vol"
        FSType = vxfs
        FsckOpt = "-n"
    )

    NIC NIC_oraprod (
        Device = eth0
        NetworkHosts = {"192.168.1.1"}
    )

    Netlsnr LSNR_oraprod_lsnr (
        Owner = oraprod
        Home = "/orahome/Oracle"
        TnsAdmin = "/orahome/Oracle/network/admin"
        Listener = LISTENER_PROD
        MonScript = "./bin/Netlsnr/LsnrTest.pl"
        LsnrPwd = cqfOdoOolOo
    )

    Oracle ORA_oraprod (
        Sid = PROD
        Owner = oraprod
        Home = "/orahome/Oracle"
        EnvFile = "/tmp/env.sh"
        MonScript = "./bin/Oracle/SqlTest.pl"
        User = thor
        Pword = hvlTptWvj
        DBAUser = "orauser"
        DBAPword = "DPSrFPeRIrGPiRF"
        Table = thor
        MonitorOption = 0
    )

    LVMLogicalVolume LVMVol_oraprod_vol1 (
       LVMLogicalVolume = ora_oraprod_vol1
       LVMVolumeGroup = ora_prod_vg
    )
    LVMLogicalVolume LVMVol_oraprod_vol2 (
       LVMLogicalVolume = ora_oraprod_vol2
       LVMVolumeGroup = ora_prod_vg
    )
        VMwareDisks VMwareDisk_01 (
                ESXDetails = {
                      "ESX1.domain.com" = "root=Encrypted Password",
                      "ESX2.domain.com" = "root=Encrypted Password" }
                DiskPaths = {
                         "6000C29d-5235-4480-823e-1234abcd1234:
                         [datastore1] disk1.vmdk" = "0:1" }
                )

        VMwareDisks VMwareDisk_02 (
                ESXDetails = {
                      "ESX1.domain.com" = "root=Encrypted Password",
                      "ESX2.domain.com" = "root=Encrypted Password" }
                DiskPaths = {
                         "RDM:6000C290-2462-33ca-7019-1234abcd1234:
                         [datastore1] disk2.vmdk" = "0:2" }
                )

IP_oraprod requires NIC_oraprod
LSNR_oraprod_lsnr requires IP_oraprod
LSNR_oraprod_lsnr requires ORA_oraprod
ORA_oraprod requires Mount_oraprod_u01
ORA_oraprod requires Mount_oraprod_u02
Mount_oraprod_u01 requires LVMVol_oraprod_vol1
Mount_oraprod_u02 requires LVMVol_oraprod_vol2
LVMVol_oraprod_vol1 requires LVMVG_oraprod 
LVMVol_oraprod_vol2 requires LVMVG_oraprod 
LVMVG_oraprod requires VMwareDisk_01
LVMVG_oraprod requires VMwareDisk_02