Forum Stats

  • 3,733,249 Users
  • 2,246,737 Discussions
  • 7,856,634 Comments

Discussions

O/S-Error: (OS 1117) The request could not be performed because of an I/O device error

ivwvi
ivwvi Member Posts: 971

Dear Experts,

I am facing this error in 500G table on  win 2008 R2        64 bit RAM

nothing in alert log or v$recover_file

Oracle Database 11g  11.2.0.1.0 - 64bit 
SQL> create index  L_3__SERIALIZED  on   L_3_PV_TD_LINE_ITEMS_FF_REL_2 (SERIALIZ
ED)  parallel 16 nologging;
create index  L_3__SERIALIZED  on   L_3_PV_TD_LINE_ITEMS_FF_REL_2 (SERIALIZED)
parallel 16 nologging
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P015
ORA-01115: IO error reading block from file 115 (block # 967936)
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1117) The request could not be performed because of an I/O
device error.
ORA-01115: IO error reading block from file 115 (block # 967936)
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1117) The request could not be performed because of an I/O
device error.

Thanks for help

Best Answer

Answers

  • Hemant K Chitale
    Hemant K Chitale Member Posts: 15,755 Blue Diamond

    If your database instance parameter db_files is 100, file 115 is the 15th temp (tablespace) file.  So, the I/O error is on a tempfile. Investigate the tempfiles (DBA_TEMP_FILES or V$TEMPFILE).

    Hemant K Chitale

    Hemant K Chitale
  • ivwvi
    ivwvi Member Posts: 971

    Hemant,

    thanks for reply

    File is this

    FILE#                         : 115
    CREATION_CHANGE#              : 2034139
    CREATION_TIME                 : 23-oct-2013 13:05:50
    TS#                           : 4
    RFILE#                        : 115
    STATUS                        : ONLINE
    ENABLED                       : READ WRITE
    CHECKPOINT_CHANGE#            : 519534565
    CHECKPOINT_TIME               : 11-feb-2014 21:08:53
    UNRECOVERABLE_CHANGE#         : 0
    UNRECOVERABLE_TIME            :
    LAST_CHANGE#                  :
    LAST_TIME                     :
    OFFLINE_CHANGE#               : 0
    ONLINE_CHANGE#                : 0
    ONLINE_TIME                   :
    BYTES                         : 32212254720
    BLOCKS                        : 3932160
    CREATE_BYTES                  : 32212254720
    BLOCK_SIZE                    : 8192
    NAME                          : E:\ORADATA\ORCL\USERS118.DBF
    PLUGGED_IN                    : 0
    BLOCK1_OFFSET                 : 8192
    AUX_NAME                      : NONE
    FIRST_NONLOGGED_SCN           : 0
    FIRST_NONLOGGED_TIME          :
    FOREIGN_DBID                  : 0
    FOREIGN_CREATION_CHANGE#      : 0
    FOREIGN_CREATION_TIME         :
    PLUGGED_READONLY              : NO
    PLUGIN_CHANGE#                : 0
    PLUGIN_RESETLOGS_CHANGE#      : 0
    PLUGIN_RESETLOGS_TIME       
    

    db_files

    NUM                           : 899
    NAME                          : db_files
    TYPE                          : 3
    VALUE                         : 400
    DISPLAY_VALUE                 : 400
    ISDEFAULT                     : FALSE
    ISSES_MODIFIABLE              : FALSE
    ISSYS_MODIFIABLE              : FALSE
    ISINSTANCE_MODIFIABLE         : FALSE
    ISMODIFIED                    : FALSE
    ISADJUSTED                    : FALSE
    ISDEPRECATED                  : FALSE
    ISBASIC                       : FALSE
    DESCRIPTION                   : max allowable # db files
    UPDATE_COMMENT                :
    HASH                          : 314572703
    

    error

    SQL> create index  L_3__SRVC_PRTNER_SITE_PRTY_KEY  on   L_3_PV_TD_LINE_ITEMS_FF_
    REL_2 (SRVC_PARTNER_SITE_PARTY_KEY)  parallel 16 nologging;
    create index  L_3__SRVC_PRTNER_SITE_PRTY_KEY  on   L_3_PV_TD_LINE_ITEMS_FF_REL_2
     (SRVC_PARTNER_SITE_PARTY_KEY)  parallel 16 nologging
    *
    ERROR at line 1:
    ORA-12801: error signaled in parallel query server P040
    ORA-01115: IO error reading block from file 115 (block # 827904)
    ORA-27070: async read/write failed
    OSD-04016: Error queuing an asynchronous I/O request.
    O/S-Error: (OS 1117) The request could not be performed because of an I/O
    device error.
    ORA-01115: IO error reading block from file 115 (block # 827904)
    ORA-27070: async read/write failed
    OSD-04016: Error queuing an asynchronous I/O request.
    O/S-Error: (OS 1117) The request could not be performed because of an I/O
    device error.
    
  • Hemant K Chitale
    Hemant K Chitale Member Posts: 15,755 Blue Diamond

    You have an I/O error on a USERS tablespace datafile.  You should check the OS and Storage logs for error messages.

    Hemant K Chitale

  • ivwvi
    ivwvi Member Posts: 971

    this block is a table block

    select segment_name||chr(10)||partition_name c1, segment_type c2, block_id c3,

    block_id+blocks c4

    C1                            : L_3_PV_TD
    C2                            : TABLE
    C3                            : 966784
    C4                            : 974976
    

    I see event vewiwer>windows logs> system>

    The driver detected a controller error on \Device\Ide\IdePort2.

    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    -<System>
    <ProviderName="atapi" />
    <EventID Qualifiers="49156">11</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreatedSystemTime="2014-02-12T05:42:40.670294400Z" />
    <EventRecordID>41755</EventRecordID>
    <Channel>System</Channel>
    <Computer>WIN-2DMH9QVD6H8</Computer>
    <Security/>

    </System>

    -<EventData>
    <Data>\Device\Ide\IdePort2</Data>
    <Binary>0000100001000000000000000B0004C002000000850100C00000000000000000000000000000000000000000000000000000000004100000</Binary>

    </EventData>

    </Event>

  • Hemant K Chitale
    Hemant K Chitale Member Posts: 15,755 Blue Diamond

    So you need to follow up with the hardware team to see if the problem can be isolated and resolved.

    In the meantime, you could try an RMAN backup and check v$database_block_corruption.

    Hemant K Chitale


  • ivwvi
    ivwvi Member Posts: 971

    Hi,

    Please help

    Should I create new table in different tablespace.

    Or It can be fixed?

    error now

    SQL> create index  L_3__SERIALIZED  on   L_3_PV_TD_LINE_ITEMS_FF_REL_2 (SERIALIZ
    ED)  parallel 8 nologging;
    create index  L_3__SERIALIZED  on   L_3_PV_TD_LINE_ITEMS_FF_REL_2 (SERIALIZED)
    parallel 8 nologging
    *
    ERROR at line 1:
    ORA-12801: error signaled in parallel query server P014
    ORA-01115: IO error reading block from file  (block # )
    ORA-01110: data file 113: 'E:\ORADATA\ORCL\USERS116.DBF'
    ORA-27070: async read/write failed
    OSD-04006: ReadFile() failure, unable to read from file
    O/S-Error: (OS 1117) The request could not be performed because of an I/O
    device error.
    
  • Hemant K Chitale
    Hemant K Chitale Member Posts: 15,755 Blue Diamond
    Accepted Answer

    No, I cannot help you.  Check with your server and storage team to see if the I/O problem can be isolated and corrected.

    Hemant K Chitale


This discussion has been closed.