Oracle EBS R12 Appslogin showing http 404

One of our EBS R12 was inaccessible and was throwing generic http-404 erorr for the login page. On the application side adopmnctl was showing status ACTIVE for all the required procesees.

Simple HTML file like http://<server_name>:<port>/OA_HTML/test.html was also not opening means it was Apache issue or Oacore issue since definition of OA_HTML in html link is given by OACORE.

Error message in the Browser was like below:

Not Found

The requested URL /OA_HTML/test.html was not found on this server.

In one of the Apache server log we were able to see that it is trying to find the file under portal directory which is not the correct place

    </EXEC_CONTEXT_ID>
  </CORRELATION_DATA>
  <PAYLOAD>
    <MSG_TEXT>File does not exist: /fs01/<SID>/inst/apps/<CONTEXT_NAME>/portal/OA_HTML/test.html</MSG_TEXT>
  </PAYLOAD>
</MESSAGE>

We put extra debug on Apache by below method but didn’t find any issue.

Modified /fs01/<SID>/inst/apps/<CONTEXT_NAME>/ora/10.1.3/Apache/Apache/conf/httpd.conf and adding below entry

OraLogMode oracle
OraLogSeverity TRACE:32
OraLogDir /fs01/<SID>/inst/apps/<CONTEXT_NAME/logs/ora/10.1.3/Apache/oracle

Then we put extra debug on OACORE by below method:

Edited the j2ee-logging.xml adjust the following in file: $ORA_CONFIG_HOME/10.1.3/j2ee/oacore/config/j2ee-logging.xml

<logger name='oracle' level='TRACE:32' useParentHandlers='false'>

This time it produced below error message in the oacorestd.out file under

/fs01/<SID>/inst/apps/<CONTEXT_NAME>/logs/ora/10.1.3/opmn/oacore_default_group_1

error: error reading /fh04/<SID>/applcust/12App/xxdba/java/jar/xxdba6039_httpclient-4.3.5.jar; invalid END header (bad central directory offset)
error: error reading /fh04/<SID>/applcust/12App/xxdba/java/jar/xxdba6039_httpcore-4.3.2.jar; invalid END header (bad central directory offset)
2 errors

Looks like some bad custom jar file was uploaded to server which impacted the oacore to go into silent error. Oacore was showing as started normal but internally was not working.

We renamed the files and started oacore again to correct the issue.

-rwxrwxr-x   1 oaoracle  dba       590517 Dec 13 15:10 xxdba6039_httpclient-4.3.5.jar_bkp_14dec15

-rwxrwxr-x   1 oaoracle  dba       282266 Dec 13 15:10 xxdba6039_httpcore-4.3.2.jar_bkp_14dec15

Author
Recent Posts

Brijesh Gogia

I’m an experienced Cloud/Oracle Applications/DBA Architect with more than 15 years of full-time DBA/Architect experience. I have gained wide knowledge on Oracle and Non-Oracle software stack running on-prem and on Cloud and have worked on several big projects for multi-national companies. I enjoy working with leading-edge technology and have a passion for Cloud architecture, automation, database performance, and stability. Thankfully my work allows me time for researching new technologies (and to write about them).

Oracle EBS R12 Appslogin showing http 404

Related posts:

One Comment