InfoScale™ 9.0 Cluster Server Agent for Oracle Installation and Configuration Guide - Solaris

Sample configuration of migratable Oracle pluggable database (PDB) resource in main.cf

Figure: Sample migratable Oracle CDB-PDB configuration

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

cluster vcs (
)

system SysA (
)

system SysB(
)

group ORA_CDB1_PROD_Group(
	SystemList = { SysA = 0, SysB = 1 }
	)

        DiskGroup cdb1_dg (
                DiskGroup = cdb_dg1
                )

	Volume cdb1_vol (
		Volume = cdbvol1
		DiskGroup = cdb_dg1
		)

	Mount cdb1_mnt (
		MountPoint = "/cdb1"
		BlockDevice = "/dev/vx/dsk/cdb_dg1/cdbvol1"
		FSType = vxfs
		FsckOpt = "-y"
			)

	DiskGroup pdb1_dg (
                DiskGroup = pdb_dg1
                )

        Volume pdb1_vol (
                Volume = pdbvol1
                DiskGroup = pdb_dg1
                )

        Mount pdb1_mnt (
                MountPoint = "/pdb1"
                BlockDevice = "/dev/vx/dsk/pdb_dg1/pdbvol1"
                FSType = vxfs
                FsckOpt = "-y"
                )
	
	DiskGroup pdb2_dg (
                DiskGroup = pdb_dg2
                )

        Volume pdb2_vol (
                Volume = pdbvol2
                DiskGroup = pdb_dg2
                )

        Mount pdb2_mnt (
                MountPoint = "/pdb2"
                BlockDevice = "/dev/vx/dsk/pdb_dg2/pdbvol2"
                FSType = vxfs
                FsckOpt = "-y"
                )
 
	IP IP_cdb1 (
                Device = hme0
                Address = "10.212.102.13"
                NetMask = "255.255.252.0"
                )
        
	NIC NIC_cdb1 (
                Device = hme0
                NetworkHosts = { "10.212.102.1" }
                )

	Netlsnr LSNR_cdb1 (
                Owner = oracle
                Home = "/u01/oraHome1"
                )
	
	Oracle ora_cdb1 (
		Sid = cdb1
		Owner = oracle
		Home = "/u01/oraHome1"
		StartUpOpt = STARTUP
		DBName = cdb1

)

	Oracle ora_pdb1 (
		Sid = cdb1
		Owner = oracle
		Home = "/u01/oraHome1"
		PDBName = PDB1

)

	Oracle ora_pdb2 (
		Critical = 0
		Sid = cdb1
		Owner = oracle
		Home = "/u01/oraHome1"
		PDBName = PDB2

)

	IP_cdb1 requires NIC_cdb1
	LSNR_cdb1 requires IP_cdb1
	LSNR_cdb1 requires ora_cdb1
	cdb1_mnt requires cdb1_vol 
	cdb1_vol requires cdb1_dg 
	pdb1_mnt requires pdb1_vol
	pdb1_vol requires pdb1_dg
	pdb2_mnt requires pdb2_vol
	pdb2_vol requires pdb2_dg
	ora_cdb1 requires cdb1_mnt 
	ora_pdb1 requires ora_cdb1
	ora_pdb1 requires pdb1_mnt
	ora_pdb2 requires ora_cdb1
	ora_pdb2 requires pdb2_mnt

group ORA_CDB2_PROD_Group(
	SystemList = { SysA = 0, SysB = 1 }
	)

        DiskGroup cdb2_dg (
                DiskGroup = cdb_dg2
                )

	Volume cdb2_vol (
		Volume = cdbvol2
		DiskGroup = cdb_dg2
		)

	Mount cdb2_mnt (
		MountPoint = "/cdb2"
		BlockDevice = "/dev/vx/dsk/cdb_dg2/cdbvol2"
		FSType = vxfs
		FsckOpt = "-y"
		)

	DiskGroup pdb3_dg (
                DiskGroup = pdb_dg3
                )

        Volume pdb3_vol (
                Volume = pdbvol3
                DiskGroup = pdb_dg3
                )

        Mount pdb3_mnt (
                MountPoint = "/pdb3"
                BlockDevice = "/dev/vx/dsk/pdb_dg3/pdbvol3"
                FSType = vxfs
                FsckOpt = "-y"
                )
	
	DiskGroup pdb4_dg (
                DiskGroup = pdb_dg4
                )

        Volume pdb4_vol (
                Volume = pdbvol4
                DiskGroup = pdb_dg4
                )

        Mount pdb4_mnt (
                MountPoint = "/pdb4"
                BlockDevice = "/dev/vx/dsk/pdb_dg4/pdbvol4"
                FSType = vxfs
                FsckOpt = "-y"
                )
 
	IP IP_cdb2 (
                Device = hme0
                Address = "10.212.102.14"
                NetMask = "255.255.252.0"
                )
        
	NIC NIC_cdb2 (
                Device = hme0
                NetworkHosts = { "10.212.102.1" }
                )

	Netlsnr LSNR_cdb2 (
                Owner = oracle
                Home = "/u01/oraHome2"
                )
	
	Oracle ora_cdb2 (
		Sid = cdb2
		Owner = oracle
		Home = "/u01/oraHome2"
		StartUpOpt = STARTUP
		DBName = cdb2

)

	Oracle ora_pdb3 (
		Sid = cdb2
		Owner = oracle
		Home = "/u01/oraHome2"
		PDBName = PDB3

)

	Oracle ora_pdb4 (
		Sid = cdb2
		Owner = oracle
		Home = "/u01/oraHome2"
		PDBName = PDB4

)

	IP_cdb2 requires NIC_cdb2
	LSNR_cdb2 requires IP_cdb2
	LSNR_cdb2 requires ora_cdb2
	cdb2_mnt requires cdb2_vol 
	cdb2_vol requires cdb2_dg 
	pdb3_mnt requires pdb3_vol
	pdb3_vol requires pdb3_dg
	pdb4_mnt requires pdb4_vol
	pdb4_vol requires pdb4_dg
	ora_cdb2 requires cdb2_mnt 
	ora_pdb3 requires ora_cdb2
	ora_pdb3 requires pdb3_mnt
	ora_pdb4 requires ora_cdb2
	ora_pdb4 requires pdb4_mnt