Oracle Configuration With Shared Server Support
The following example describes a typical service group configured to monitor Oracle with shared server support.
Click the thumbnail above to view full-sized image.
The shared disk groups and volumes in the cluster are configured as resources of type DiskGroup and Volume respectively. The volumes are mounted using the Mount agent. The virtual IP address for the service group is configured using the IP and NIC resource types. The Oracle server can be started after each of these resources is brought online.
If your configuration does not use VERITAS Volume Manager, use the DiskReservation resource type to configure shared storage instead of the DiskGroup and Volume resource types.
Sample Configuration File
include "types.cf"
include "OracleTypes.cf"
cluster vcs (
)
system vcshp1 (
)
system vcshp2 (
)
group ORA_PROD_Group (
SystemList = { vcshp1 = 0, vcshp2 = 1 }
AutoStartList = { vcshp1 }
)
DiskGroup DG_oraprod (
DiskGroup = ora_prod_dg
StartVolumes = 0
StopVolumes = 0
)
IP IP_oraprod (
Device = lan0
Address = "10.212.102.13"
)
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 = lan0
)
Netlsnr LSNR_oraprod_lsnr (
Owner = oraprod
Home = "/prod/u01/oracle/product/8.1.5"
TnsAdmin = "/prod/u01/oracle/network/admin"
Listener = LISTENER_PROD
MonScript = "./bin/Netlsnr/LsnrTest.pl"
)
Oracle ORA_oraprod (
Sid = PROD
Owner = oraprod
Home = "/prod/u01/oracle/product/8.1.5"
Pfile = "/prod/u01/oracle/admin/pfile/initPROD.ora"
EnvFile = "/tmp/env.sh"
DetailMonitor = 1
MonScript = "./bin/Oracle/SqlTest.pl"
User = thor
Pword = hvlTptWvj
Table = thor
)
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 NIC_ORAPROD
LSNR_oraprod_lsnr requires IP_oraprod
Mount_oraprod_u01 requires Vol_oraprod_vol1
Mount_oraprod_u02 requires Vol_oraprod_vol2
ORA_oraprod requires IP_oraprod
ORA_oraprod requires Mount_oraprod_u01
ORA_oraprod requires Mount_oraprod_u02
Vol_oraprod_vol1 requires DG_oraprod
Vol_oraprod_vol2 requires DG_oraprod
|
