My Oracle Support Banner

JDBC Thin Client Sessions Piling Up on Database and Sessions are not Getting Closed (Doc ID 2668703.1)

Last updated on MAY 14, 2020

Applies to:

Oracle WebLogic Server - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

After upgrading the Oracle Weblogic Server from 10.3.5 to 12.2.1.3 and Oracle Database from 11.2.0.3 to 12c database (12.2.1.0.0), the JDBC sessions are piling up on the database and this is causing the process handlers to get exhausted on the Database. 

The v$session shows there are more than 3000 sessions active on the database. After the sessions have been analyzed, it has been found that these sessions are related JDBC thin clients.

The environment has the below architecture:

Weblogic JDBC Datasources ---> Third party Connector ---> Oracle Database

Between the Weblogic datasource and the Database, there is a third party connector which first receives the datasource connection and associates the JDBC connection with a thread. This thread along with the JDBC connection are routed to the Database.

 

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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.