Thursday, February 7, 2008

Initialization Parameters for ASM in Oracle 10G

The ASM instance has its own initialization parameter file and Server Parameter file.
ASM installation in clustered environments server parameters are not used unless there is shared ASM Oracle Home

The SID for ASM defaults to +ASM for a single instance database, +ASMnode# for Real Application Clusters


Initialization Parameters

INSTANCE_TYPE: Must be set to ASM

ASM_POWER_LIMIT: Default value 1, Range 0 to 11


ASM_DISKSTRING: Default Value NULL, strings that limits the set of disks that ASM discovers. String format depends on the ASM library in use and on the operating system.

Eg:
/dev/rdsk/*s6
/dev/rdsk/c2t1d*s3

ASM_DISKGROUPS: Default Value NULL

A list of the names of disk groups to be mounted by an ASM instance at startup or

ALTER DISKGROUP ALL MOUNT


Ref: Oracle Database Administrator guide B14231-02

No comments: