Firewall BLACKOUT and JDBC connections with Oracle Applications 11i and 12
(Doc ID 276557.1)
Last updated on FEBRUARY 10, 2022
Applies to:Oracle Application Object Library - Version 18.104.22.168 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
This problem was initially reported during 11.5.9, but could effect any version of the E-Business Suite, including Release 12.
It is common in the advanced topologies to isolate the web tier(s) from the database tier(s) using one or more firewalls. A potential problem is that firewalls are typically configured to time out unused connections after one hour. With an E-Business suite instance, this can result in JDBC connections being disconnected without warning to the application. At this point, the connection is blacked out.
After the blackout has occurred, further JDBC activity causes an error to the application. The only recovery is to bounce iAS. The error seen from the user perspective can be any kind of error, but basically implies that there is no connection to the database.
The proxy server received an invalid response from an upstream server.
The proxy server could not handle the request GET /oa_servlets/AppsLogin.
Reason: Document contains no data
System Error - The JRAD runtime context cannot be found. Please login again, and report this to your system administrator.
Addition of firewalls between web tier(s) and database tier(s).
Decrease in firewall timeout value.
Decrease in user activity or wild fluctuation in user load.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!