Skip to content

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

 

 

 

[Post Views: 238]

Brijesh Gogia

I’m an experienced Oracle Applications DBA with more than a decade of full-time DBA experience. I have gained a wide knowledge of the Oracle software stack and have worked on several big projects for multi-national companies. I enjoy working with the leading-edge technology and have passion for database performance and stability. Thankfully my work allows me time for researching new technologies (and to write about them).
  
You can connect with me on LinkedIn.

One Comment

  1. Ashish Ashish

    Home page is coming but responsiblity not loading tried JSP compilation,JAR file regeneration, reload to db and all services bounced application and db still same issue, any suggestion?

Leave a Reply

Required fields are marked *

error: Alert: Content is protected !!