Oracle HTTP Server (OHS) can be used as a load balancer between two Oracle Forms and Reports environments. One of our customers had run into a error when using JRE 7 when logging into the Oracle Forms application. They were receiving the following error:
“FRM-93618: fatal error reading data from runtime process
Contact your system administrator.”
The production environment had the following multi-server architecture (NOTE: The error may occur if not using OAM as no errors were detected in the OAM or OID side):
Front-end Server (Point of entry for end-users):
- Oracle HTTP Server (11.1.2.1) (load balancing occurs here using forms.conf and mod_wl_ohs.conf) – Using SSL
Two Middle-Tier Servers
- Oracle Forms and Reports 11.1.2.1
- Oracle WebLogic Server 10.3.6
Back-end Infrastructure Server
- Oracle Internet Directory 11.1.1.5.0
- Oracle Access Manager 11.1.1.5.0
- Oracle WebLogic Server 10.3.5
The scenario was that the OHS and Forms/Reports environments were upgraded from 11.1.2.0 to 11.1.2.1 in order to support the use of Java 7 (JRE 7) for end users. End-users would log into the front-end and would log into OAM (using single sign-on). After the user is authenticated in OAM, the user would be directed (by a round-robin approach) to one of the two middle-tier servers where the Oracle Forms application is. However, if the user used JRE 6, they could access Forms without a problem. If the user used JRE 7, the FRM-93618 error appeared instead, preventing the user from continuing. Whenever a direct connection to the middle-tier server was performed (again using OAM to authenticate), no errors would occur regardless of the JRE used.
SOLUTION:
The load balancing in OHS for Oracle Forms is performed using forms.conf (located in %ORACLE_INSTANCE%\config\OHS\ohs1\moduleconf). A parameter called “CookieTracking” needs to be set to “On” within the <Location /forms> tags. In order to apply this, you will need to do the following steps:
- Make a backup of forms.conf in the load balancing server
- Open up forms.conf in a text editor
- Locate <Location /forms>. In between this tag and the </Location> tag, add the following parameter: CookieTracking On
- Save and close the file
- Restart OHS (the load balancing server)
After applying the above changes, FRM-93618 will no longer appear when using JRE 7. This will work using the Internet Explorer, Firefox, and Chrome browsers.