Sun Microsystems, Inc.  Oracle System Handbook - ISO 7.0 May 2018 Internal/Partner Edition
   Home | Current Systems | Former STK Products | EOL Systems | Components | General Info | Search | Feedback

Asset ID: 1-72-1644043.1
Update Date:2014-04-10
Keywords:

Solution Type  Problem Resolution Sure

Solution  1644043.1 :   ODA : 24 Extra Disk paths exists in ASM with group_number 0 and without suffix p1 or p2  


Related Items
  • Oracle Database Appliance
  •  
Related Categories
  • PLA-Support>Eng Systems>Exadata/ODA/SSC>Oracle Database Appliance>DB: ODA_EST
  •  




Applies to:

Oracle Database Appliance - Version All Versions to All Versions [Release All Releases]
Information in this document applies to any platform.

Symptoms

In ODA system there are 24 extra  ASM disk path exist as given below. 

 

e.g.  from v$asm_disk output there are 24 extra disk with group number 0 and without p1 or p2 as suffix in path.

Group#                 PATH
------             ----------------------------------
0                   /dev/mapper/SSD_E1_S23_805650174
0                   /dev/mapper/SSD_E1_S22_805649834
0                   /dev/mapper/SSD_E0_S21_805650092
0                   /dev/mapper/SSD_E0_S20_805650143
0                   /dev/mapper/HDD_E1_S07_979788859
0                   /dev/mapper/HDD_E1_S15_980711351
0                   /dev/mapper/HDD_E1_S03_979852663
0                   /dev/mapper/HDD_E1_S19_979894387
0                   /dev/mapper/HDD_E1_S11_979832047
0                   /dev/mapper/HDD_E1_S18_978146743
0                   /dev/mapper/HDD_E1_S14_979870115
0                   /dev/mapper/HDD_E1_S10_979868675
0                   /dev/mapper/HDD_E1_S06_979774155
0                   /dev/mapper/HDD_E1_S02_979863959
0                   /dev/mapper/HDD_E0_S05_979851287
0                   /dev/mapper/HDD_E0_S01_979828143
0                   /dev/mapper/HDD_E0_S13_979811543
0                   /dev/mapper/HDD_E0_S09_979865295
0                   /dev/mapper/HDD_E0_S17_979870371
0                   /dev/mapper/HDD_E0_S12_979780459
0                   /dev/mapper/HDD_E0_S16_979861967
0                   /dev/mapper/HDD_E0_S08_979868995
0                   /dev/mapper/HDD_E0_S04_979784547
0                   /dev/mapper/HDD_E0_S00_979817979

 

Changes

 This issue is due to incorrect asm_diskstring parameter. Current asm_diskstring parameter is set to '/dev/mapper/*D_*' which must be  set to '/dev/mapper/*D_*p*' for ODA system .

Cause

 asm_diskstring parameter is changed  to '/dev/mapper/*D_*' . 

On ODA system there are three multipath created for one disk. 

e.g.

/dev/mapper/HDD_E0_S00_979817979

/dev/mapper/HDD_E0_S00_979817979p1

/dev/mapper/HDD_E0_S00_979817979p2

 

Suffix p1 is for disks belong to DATA or  REDO(in case SSD) and p2 for disks belong to RECO.

asm_diskstring  to '/dev/mapper/*D_*p*' removes the disk path without suffix  p1 or p2  to be visible from asm side. 

Solution

 To resolve this issue change asm_diskstring parameter back to '/dev/mapper/*D_*p*' .

  Run following action plan on both the nodes. 

 

On ASM instance :

 connect   as SYSASM

 SQL> alter system set asm_diskstring= '/dev/mapper/*D_*p*'  ; 

 

***This action plan can be  executed on running system***

Now check v$asm_disk output, all the disks with group_number '0' and without suffix p1 or p2 are  removed now.


Attachments
This solution has no attachment
  Copyright © 2018 Oracle, Inc.  All rights reserved.
 Feedback