Forms / Reports 11g Intermittent FRM-92103 Or "Failure of Server APACHE Bridge" - OHS Log Shows "apr_socket_connect call failed"
Last updated on FEBRUARY 27, 2017
Applies to:Oracle Reports Developer - Version 184.108.40.206.0 and later
Oracle Forms - Version 220.127.116.11.0 and later
Oracle HTTP Server - Version 18.104.22.168.0 to 22.214.171.124.0 [Release Oracle11g]
Oracle Retail Central Office - Version 13.4.8 to 13.4.8 [Release 13.4]
Information in this document applies to any platform.
***Checked for relevance on 10-JAN-2014***
Forms or Reports 11g intermittently fails with an "Failure of Server APACHE Bridge" error in the browser or a FRM-92103 error in the form.
To resume normal working, the OHS component in the Forms / Reports technology stack has to be stopped and restarted.
The following errors are logged in <instance home>\diagnostics\logs\OHS\ohs1\ohs1.log file:
If mod_wl_ohs debug is enabled as per
<Note: 967889.1> How to View Oracle HTTP Server 11g MOD_WL_OHS Routing and Other Debug Information?
the following errors are logged in the mod_wl_ohs debug log:
Tue Nov 22 15:39:55 2011 <1332132197639555> trying connect to PRIMARY '10.10.10.10'/0/0
Tue Nov 22 15:39:55 2011 <1332132197639555> getPooledConn: found a host and port/securePort match
Tue Nov 22 15:39:55 2011 <1332132197639555> getPooledConn: No more connections in the pool for Host[10.10.10.10] Port SecurePort
Tue Nov 22 15:39:55 2011 <1332132197639555> getConnection: Obtained a URL object from factory
Tue Nov 22 15:39:55 2011 <1332132197639555> getConnection: Setting properties on URL object
Tue Nov 22 15:39:55 2011 <1332132197639555> *******Exception type [NO_RESOURCES] (apr_socket_connect call failed hostname:10.10.10.10:0 error ) raised at line 1915 of ../nsapi/URL.cpp
The error is not specific to Forms / Reports 11.1.2 installations. It can be reproduced also on any Fusion Middleware Installation using OHS (Oracle HTTP Server) 126.96.36.199.0 or 188.8.131.52.0 . If unsure if your version is affected, run <ORACLE_HOME>\OPatch\opatch lsinventory -detail and check the "Patch of Oracle HTTP Server 2.0" version.
At configuration time, the WebLogic cluster option was chosen, and consequently the HTTP Server configuration file, containing the MOD_WL_OHS settings, has the directive WebLogicCluster
In the case of Forms / Reports this parameter is found in the forms.conf and reports_ohs.conf respectively.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms