mardi 9 août 2011

Oracle11g : ASM mandatory parameters

An ASM instance can be configured through 74 parameters.
Only 8 parameters are required :
INSTANCE_TYPE = ASM
ASM_POWER_LIMIT = 1
ASM_DISKSTRING = '/dev/sda1','/dev/sda2','/dev/sdb*'
ASM_DISKGROUPS = DATA,FRA
ASM_PREFERRED_READ_FAILURE_GROUPS = DATA.FailGroup1
DIAGNOSTIC_DEST = /u01/app/oracle
LARGE_POOL_SIZE = 12M
REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE

The INSTANCE_TYPE is the only mandatory parameter !

ASM_POWER_LIMIT is used to define the rebalancing speed. Value is in range [0,11]
ASM_DISKSTRING is used for disk automatic discovery
ASM_DISKGROUPS defines all groups that will be monted automatically at startup
ASM_PREFERRED_READ_FAILURE_GROUPS defined the disk failure group that will be used in a cluster environment
DIAGNOSTIC_DEST defines the location of the ADR repository (Automatic Diagnostic Repository)
REMOTE_LOGIN_PASSWORDFILE check the availability of a password file. Default value is EXCLUSIVE.