Gateway Process Gets Terminated Due To Idle Time Waiting For The Oracle Optimizer To Respond Back
(Doc ID 2192583.1)
Last updated on MAY 11, 2022
Applies to:
Oracle Database Gateway for Informix - Version 10.2.0.5 to 12.1.0.2 [Release 10.2 to 12.1]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]
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |