Skip to content

FND_NO_DATABASE_CONNECTION in Oracle EBS R12

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.

 

[Post Views: 74]

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.

Be First to Comment

Leave a Reply

Required fields are marked *

error: Alert: Content is protected !!