InfoScale™ 9.0 Agent for Oracle Installation and Configuration Guide - AIX

Sample VCS configuration file for multiple Oracle instances (single listener)

Review the sample configuration file for multiple Oracle instances.

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
    )

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

    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
    )

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

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

    requires group Common_Service online local firm
    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
    )

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

    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
    )

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

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

    requires group Common_Service online local firm
    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 Common_Service (
    SystemList = { sys1 = 0, sys2 = 1 }
    AutoStartList = { sys1 } 
)

    DiskGroup DG_orabin (
        DiskGroup = ora_bin_dg
        StartVolumes = 0
        StopVolumes = 0
    )

    IP IP_oraprod (
        Device = en0
        Address = "192.168.1.22"
								Netmask = "255.255.255.0"
    )

    Mount Mount_orabin (
        MountPoint = "/orahome/Oracle"
        BlockDevice = "/dev/vx/dsk/ora_bin_dg/u01-vol"
        FSType = vxfs
        FsckOpt = "-n"
    )

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

    Netlsnr LSNR_oracle (
        Owner = oracle
        Home = "/orahome/Oracle"
        TnsAdmin = "/orahome/Oracle/network/admin"
        Listener = LISTENER_ORACLE
        MonScript = "./bin/Netlsnr/LsnrTest.pl"
    )

    Volume Vol_orabin (
        Volume = u01-vol
        DiskGroup = ora_bin_dg
    )

    IP_oraprod requires NIC_Public1
    LSNR_oracle requires IP_oraprod
    LSNR_oracle requires Mount_orabin
    Mount_orabin requires Vol_orabin
    Vol_orabin requires DG_orabin