Oracle Error ORA-00019 – maximum number of session licenses exceeded

Oracle Error Message

ORA-00019 – maximum number of session licenses exceeded

Reason for the Error

All licenses are in use. The session value’s upper limit was surpassed by the maximum number of licences.

Solution

There are few solutions to fix this problem

Check the license_max_sessions value using the below query

show parameter license_max_sessions

You can then Increase the value of the LICENSE MAX SESSIONS initialization parameter if you have more license for the session

ALTER SYSTEM SET license_max_sessions=10 scope=both;