V$ASM_DISK View Shows Both "ORCL:*" & "/dev/oracleasm/disks/*" Paths in ASM Instance (Doc ID 1410243.1)

Last updated on SEPTEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 02-Sep-2013***

Symptoms

1) ASM 11.2. RAC configuration on ASMLIB.


2) ASM (v$asm_view) is reporting both paths ("ORCL:*", "/dev/oracleasm/disks/*") to access the same disks:

SQL> select label, path from v$asm_disk where path like '%ASM2%';

LABEL PATH
------------------------------- -----------------------------------
/dev/oracleasm/disks/ASM29
/dev/oracleasm/disks/ASM28
/dev/oracleasm/disks/ASM26
/dev/oracleasm/disks/ASM27
/dev/oracleasm/disks/ASM25
/dev/oracleasm/disks/ASM24
/dev/oracleasm/disks/ASM23
/dev/oracleasm/disks/ASM22
/dev/oracleasm/disks/ASM21
/dev/oracleasm/disks/ASM20
ASM20 ORCL:ASM20

LABEL PATH
------------------------------- -----------------------------------
ASM29 ORCL:ASM29
ASM25 ORCL:ASM25
ASM26 ORCL:ASM26
ASM27 ORCL:ASM27
ASM28 ORCL:ASM28
ASM21 ORCL:ASM21
ASM22 ORCL:ASM22
ASM23 ORCL:ASM23
ASM24 ORCL:ASM24



3) Despite we force and restrict the disk discovery as follow (the problem persisted):

SQL>alter system set asm_diskstring = 'ORCL:*';



4) asm_diskstring is correctly set in the pfile:


+ASM1||/global/apps/grid/11.2.0/dbs-> cat init+ASM1.ora
+ASM2.asm_diskgroups='DG_QADATA','DG_FLASH01'#Manual Dismount
+ASM1.asm_diskgroups='DG_QADATA','DG_FLASH01'#Manual Dismount
*.asm_diskgroups='DG_QADATA','DG_FLASH01'
*.asm_diskstring='ORCL:*' <(=== HERE
*.asm_power_limit=1
*.diagnostic_dest='/global/apps/oracle'
+ASM2.instance_number=2
+ASM1.instance_number=1
*.instance_type='asm'
*.large_pool_size=20971520
+ASM1.processes=1000
+ASM2.processes=1000
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=500M



5) ASMLIB API looks in good shape:

+ASM1||/global/apps/grid/11.2.0/dbs-> rpm -qa | grep oracleasm
oracleasm-2.6.18-164.el5-2.0.5-1.el5
oracleasm-2.6.18-274.0.0.0.1.el5-2.0.5-1.el5
oracleasm-2.6.18-164.11.1.0.1.el5-2.0.5-1.el5
oracleasm-2.6.18-164.15.1.0.1.el5-2.0.5-1.el5
oracleasm-support-2.1.7-1.el5
oracleasmlib-2.0.4-1.el5
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ASM1||/global/apps/grid/11.2.0/dbs-> uname -r
2.6.18-274.0.0.0.1.el5



6) ASM alert.log (on both ASM instances "+ASM1 & +ASM2") shows the correct discovery path and using the correct disks:

System parameters with non-default values:
processes = 1000
shared_pool_size = 500M
large_pool_size = 20M
instance_type = "asm"
instance_number = 1
remote_login_passwordfile= "EXCLUSIVE"
asm_diskstring = "ORCL:*" <( ==== here
asm_diskgroups = "DG_QADATA"
asm_diskgroups = "DG_FLASH01"
asm_power_limit = 1
diagnostic_dest = "/global/apps/oracle"
Cluster communication is configured to use the following interface(s) for
this instance
172.16.1.13
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
Sun Dec 04 10:34:05 2011




All grantable enqueues granted
Submitted all GCS remote-cache requests
Fix write in gcs resources
Reconfiguration complete
Sun Dec 04 10:34:10 2011
LCK0 started with pid=22, OS id=11493
ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
Sun Dec 04 10:34:10 2011
SQL> ALTER DISKGROUP ALL MOUNT /* asm agent */
NOTE: Diskgroups listed in ASM_DISKGROUPS are
DG_QADATA
DG_FLASH01
NOTE: cache registered group DG_FLASH01 number=1 incarn=0x8840e7e8
NOTE: cache began mount (not first) of group DG_FLASH01 number=1
incarn=0x8840e7e8
NOTE: cache registered group DG_QADATA number=2 incarn=0x8840e7e9
NOTE: cache began mount (not first) of group DG_QADATA number=2
incarn=0x8840e7e9
NOTE: Loaded library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so
NOTE: Assigning number (1,1) to disk (ORCL:ASM100) <( ==== here
NOTE: Assigning number (2,43) to disk (ORCL:ASM101) <( ==== here
NOTE: Assigning number (2,44) to disk (ORCL:ASM102) <( ==== here
NOTE: Assigning number (2,45) to disk (ORCL:ASM103) <( ==== here
NOTE: Assigning number (2,46) to disk (ORCL:ASM104) <( ==== here
NOTE: Assigning number (2,47) to disk (ORCL:ASM105) <( ==== here
NOTE: Assigning number (2,77) to disk (ORCL:ASM135) <( ==== here
NOTE: Assigning number (2,78) to disk (ORCL:ASM136) <( ==== here
NOTE: Assigning number (2,79) to disk (ORCL:ASM137) <( ==== here
NOTE: Assigning number (2,80) to disk (ORCL:ASM138) <( ==== here
NOTE: Assigning number (2,81) to disk (ORCL:ASM139) <( ==== here
NOTE: Assigning number (2,82) to disk (ORCL:ASM140) <( ==== here
NOTE: Assigning number (2,83) to disk (ORCL:ASM141) <( ==== here
NOTE: Assigning number (2,84) to disk (ORCL:ASM142) <( ==== here
kfdp_query(DG_FLASH01): 3




7) But v$asm_disk view still reports both paths:

GROUP_NUMBER PATH NAME
------------ --------------------------------------------------
------------------------------
0 /dev/oracleasm/disks/ASM100
0 /dev/oracleasm/disks/ASM101
0 /dev/oracleasm/disks/ASM102
0 /dev/oracleasm/disks/ASM103
0 /dev/oracleasm/disks/ASM104
0 /dev/oracleasm/disks/ASM105
0 /dev/oracleasm/disks/ASM106
0 /dev/oracleasm/disks/ASM107
0 /dev/oracleasm/disks/ASM108
0 /dev/oracleasm/disks/ASM109
0 /dev/oracleasm/disks/ASM110
0 /dev/oracleasm/disks/ASM111
0 /dev/oracleasm/disks/ASM112
0 /dev/oracleasm/disks/ASM113
0 /dev/oracleasm/disks/ASM114
0 /dev/oracleasm/disks/ASM115
0 /dev/oracleasm/disks/ASM116
0 /dev/oracleasm/disks/ASM117
0 /dev/oracleasm/disks/ASM118
0 /dev/oracleasm/disks/ASM119
0 /dev/oracleasm/disks/ASM120
1 ORCL:ASM100 ASM100
2 ORCL:ASM101 ASM101
2 ORCL:ASM102 ASM102
2 ORCL:ASM103 ASM103
2 ORCL:ASM104 ASM104
2 ORCL:ASM105 ASM105
2 ORCL:ASM106 ASM106
2 ORCL:ASM107 ASM107
2 ORCL:ASM108 ASM108
2 ORCL:ASM109 ASM109
2 ORCL:ASM110 ASM110
2 ORCL:ASM111 ASM111
2 ORCL:ASM112 ASM112
2 ORCL:ASM113 ASM113
2 ORCL:ASM114 ASM114
2 ORCL:ASM115 ASM115
2 ORCL:ASM116 ASM116
2 ORCL:ASM117 ASM117
2 ORCL:ASM118 ASM118
2 ORCL:ASM119 ASM119
2 ORCL:ASM120 ASM120

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms