Verify Automatic Storage Management Installation

Applies to: Oracle 11g all Grid Editions

 1. Login and set Env Variables:  First of all login to system using GRID owner user. Set ORACLE_HOME env. variable to GRID_HOME.

In below example Grid owner is Oracle and Grid home is '/etc/oracle/grid'

[oracle@database ~]$ echo $ORACLE_HOME
/etc/oracle/grid

2. List Automatic Storage Management Backgroup Processes: List all background process to check ASM backgroup process are running, if not start Automatic Storage Management (ASM) instance using below command:

[oracle@database ~]$ ps -ef | grep ASM
oracle    5186  3034  0 04:09 pts/1    00:00:00 grep ASM


Find ASM instance name into $ORACLE_HOME/dbs by password file like: orapw+ASM

[oracle@database ~]$ export ORACLE_SID=+ASM
[oracle@database ~]$ sqlplus sys as sysasm

SQL*Plus: Release 11.2.0.2.0 Production on Sun Jan 27 04:10:11 2013

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

Enter password:
Connected to an idle instance.

SQL> startup
ASM instance started

Total System Global Area  284565504 bytes
Fixed Size                  1343692 bytes
Variable Size             258055988 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted

Now crosscheck about running background process

[oracle@databas[oracle@database ~]$ ps -ef | grep ASM

oracle    2660     1  0 Jan26 ?        00:00:01 asm_pmon_+ASM
oracle    2662     1  0 Jan26 ?        00:00:02 asm_psp0_+ASM
oracle    2664     1  0 Jan26 ?        00:03:08 asm_vktm_+ASM
oracle    2668     1  0 Jan26 ?        00:00:00 asm_gen0_+ASM
oracle    2670     1  0 Jan26 ?        00:00:00 asm_diag_+ASM
oracle    2672     1  0 Jan26 ?        00:00:00 asm_dskm_+ASM
oracle    2677     1  0 Jan26 ?        00:00:05 asm_dia0_+ASM
oracle    2679     1  0 Jan26 ?        00:00:00 asm_mman_+ASM
oracle    2681     1  0 Jan26 ?        00:00:00 asm_dbw0_+ASM
oracle    2683     1  0 Jan26 ?        00:00:00 asm_lgwr_+ASM
oracle    2685     1  0 Jan26 ?        00:00:00 asm_ckpt_+ASM
oracle    2687     1  0 Jan26 ?        00:00:00 asm_smon_+ASM
oracle    2689     1  0 Jan26 ?        00:00:01 asm_rbal_+ASM
oracle    2691     1  0 Jan26 ?        00:00:14 asm_gmon_+ASM
oracle    2693     1  0 Jan26 ?        00:00:00 asm_mmon_+ASM
oracle    2695     1  0 Jan26 ?        00:00:01 asm_mmnl_+ASM
oracle    2697     1  0 Jan26 ?        00:00:01 asm_xdmg_+ASM

3. Check Automatic Storage Management Parameters: Find your ASM instance name as last word of process name (+ASM) starting from + sign. Like  (asm_smon_+ASM) is process name, so instance name is +ASM

Check type of instance using below, if value is "asm" fine, otherwise it could be 'RDBMS' for database instance.

SQL> show parameter instance_type

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
instance_type                        string      asm

SQL> show parameter instance_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
instance_name                        string      +ASM

List diskgroup and mount status in Automatic Storage Management instance and crosscheck with diskgroups created at time of installation.

SQL> show parameter asm

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups                       string      FRA, DATA
asm_diskstring                       string
asm_power_limit                      integer     1
asm_preferred_read_failure_groups    string

SQL> select name,state from v$asm_diskgroup;

NAME                           STATE
------------------------------ -----------
DATA                           MOUNTED
FRA                            MOUNTED

No comments:

Post a Comment