Thursday, July 6, 2017

/OA_HTML/AppsLocalLogin.jsp was not found in EBS 12.2


Issue:


Recently we performed clone of EBS 12.2 and post clone when we tried to launch our DMZ application we started seeing below error.

Not Found

The requested URL /OA_HTML/AppsLocalLogin.jsp was not found.

The primary node works without error. The issue is only with DMZ/Secondary node which has been added as part of the clone.

Fixes tried:
Tried to run "Generate Producte JAR Files" with force options.

Ran oJsp compilation as below

$ perl ojspCompile.pl --compile --flush -p 10 -log /tmp/ojspc_error.log

None of these helped.

Fix

Then later I realized that OA_HTML in EBS 12.2 is linked to oacore_server managed server via interface file mod_wl_ohs.conf.  Apache uses this file to identify where the application is residing at then get the information.

With this information, I verified the file mod_wl_ohs.conf in /config/OHS/ and noticed that it has entries as below

$ cat /u01/EBSDB/fs1/FMW_Home/webtier/instances/EBS_web_EBSDB_OHS2/config/OHS/EBS_web_EBSD/mod_wl_ohs.conf
LoadModule weblogic_module   "${ORACLE_HOME}/ohs/modules/mod_wl_ohs.so"
        DynamicServerList OFF
        
                SetHandler weblogic-handler
                WLCookieName JsessionIDEkanban
                WebLogicCluster ebsapp.local:6847
                WLTempDir ${ORACLE_INSTANCE}/tmp
       
       
                SetHandler weblogic-handler
                WebLogicCluster ebsapp.local:6847
                WLTempDir ${ORACLE_INSTANCE}/tmp
       
       
                SetHandler weblogic-handler
                WLCookieName JsessionIDYMS
                WebLogicCluster ebsapp.local:6847
                WLTempDir ${ORACLE_INSTANCE}/tmp
       

This file is missing key entries for OA_HTML. forms, etc., and thus apache is unable to redirect to actual EBS Login page. 

With this details, I added the information that is missing as below and then bounced apache services.

LoadModule weblogic_module   "${ORACLE_HOME}/ohs/modules/mod_wl_ohs.so"
        DynamicServerList OFF
        OA_HTML
>
                SetHandler weblogic-handler
                WebLogicCluster ebsapp.local:7247
                WLTempDir ${ORACLE_INSTANCE}/tmp
       
        forms
>
                SetHandler weblogic-handler
                WLCookieName JsessionIDForms
                WebLogicCluster ebsapp.local::7447
                WLTempDir ${ORACLE_INSTANCE}/tmp
       
        webservices
>
                SetHandler weblogic-handler
                WLCookieName JsessionIDOAFM
                WebLogicCluster hpebsdev20.hpinc.com:7647
                WLTempDir ${ORACLE_INSTANCE}/tmp
       
        formsclient
>
                SetHandler weblogic-handler
                WLCookieName JsessionIDFORMS-C4WS
                WebLogicCluster ebsapp.local::7847
                WLTempDir ${ORACLE_INSTANCE}/tmp
       
       
                SetHandler weblogic-handler
                WLCookieName JsessionIDEkanban
                WebLogicCluster hpebsdev20.hpinc.com:6847
                WLTempDir ${ORACLE_INSTANCE}/tmp
       
       
                SetHandler weblogic-handler
                WebLogicCluster ebsapp.local:6847
                WLTempDir ${ORACLE_INSTANCE}/tmp
       
       
                SetHandler weblogic-handler
                WLCookieName JsessionIDYMS
                WebLogicCluster ebsapp.local:6847
                WLTempDir ${ORACLE_INSTANCE}/tmp
       

Thank you.