Gateway Process Gets Terminated Due To Idle Time Waiting For The Oracle Optimizer To Respond Back (Doc ID 2192583.1)

Last updated on FEBRUARY 01, 2017

Applies to:

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

Symptoms

The Oracle optimizer fetches data via the gateway. The Oracle optimizer must process the fetched data before asking for more.
During this process, the gateway is in an idle state waiting to hear back from the Oracle server.
Normally, this process works without issue but, on occasion, the optimizer takes longer than anticipated.
When this occurs, the gateway process may sit idle for more than the idle time limit, and the gateway process terminated terminated.
The Oracle server is ready to fetch more data but the gateway process has been terminated and the transaction errors out or causes a hung condition

Common errors include ORA-28500 and ORA-7445.

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