Cluster Server 7.3.1 Agent for Oracle Installation and Configuration Guide - Solaris

Sample VCS configuration file for multiple Oracle instances (multiple listeners)

Review the sample configuration file for the multiple Oracle instances that have multiple listeners.

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

cluster vcs (
)

system sys1 (
)

system sys2 (
)

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

    DiskGroup DG_oramktg (
        DiskGroup = ora_mktg_dg
        StartVolumes = 0
        StopVolumes = 0
    )

    IP IP_oramktg (
        Device = hme0
        Address = "192.168.1.22"
								Netmask = "255.255.255.0"
    )

    Mount Mount_oramktg_u01 (
        MountPoint = "/mktg/u01"
        BlockDevice = "/dev/vx/dsk/ora_mktg_dg/u01-vol"
        FSType = vxfs
        FsckOpt = "-n"
    )

    Mount Mount_oramktg_u02 (
        MountPoint = "/mktg/u02"
        BlockDevice = "/dev/vx/dsk/ora_mktg_dg/u02-vol"
        FSType = vxfs
        FsckOpt = "-n"
    )

    Netlsnr LSNR_oramktg_lsnr (
        Owner = oramktg
      		Home = "/orahome/Oracle"
        TnsAdmin = "/orahome/Oracle/network/admin"
        Listener = LISTENER_MKTG
        MonScript = "./bin/Netlsnr/LsnrTest.pl"
        LsnrPwd = cqfOdoOolOo
    )

    Oracle ORA_oramktg (
        Sid = MKTG
        Owner = oramktg
        Home = "/orahome/Oracle"
        EnvFile = "/tmp/env.sh"
        MonScript = "./bin/Oracle/SqlTest.pl"
        User = thor
        Pword = hvlTptWvj
        Table = thor
        MonitorOption = 0
    )

    Proxy NICProxy_oramktg (
        TargetResName = NIC_Public1
    )

    Volume Vol_oramktg_vol1 (
        Volume = u01-vol
        DiskGroup = ora_mktg_dg
    )

    Volume Vol_oramktg_vol2 (
        Volume = u02-vol
        DiskGroup = ora_mktg_dg
    )

    IP_oramktg requires NICProxy_oramktg
    LSNR_oramktg_lsnr requires IP_oramktg
    LSNR_oramktg_lsnr requires ORA_oramktg
    Mount_oramktg_u01 requires Vol_oramktg_vol1
    Mount_oramktg_u02 requires Vol_oramktg_vol2
    ORA_oramktg requires Mount_oramktg_u01
    ORA_oramktg requires Mount_oramktg_u02
    Vol_oramktg_vol1 requires DG_oramktg
    Vol_oramktg_vol2 requires DG_oramktg


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 = hme0
        Address = "192.168.1.21"
								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"
    )

    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
        Table = thor
        MonitorOption = 0
    )

    Proxy NICProxy_oraprod (
        TargetResName = NIC_Public1
    )

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

    Volume Vol_oraprod_vol2 (
        Volume = u02-vol
        DiskGroup = ora_prod_dg
    )

    IP_oraprod requires NICProxy_oraprod
    LSNR_oraprod_lsnr requires IP_oraprod
    LSNR_oraprod_lsnr requires ORA_oraprod
    Mount_oraprod_u01 requires Vol_oraprod_vol1
    Mount_oraprod_u02 requires Vol_oraprod_vol2
    ORA_oraprod requires Mount_oraprod_u01
    ORA_oraprod requires Mount_oraprod_u02
    Vol_oraprod_vol1 requires DG_oraprod
    Vol_oraprod_vol2 requires DG_oraprod


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

    NIC NIC_Public1 (
        Device = hme0
								NetworkHosts = {"192.168.1.1"}
    )