oracle.apps.fnd.framework.OAException: Illegal method call because there is no database connection.

Problem Description:

Users intermittently facing issue logging into application. Getting error

Exception Details:

oracle.apps.fnd.framework.OAException: Illegal method call because there is no database connection.

Instance : 12.1.3 with 11.1.0.7.0 DB

More Details :

1) Already connected users will be able to use the application and new users trying to connnect are facing this issue.
2) Once we bounce the apache they are able to connect. But this happening bit frequently , every time bounce is not feasable.

Cause :

The root cause of the issue is that there was no database connection available to service your request. The most likely cause of that issue is that we are leaking JDBC connections.
However it can also occurr when the database is overloaded and unable to process our request quickly enough.

Provide the below info to Support:

1:- Please run the "AOL/J Database Connection Pool Status" page (under the System Administration responsibility)
a:- Upload a screenshot of the page
b:- Click the LEAKED CONNECTIONS link.
c:- Upload a screenshot (if there is a lot of text then upload the output in a text file)
d:- Click the back button
e:- Click the LOCKED CONNECTIONS link.
f:- Upload a screenshot (if there is a lot of text then upload the output in a text file)


Sol :

In our case

Server is running out of memory which is never good and is the first thing we need to correct.
Also there are large number of database cursor leaks, may be this happening because the server is running out of memory.

Possible Fixes :

1)  Since server is running out of memory - Add more RAM and re-test the issue

If still issue exists

1) gather CBO statistics for the SYS and SYSTEM schemas
2) run the "Gather Schema Statistics" concurrent program for ALL schema


UR's Key Run ;-)