SIHA ::ORA-15063 :: Duplicate disk due to wrong asm resource profile value (Doc ID 1905947.1)

Last updated on SEPTEMBER 19, 2023

Applies to:

Symptoms

There is no ASMlib ,native multipathing is in place.
This is a standalone environment.
While trying to mount the diskgroup ,diskgroup mount was failing due to duplicate disk .

SQL> ALTER DISKGROUP ALL MOUNT /* asm agent call crs *//* {0:0:431} */
NOTE: Diskgroups listed in ASM_DISKGROUPS are
FRA
DATA_02
...
WARNING: detected duplicate paths to the same disk:
'/dev/sdan' and
'/dev/mapper/Oracle_LUN02'
More trace information dumped to
'<ASM Trace Directory>/+ASM_ora_1038.trc'
WARNING: detected duplicate paths to the same disk:
'/dev/sdt' and
'/dev/sdy'
More trace information dumped to
'<ASM Trace Directory>/+ASM_ora_1038.trc'
WARNING: detected duplicate paths to the same disk:
'/dev/oracle_lun02' and
'/dev/sde'
More trace information dumped to
'<ASM Trace Directory>/+ASM_ora_1038.trc'
ERROR: no read quorum in group: required 2, found 0 disks
...
NOTE: cache ending mount (fail) of group DATA_02 number=1 incarn=0xcd020c35
NOTE: cache deleting context for group DATA_02 1/0xcd020c35
Tue Jun 10 09:15:05 2014
NOTE: No asm libraries found in the system
GMON dismounting group 1 at 2 for pid 17, osid 1038
ERROR: diskgroup DATA_02 was not mounted
ERROR: no read quorum in group: required 2, found 0 disks
NOTE: cache dismounting (clean) group 2/0xCD020C36 (FRA)
...
NOTE: cache deleting context for group FRA 2/0xcd020c36
ASM Health Checker found 1 new failures
NOTE: No asm libraries found in the system
GMON dismounting group 2 at 4 for pid 17, osid 1038
ERROR: diskgroup FRA was not mounted
ORA-15032: not all alterations performed
ORA-15017: diskgroup "FRA" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "FRA"
ORA-15017: diskgroup "DATA_02" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup
"DATA_02"
ERROR: ALTER DISKGROUP ALL MOUNT /* asm agent call crs *//* {0:0:431} */
SQL> ALTER DISKGROUP ALL ENABLE VOLUME ALL /* asm agent *//* {0:0:431} */
SQL> ALTER DISKGROUP DATA_03 MOUNT /* asm agent *//* {0:0:431} */
NOTE: cache registered group DATA_03 number=1 incarn=0xcf220c39
NOTE: cache began mount (first) of group DATA_03 number=1 incarn=0xcf220c39
Tue Jun 10 09:15:05 2014
SQL> ALTER DISKGROUP DATA_04 MOUNT /* asm agent *//* {0:0:431} */
Tue Jun 10 09:15:05 2014
SQL> ALTER DISKGROUP FRA MOUNT /* asm agent *//* {0:0:431} */
WARNING: detected duplicate paths to the same disk:
'/dev/sdal' and
'/dev/mapper/Oracle_LUN04'
More trace information dumped to
'<ASM Trace Directory>/+ASM_ora_1038.trc'
Tue Jun 10 09:15:05 2014
ALTER SYSTEM SET
local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=XXX.XX
X.XXX.YYY)(PORT=1521))))' SCOPE=MEMORY SID='+ASM';
WARNING: detected duplicate paths to the same disk:
'/dev/sdr' and
'/dev/sdw'
More trace information dumped to
'<ASM Trace Directory>/+ASM_ora_1038.trc'
WARNING: detected duplicate paths to the same disk:
'/dev/oracle_lun04' and
'/dev/sdc'
More trace information dumped to
'<ASM Trace Directory>/+ASM_ora_1038.trc'
ERROR: no read quorum in group: required 2, found 0 disks
NOTE: cache dismounting (clean) group 1/0xCF220C39 (DATA_03)
...
NOTE: cache deleting context for group DATA_03 1/0xcf220c39
GMON dismounting group 1 at 6 for pid 17, osid 1038
ERROR: diskgroup DATA_03 was not mounted
ORA-15032: not all alterations performed
ORA-15017: diskgroup "DATA_03" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup
"DATA_03"
ERROR: ALTER DISKGROUP DATA_03 MOUNT /* asm agent *//* {0:0:431} */
SQL> ALTER DISKGROUP FRA_NEW MOUNT /* asm agent *//* {0:0:431} */
NOTE: cache registered group DATA_04 number=1 incarn=0xd0420c3c
NOTE: cache began mount (first) of group DATA_04 number=1 incarn=0xd0420c3c
Tue Jun 10 09:15:05 2014
NOTE: No asm libraries found in the system
ASM Health Checker found 1 new failures
WARNING: detected duplicate paths to the same disk:


Lets take a look for one of those devices ,
.
WARNING: detected duplicate paths to the same disk:
'/dev/oracle_lun05' and
'/dev/sdk'

brw-rw----. 1 oracle oinstall 253, 10 Jun 17 14:54 /dev/oracle_lun05

brw-rw----. 1 root disk 8, 160 Jun 17 14:54 /dev/sdk

multipath {
wwid 36000d31000110a0000000000000001a2
alias Oracle_LUN05

Oracle_LUN05 (36000d31000110a0000000000000001a2) dm-10 COMPELNT,Compellent
Vol
size=50G features='1 queue_if_no_path' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
|- 1:0:1:5 sdk 8:160 active ready running <<----------------------
|- 1:0:2:5 sdp 8:240 active ready running
|- 2:0:1:5 sdae 65:224 active ready running
`- 2:0:2:5 sdaj 66:48 active ready running
.

 

Lets validate access and contents ,

$ sudo dd if=/dev/oracle_lun05 of=/tmp/oracle_lun05.dd bs=1M count=5
[sudo] password for oracle:
5+0 records in
5+0 records out
5242880 bytes (5.2 MB) copied, 0.174492 s, 30.0 MB/s


$ kfed read /dev/oracle_lun05 |egrep "kfbh.type|kfdhdb.driver.provstr|kfdhdb.dsknum|kfdhdb.hdrsts|kfdhdb.grpname"
kfbh.type: 1 ; 0x002: KFBTYP_DISKHEAD
kfdhdb.driver.provstr: ORCLDISK ; 0x000: length=8
kfdhdb.dsknum: 0 ; 0x024: 0x0000
kfdhdb.hdrsts: 3 ; 0x027: KFDHDR_MEMBER
kfdhdb.grpname: DATA_04 ; 0x048: length=7


$ dd if=/dev/sdk of=/tmp/sdk.dd bs=1M count=5
5+0 records in
5+0 records out
5242880 bytes (5.2 MB) copied, 0.323135 s, 16.2 MB/s


$ kfed read /dev/sdk |egrep "kfbh.type|kfdhdb.driver.provstr|kfdhdb.dsknum|kfdhdb.hdrsts|kfdhdb.grpname"
kfbh.type: 1 ; 0x002: KFBTYP_DISKHEAD
kfdhdb.driver.provstr: ORCLDISK ; 0x000: length=8
kfdhdb.dsknum: 0 ; 0x024: 0x0000
kfdhdb.hdrsts: 3 ; 0x027: KFDHDR_MEMBER
kfdhdb.grpname: DATA_04 ; 0x048: length=7
.
.
.
.
---So sdk and Oracle_LUN05 is duplicating .
Same base device is pointed by two path /dev/sdk and /dev/oracle_lun05 and they are accessible to ASM.

Changes

   last time the storage/System admin unpresented compellent snapshot and represents data luns 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.