Oracle Learning Management Running Out Of Data Source Connections When Using Oracle Learning Management (OLM).
(Doc ID 2182945.1)
Last updated on FEBRUARY 01, 2019
Applies to:Oracle Learning Management - Version 12.2 HRMS RUP6 and later
Information in this document applies to any platform.
On : 12.2 HRMS RUP6 version, Content Admin
Database running out of connections when using Oracle Learning Management (OLM).
When using OLM, the database runs out of connections (session count climbs drastically) and the WebLogic console shows that it's done by the oacore_server Manager Servers.
Customer is experiencing the datasource connection problem only with Oracle Learning Management (OLM).
The quickest way to reproduce the problem is to enroll / un-enroll from courses, but any action in OLM seems to cause the problem.
No significant datasource connection increases have been observed in in Production environment when business started defining the course catalogue.
The problem seems to be related to the "My Current Enrollments" section of the "My Learning Home Page" screen.
Every time the learner navigates to this screen, and/or scroll down the "My Current Enrollment" section, the datasource connections increase quite a bit, 10 to 15 connections at a time. It is from this section that they enroll/un-enroll and play courses.
The issue can be reproduced at will with the following steps:
The quickest way to reproduce the problem is to enroll / unenroll from courses, but any action in OLM seems to cause the problem.
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