Forms / Reports 11g Intermittent FRM-92103 Or "Failure of Server APACHE Bridge" - OHS Log Shows "apr_socket_connect call failed" (Doc ID 1380762.1)

Last updated on FEBRUARY 27, 2017

Applies to:

Oracle Reports Developer - Version 11.1.2.0.0 and later
Oracle Forms - Version 11.1.2.0.0 and later
Oracle HTTP Server - Version 11.1.1.2.0 to 11.1.1.5.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***

Symptoms

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:

[2011-11-22T20:36:54.9189+00:00] [OHS] [ERROR:32] [OHS-9999] [mod_weblogic.c] [host_id: celvpint5309] [host_addr: 10.220.25.223] [pid: 3604] [tid: 1600] [user: SYSTEM] [VirtualHost: main] ap_proxy: trying GET /forms/frmservlet at backend host '10.220.25.223/0; got exception 'NO_RESOURCES: [os error=0, line 1915 of ../nsapi/URL.cpp]: apr_socket_connect call failed hostname:10.220.25.223:0 error [730049]'


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[0] SecurePort[0]
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 [730049]) raised at line 1915 of ../nsapi/URL.cpp

 

Note:

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) 11.1.1.4.0 or 11.1.1.5.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.

Changes

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.

Example:

<Location /forms>
SetHandler weblogic-handler
WebLogicCluster mymachine.oracle.com:9001
DynamicServerList OFF
</Location>

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