My Oracle Support Banner

Remaining Sessions On DB Side When Datasource Fail to Start (Doc ID 2587313.1)

Last updated on SEPTEMBER 15, 2021

Applies to:

Oracle WebLogic Server - Version 12.2.1.3.0 to 12.2.1.3.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

If a datasource fails to start but making some connections, the DBMS will show those sessions.

This Symptoms can be reproduced as below.

 1.Check db side processes value, it is 150.

SQL> show parameter processes
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
processes integer 150

2.Create a datasource, username is test, set Initial Capacity with 160 which is over processes value.

3.Restart server,datasource fails to start.

 

4.Check v$session on db side, there are some sessions which are not released.

SQL> select USERNAME from v$session where USERNAME='Test';

USERNAME
------------------------------
Test
Test
Test

......

113 rows selected.

5.Stop the server,then sessions are released as below.

SQL> select USERNAME from v$session where USERNAME='Test';

no rows selected

 

 

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.