Errors ORA-01115 ORA-1110 ORA-27091 ORA-27070 OSD-4006 Obtained When Inserting Data

(Doc ID 795603.1)

Last updated on MAY 12, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Microsoft Windows (32-bit)
Microsoft Windows Itanium (64-bit)
Microsoft Windows x64 (64-bit)
***Checked for relevance on 14-May-2013***

Symptoms

Inserting data with SQL*Loader started from an application in direct mode, e.g.:

options (parallel=false, direct=true, errors=0)
unrecoverable
load data
infile '<DATAFILE>'
append into table <TABLE>
fields terminated by '|'
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
    <FIELDNAME><,>
)


yields the following errors:

ORA-01115: IO error reading block from file 15
ORA-01110: data file …
ORA-27091: unable to queue I/O
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 121) The semaphore timeout period has expired.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms