ORA-00019 maximum number of session licenses exceeded

ORA-00019 maximum number of session licenses exceeded

Error:
ORA-00018 maximum number of sessions exceeded

SQL> conn hr@xepdb1
Enter password:
ERROR:
ORA-00019: maximum number of session licenses exceeded

Cause:
Maximum number of licenses session value exceeded to its upper limit.

Solution:
1. Check the parameter license_max_sessions value.

SQL> show parameter license_max_sessions

NAME                     TYPE     VALUE
------------------------ -------- --------
license_max_sessions     integer  1

2. If you have more license for session, you can increase this parameter value.

ALTER SYSTEM SET license_max_sessions=500 scope=both;

Note: Not need to reboot the Database.

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply