Skip to main content
NetApp Knowledge Base

Oracle RAC DB crashes after a single path failure

  1. Last updated
  2. Save as PDF
Views:
779
Visibility:
Public
Votes:
0
Category:
fas-systems
Specialty:
san
Last Updated:

Applies to

Issue

  • Oracle RAC DB(with ASM) crashes during maintenance/upgrade activity when only a single path fails
  • Oracle errors example:

ORA-15025: could not open disk "/dev/oracleasm/disks/NETAPPASMDISK10"
ORA-27041: unable to open file
Linux-x86_64 Error: 6: No such device or address
Additional information: 3
2021-05-20T16:17:39.327294+03:00
WARNING: Read Failed. group:3 disk:9 AU:202506 offset:2768896 size:8192
path:Unknown disk
      incarnation:0xef03276f synchronous result:'I/O error'
      subsys:Unknown library krq:0x7f65533e23a0 bufp:0x1851c2a000 osderr1:0x434c5344 osderr2:0x0
      IO elapsed time: 0 usec Time waited on I/O: 0 usec
WARNING: failed to read mirror side 1 of virtual extent 7825 logical extent 0 of file 354 in group [3.3887094271] from disk NETAPPASMDISK10  allocation unit 202506 reason error; if possible, will try another mirror side
2021-05-20T16:17:39.347741+03:00
PMON (ospid: 22445): terminating the instance due to ORA error 12752
Cause - 'Instance is being terminated due to fatal process death (pid: 48, ospid: 27976, LG00)'
2021-05-20T16:17:39.449937+03:00
opiodr aborting process unknown ospid (41981) as a result of ORA-1092
2021-05-20T16:17:39.854629+03:00
opiodr aborting process unknown ospid (4201) as a result of ORA-1092
2021-05-20T16:17:40.666706+03:00
*****************************************************************

  • Host errors example: 

May 20 16:08:55 oracle multipathd: checker failed path 65:240 in map netappdisk10
May 20 16:08:55 oracle multipathd: netappdisk10: remaining active paths: 3
May 20 16:10:31 oracle multipathd: netappdisk10: sdaf - tur checker reports path is up
May 20 16:10:31 oracle multipathd: netappdisk10: remaining active paths: 4
May 20 16:11:10 oracle multipathd: checker failed path 65:240 in map netappdisk10
May 20 16:11:10 oracle multipathd: netappdisk10: remaining active paths: 3
May 20 16:11:16 oracle multipathd: netappdisk10: sdaf - tur checker reports path is up
May 20 16:11:16 oracle multipathd: netappdisk10: remaining active paths: 4

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.