JDE/Oracle SQL error: maximum number of sessions exceeded

JDE/Oracle SQL error: maximum number of sessions exceeded


Scenario:

After performing SQL actions (insert/select/update) a reoccurring error started to appear and some SQL actions error.

Issue:

All Oracle session state objects are in use.

EXTOL error message:


[ERROR] ORA-00018: maximum number of sessions exceeded



Resolution:

Request DBA make updates to the DB Settings for : Processes, Sessions, and Transactions.

  • Processes=500
  • Sessions=1000
  • Transactions=1200



By: on
A free web counter provided by GoStats.