Oracle running on RHEL4 with a Hitachi OPEN-V storage array results in scsi errors with sense key 'Command Phase Error'

Solution Verified - Updated -

Issue

  • device-mapper-multipath device lost access to all paths due to SCSI error with sense key Command Phase Error

    Feb 16 10:26:44 node1 kernel: SCSI error : <1 0 0 3> return code = 0x8000002
    Feb 16 10:26:44 node1 kernel: Current sdak: sense key Aborted Command
    Feb 16 10:26:44 node1 kernel: Additional sense: Command phase error
    Feb 16 10:26:44 node1 kernel: end_request: I/O error, dev sdak, sector 500457711
    Feb 16 10:26:44 node1 kernel: end_request: I/O error, dev sdak, sector 500457719
    Feb 16 10:26:45 node1 multipathd: 66:64: mark as failed
    Feb 16 10:26:45 node1 multipathd: mpath0: remaining active paths: 0
    
  • Oracle reported a failure on write to its control file:

    ORA-00221: error on write to control file
    ORA-00206: error in writing (block 4, # blocks 1) of control file
    ORA-00202: control file: '/oradata2/FOM1ORP1/FOM1ORP1_02.ctl'
    ORA-27061: waiting for async I/Os failed
    Linux-x86_64 Error: 5: Input/output error Additional information: -1 Additional information: 16384 Tue Feb 16 10:26:45 2010
    CKPT: terminating instance due to error 221 Tue Feb 16 10:26:45 2010 Errors in file /u01/app/oracle/admin/FOM1ORP1/bdump/fom1rp12_lms1_1983.trc:
    ORA-00221: error on write to control file #####
    

Environment

  • Red Hat Enterprise Linux (RHEL) 4
  • Hitachi storage array

  • Oracle software

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.