R12: Login was Failing Intermittently With Error “oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_DATABASE_CONNECTION”
Or getting below error when trying to access EB R12 login page.
Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance.
Below steps have helped us in sorting out this issue.
1) Stop all application services 2) Recompile jsp pages cd $FND_TOP/patch/115/bin $ perl ojspCompile.pl --compile --flush -p 8 3) Start all Application Services and test the issue again.
with -p flag you can define number of parallel workers for the JSP Compilation and can reduce the compilation time
Remember below points if you have multi-node application system:
- If you are not using a shared APPL_TOP then you can run the ojspcompile scripts at the same time across multiple web tiers.
- If you are using a Shared APPL_TOP then running the ojspcompile scripts at the same time could cause conflict/locks at the Operating System level, so is not recommended.
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).
Latest posts by Brijesh Gogia (see all)
- Oracle Multitenant DB 4 : Parameters/SGA/PGA management in CDB-PDB - July 18, 2021
- Oracle Multitenant DB 3 : Data Dictionary Architecture in CDB-PDB - March 20, 2021
- Oracle Multitenant DB 2 : Benefits of the Multitenant Architecture - March 19, 2021