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