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.
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