High number of Oracle Database Link remote sessions and ORA-02020 when using JBoss EAP
Issue
- Using Oracle Database Link (aka DBLink) for certain queries
- After these queries, remote sessions are left open in the database until the connection is closed
- Encountering
ORA-02020: too many database links in use
Environment
- Red Hat JBoss Enterprise Application Platform (EAP)
- 7
- 6
- Oracle
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.