Unexpected Network Error ErrNum = 10054 {08S01}[Oracle][ODBC Wire Protocol Driver] For Any Gateway

(Doc ID 2074250.1)

Last updated on NOVEMBER 05, 2015

Applies to:

Oracle Database Gateway for Informix - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]
Oracle Database Gateway for Teradata - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]
Oracle Database Gateway for SQL Server - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]
Oracle Database Gateway for DRDA - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]
Oracle Database Gateway for Sybase - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

Using version 11.2.0.x or higher of any gateway on any platform an application has intermittent errors similar to the following when run as scheduled job -

*** MODULE NAME:(DBMS_SCHEDULER) 2015-11-01 09:44:24.119
*** ACTION NAME:(LOAD_DATA) 2015-11-01 09:44:24.119
 
ORA-12012: error on auto execute of job "PROD"."LOAD_DATA"
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC Informix Wire Protocol driver]Socket closed. {08S01}[Oracle][ODBC Informix Wire Protocol driver]Unexpected Network Error. ErrNum = 10054 {08S01}[Oracle][ODBC Informix Wire Protocol driver]Unexpected Network Error. ErrNum = 10054 {08S01}[Oracle][ODBC Informix Wire Protocol driver]Unexpected Network Error. ErrNum = 10054 {08S01}[Oracle][ODBC Informix Wire Protocol driver]Unexpected Network Error. ErrNum = 10054 {08S01}

An ORA-7445 error could also result from this.

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