[Troubleshooting] Forms Issue: FRM-92050 failed to connect to server:forms/servlet

This post covers Oracle Forms issue ‘FRM-92050: Failed to connect to the Server:/forms/lservlet-1’, reported by one of our trainee from Oracle AppsDBA Training.

So let’s first understand about Oracle Forms, it can be configured in two modes: servlet and socket.

In servlet mode, a Java servlet (called the Forms Listener servlet) manages the communication between the Forms Java client and the OracleAS Forms services. In socket mode, the desktop clients access the Forms server directly.

To know more about Oracle Forms check our post Oracle Apps R12 Forms : Servlet or Socket

Issue: trainee was using servlet mode and trying to open Oracle Forms but getting error as below

Error in logs: $LOG_HOME/ora/10.1.3/j2ee/forms/forms_default_group_1/application.log

Note: Kindly refer this post to know more about log file location in R12.2 Oracle Apps R12.2 Log Files Location every Apps DBA must know

18/09/04 19:42:18.562 formsweb: Servlet error

java.lang.UnsatisfiedLinkError: no frmjsl in java.library.path

        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1744)

        at java.lang.Runtime.loadLibrary0(Runtime.java:823)

        at java.lang.System.loadLibrary(System.java:1026)

        at oracle.forms.servlet.RunformProcess.loadLibrary(Unknown Source)

        at oracle.forms.servlet.RunformProcess.<init>(Unknown Source)

        at oracle.forms.servlet.RunformProcess.<init>(Unknown Source)

        at oracle.forms.servlet.RunformSession.<init>(Unknown Source)

        at oracle.forms.servlet.RunformSession.get(Unknown Source)

        at oracle.forms.servlet.ListenerServlet.getRunformSession(Unknown Source)

        at oracle.forms.servlet.ListenerServlet.getInfo(Unknown Source)

        at oracle.forms.servlet.ListenerServlet.doGet(Unknown Source)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.invoke

(ServletRequestDispatcher.java:713)

        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.forwardInternal

(ServletRequestDispatcher.java:370)

        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.doProcessRequest

(HttpRequestHandler.java:871)

        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.processRequest

(HttpRequestHandler.java:453)

        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run

(AJPRequestHandler.java:313)

        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run

(AJPRequestHandler.java:199)

This error can happen for multiple reasons. Here we are troubleshooting two of them:

Cause I: This is due to a missing file – “libfrmjsl.sl” file under ORACLE_HOME/lib

Solution:

1. Make sure $ORACLE_HOME/lib32 should be the first entry in the LIBPATH variable value under the
OC4J_BI_FORMS process-type section in the opmn.xml file.
2. Restart the middle tier services using the following command
     opmnctl stopall
     opmnctl startall

Cause II:  SSL terminating on Load Balancer using reverse proxy and all the users would be accessing EBS through https and the flow is as follows

Step1: 
User => https://mtyebs.domainname:443
Note: Here mtyebs is our Load Balancer name. Here the request is identified as EBS request and LBR forwards that URL to our reverse proxy sever

Step2:
Our reverse proxy server is Sun http web server 7 update 5. It converts it to http://hostname.domainname:8000 and offloads it to the apps tier.

But when trying to launch any form, it gives the below error:

FRM-92050: Failed to connect to Server: /forms/lservlet-1 

Solution:

1. Insert header for back-end LB
LB: mtyebs.domain.com
2. enable proxypreservehost in RP
ProxyPreserveHost On

We have a dedicated module on Security in EBS (SSL/TLS &DMZ Setup) in our Oracle AppsDBA: Advance training.

Related/Further Readings:

• FRM-92050 java.lang.UnsatisfiedLinkError: no frmjsl in java.library.path (Doc ID 438522.1)
• Mandatory Patches for Forms versions 11.1.1.2 to 11.1.2.2 on Unix platforms (Doc ID 1431404.1)
• FRM-92050 (Doc ID 2302649.1)
• FRM-92050 Forms Are Not Opening. (Doc ID 2144589.1)
• Error FRM-92050 When Trying To Open A Form After Clone Of 12.2.4 (Doc ID 2099590.1)
• R12 E-Business Suite Applications Technology Stack Forms Fail With Error “FRM-92050: Failed to connect to the Server: /forms/lservlet: -1” After Upgrading JDK (Doc ID 1175400.1)
• FRM-92050: Failed To Connect To The Server :/forms/lservlet -1 Accessing Oracle Applications Using F5 Load Balancer (Doc ID 1571689.1)
• Oracle Forms and Oracle E-Business Suite Support
• Oracle AppsDBA (R12.2) Training : Step by Step Activity Guides /Hands-On Lab Exercise
• Our course Oracle Apps DBA (R12.2) Training

If you are new to Oracle AppsDBA or already working as Apps DBA but on version 11i or R12.1 then I suggest you first go through  below FREE videos from Oracle ACE, Author, and Oracle Apps Expert Atul Kumar

• [Video] Oracle Apps DBA (R12.2) Architecture
• [Video] Oracle Apps DBA (R12.2) Installation: FREE Training
• [Video] File System in Oracle E-Business Suite R12.2: Dual, APPL_TOP, INST_TOP, COMMON_TOP, FMW_HOME
• [Video] Oracle Apps DBA (R12.2) Services: Start/Stop
• [Video] Oracle Apps DBA (R12.2) Patching (ADOP): FREE Training

Next Task For You

We cover Oracle E-Business R12.2 Architecture & concepts in our Oracle Apps DBA For Beginners Training along with the Installation, Patching, Cloning, and Troubleshooting and also, Database upgrade to 19c  and much more including the hands-on labs you must perform to upgrade your skills and get a good job with a high package.

Begin your journey towards becoming an Apps DBA by joining our FREE Masterclass on How To Learn Oracle Apps DBA (R12) & It’s New Features.