ASM instance initialization Parameter in Oracle

ASM instance initialization Parameter in Oracle

Following are the parameter used in pfile/spfile of Oracle Database:

1. INSTANCE_TYPE: Defines the instance type is RDBMS for Database instance and ASM for ASM instance.

For ASM instance, INSTANCE_TYPE = ASM

2. DB_UNIQUE_NAME: Global Unique name of Database mounted ASM Diskgroups.

DB_UNIQUE_NAME = +asm

3. ASM_DISKGROUPS: It specify the list of diskgroup names that ASM instance going to mount on startup.
Command in SQL ALTER DISKGROUP ALL MOUNT worked on this parameter.

ALTER SYSTEM SET ASM_DISKGROUPS = DATA, FRA;

4. ASM_DISKSTRING: used to specify the list of disks with comma-delimited strings like wild card * used to fetch all disk at specific location.

ASM_DISKSTRING = '/dev/rdsk/*', '/dev/rdsk/*disk4'

5. ASM_POWER_LIMIT: specifies the default power for disk rebalancing in a disk group.

Range from 0 to 1024, 0 value is used for disable rebalance operation.
ALTER SYSTEM SET ASM_POWER_LIMIT = 2;

6. ASM_PREFERRED_READ_FAILURE_GROUPS : is a comma-delimited list of strings that specifies the failure group.

ASM_PREFERRED_READ_FAILURE_GROUPS = diskgroup_name1.failure_group_name1, .. ;
ALTER SYSTEM SET ASM_PREFERRED_READ_FAILURE_GROUPS = DATA,DATA_FG, DATA1, DATA1_FG;

7. DIAGNOSTIC_DEST: It is the directory where diagnostics for an instance are located. Default location of Oracle base is GRID home installation.

ls $ORACLE_BASE/diag/asm/+asm/+ASM

2 thoughts on “ASM instance initialization Parameter in Oracle

  1. John

    How can this be resolved?

    D:\work>sqlplus / as sysasm

    SQL*Plus: Release 19.0.0.0.0 – Production on Sat Jan 2 08:23:22 2021
    Version 19.8.0.0.0

    Copyright (c) 1982, 2020, Oracle. All rights reserved.

    Connected to an idle instance.

    SQL> startup
    ORA-32004: obsolete or deprecated parameter(s) specified for ASM instance
    ORA-15150: instance lock mode ‘EXCLUSIVE’ conflicts with other ASM instance(s)
    SQL> exit
    Disconnected

    D:\work>

    Like

    Reply
    1. SandeepSingh DBA Post author

      First check you are connected with right ORACLE HOME location for ASM instance.
      Second, if you are using RAC, check the cluster_database parameter is true in both init parameter file from which you are starting.

      Like

      Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.