Remaining Sessions On DB Side When Datasource Fail to Start
(Doc ID 2587313.1)
Last updated on OCTOBER 02, 2024
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.
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
Changes
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 |