IBM Support

Administration Console page hangs with a blank page and ORA-02391

Troubleshooting


Problem

When opening Administration Console, the page hangs and presented with a blank page. 
It also displays the message
ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit.

Resolving The Problem

Correct User_Sessions variable in the Audit schema.
Ensure the maximum pool size in the JIRA instance's dbconfig.xml file is not greater than the SESSIONS_PER_USER limit in Oracle. To do this:
  1. Check the dbconfig.xml under the property: <pool-max-size>. This value should be no smaller than the values documented in: 
  2. Check the SESSIONS_PER_USER setting is equal or higher than the maximum pool size. If this value is low, increase this limit or set the limit to UNLIMITED from the Oracle Database. 
  3.  Increased the sessions_per_user to 500
  4. Confirm that no other applications are connecting to the Oracle database using the same user.

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"11.0.12","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 April 2019

UID

ibm10879339

Page Feedback