Sample VCS configuration file for single Oracle instance (VxVM)

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

Figure: Dependency graph for single Oracle instance (VxVM)

Dependency graph for single Oracle instance (VxVM)

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 }
)

    DiskGroup DG_oraprod (
        DiskGroup = ora_prod_dg
        StartVolumes = 0
        StopVolumes = 0
    )

    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
    )

    Volume Vol_oraprod_vol1 (
       Volume = u01-vol
       DiskGroup = ora_prod_dg
    )

    Volume Vol_oraprod_vol2 (
       Volume = u02-vol
       DiskGroup = ora_prod_dg
    )
        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 Vol_oraprod_vol1
Mount_oraprod_u02 requires Vol_oraprod_vol2
Vol_oraprod_vol1 requires DG_oraprod
Vol_oraprod_vol2 requires DG_oraprod
DG_oraprod requires VMwareDisk_01
DG_oraprod requires VMwareDisk_02