Higher Number of Database (DB) Connections Reported After OID is Patched to 11.1.1.7.3 Bundle Patch. Alert Log Error: ORA-00020 maximum number of processes (xxxxx) exceeded
(Doc ID 2034523.1)
Last updated on OCTOBER 31, 2019
Applies to:
Oracle Internet Directory - Version 11.1.1.7.3 and laterInformation in this document applies to any platform.
Symptoms
A higher number of database (DB) connections are reported since Oracle Internet Directory (OID) is patched to 11.1.1.7.3 Bundle Patch (reference <Document 1614114.1> / <Patch 20444775>).
Experiencing a higher number of DB connections since OID bundle patch application. The problem was reported by the Enterprise Manager (EM) Cloud Control as a critical issue, e.g.:
Host=<OID HOSTNAME>
Target type=Oracle Internet Directory
Target name=/idm_1/oid1
Incident creation time=8-Jul-2015 12:43:41 AM EDT
Last updated time=8-Jul-2015 12:43:41 AM EDT
Message=LDAP Open DB Connections 32 crossed warning (20) or critical (30) threshold
Severity=Critical
Incident ID=277164
Event count=1
Incident Status=New
Escalated=No
Priority=None
Incident owner=
Incident Acknowledged By Owner=No
Categories=Load
Rule Name=NotificationRule_SupportOracle,Sending email alerts DTI Oracle Grid
Rule Owner=SYSMAN
Update Details:
Incident created by rule (Name = Incidents_TestApp, Create incident for critical metric alerts; Owner = SYSMAN).
Target type=Oracle Internet Directory
Target name=/idm_1/oid1
Incident creation time=8-Jul-2015 12:43:41 AM EDT
Last updated time=8-Jul-2015 12:43:41 AM EDT
Message=LDAP Open DB Connections 32 crossed warning (20) or critical (30) threshold
Severity=Critical
Incident ID=277164
Event count=1
Incident Status=New
Escalated=No
Priority=None
Incident owner=
Incident Acknowledged By Owner=No
Categories=Load
Rule Name=NotificationRule_SupportOracle,Sending email alerts DTI Oracle Grid
Rule Owner=SYSMAN
Update Details:
Incident created by rule (Name = Incidents_TestApp, Create incident for critical metric alerts; Owner = SYSMAN).
Potential DB alert log error:
ORA-00020 maximum number of processes (xxxxx) exceeded
Changes
Applied Bundle Patch 11.1.1.7.3.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |