Oracle 10g configuration with Oracle agent
Configuration details:
-
Named: 10g_main.cf
-
More general purpose, can have multiple Oracle databases
-
Has two service groups: cvm and oradb1_grp
-
oradb1_grp depends on cvm
-
oradb1_grp has Oracle and oradata mount resource
include "types.cf"
include "CFSTypes.cf"
include "CVMTypes.cf"
include "OracleTypes.cf"
include "PrivNIC.cf"
cluster rac_cluster101 (
UserNames = { admin = bopHo }
Administrators = { admin }
UseFence = SCSI3
)
system galaxy (
)
system nebula (
)
group oradb1_grp (
SystemList = { galaxy = 0, nebula = 1 }
AutoFailOver = 0
Parallel = 1
AutoStartList = { galaxy, nebula }
)
Oracle ora1 (
Critical = 0
Sid @galaxy = vrts1
Sid @nebula = vrts2
Owner = oracle
Home = "/app/oracle/orahome"
StartUpOpt = "SRVCTLSTART"
ShutDownOpt = "SRVCTLSTOP"
)
CFSMount oradata_mnt (
Critical = 0
MountPoint = "/oradata"
BlockDevice = "/dev/vx/dsk/oradatadg/oradatavol"
)
CVMVolDg oradata_voldg (
Critical = 0
CVMDiskGroup = oradatadg
CVMVolume = { oradatavol }
CVMActivation = sw
)
requires group cvm online local firm
ora1 requires oradata_mnt
oradata_mnt requires oradata_voldg
group cvm (
SystemList = { galaxy = 0, nebula = 1 }
AutoFailOver = 0
Parallel = 1
AutoStartList = { galaxy, nebula }
)
Application cssd (
Critical = 0
StartProgram = "/opt/VRTSvcs/rac/bin/cssd-online"
StopProgram = "/opt/VRTSvcs/rac/bin/cssd-offline"
CleanProgram = "/opt/VRTSvcs/rac/bin/cssd-clean"
MonitorProgram = "/opt/VRTSvcs/rac/bin/cssd-monitor"
OnlineRetryLimit = 20
)
CFSMount ocrvote_mnt (
Critical = 0
MountPoint = "/ocrvote"
BlockDevice = "/dev/vx/dsk/ocrvotedg/ocrvotevol"
)
CVMVolDg ocrvote_voldg (
Critical = 0
CVMDiskGroup = ocrvotedg
CVMVolume = { ocrvotevol }
CVMActivation = sw
)
CFSfsckd vxfsckd (
)
CVMCluster cvm_clus (
CVMClustName = rac_cluster101
CVMNodeId = { galaxy = 0, nebula = 1 }
CVMTransport = gab
CVMTimeout = 200
)
CVMVxconfigd cvm_vxconfigd (
Critical = 0
CVMVxconfigdArgs = { syslog }
)
PrivNIC ora_priv (
Critical = 0
Device = { qfe0 = 0, qfe1 = 1}
Address@galaxy = "192.168.12.1"
Address@nebula = "192.168.12.2"
NetMask = "255.255.240.0"
)
cssd requires ocrvote_mnt
cssd requires ora_priv
ocrvote_mnt requires ocrvote_voldg
ocrvote_mnt requires vxfsckd
ocrvote_voldg requires cvm_clus
vxfsckd requires cvm_clus
cvm_clus requires cvm_vxconfigd