How to identify DB connection problems ? (Doc ID 797483.1)

Last updated on MAY 03, 2016

Applies to:

Oracle Applications Technology Stack - Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 10-April-2013***

Goal

How to identify, that the DB in an EBS Environment is running out of resources, like reaching the limits of connections ?

Some symptoms are :

Bouncing the Web Server appears to eliminate the issue temporarily. Users continue to encounter the same problem with requests after bouncing the Concurrent Manager.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms