Share |

ORA-00019: maximum number of session licenses exceeded

You have reached the value of license_max_sessions.

Database administrators can set a hard limit for the amount of sessions allowed to connect to a database.
This is done when you are using Named User Licenses in order to prevent violation of your license agreement

First you can check at what value to limit is set to:
SQL> show parameter license

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
license_max_sessions                 integer     30
license_max_users                    integer     20
license_sessions_warning             integer     20
Next you can get the an overview of the current sessions connected to the database:
SQL> select count(*) from v$session;

  COUNT(*)
----------
        23
When the number of connected session is equal to the license_max_sessions, you will get this error message.
In order to resolve this error you will either need to buy extra licenses and up the license_max_sessions parameter, or disconnect some idle sessions using the following command:
alter session kill session 'sid, serial#';
 Was this information helpful?  Yes No
If it was not helpful, please take some time to explain why. This is not to ask questions, you can do so in the forum.

Welcome to our forum for Oracle error: ORA-00019 Add your own message



Hi in my GL module i unable to open my periods.First i opened 3 months in GL module and i try to open the other periods after one week i unable to do so.My open periods screen greyed out .on that screen 3 periods are open status and two periods are Future entry.

Add your message

 Please provide your personal info 



 Please ask your message as briefly and clear as possible 

 Spam Protection 
Validation Code: nk826678wpj5fxahs


Ask Your Question

If you need more information about this particular error message, you can leave a forum message.

We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.

Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.


Spam Protection

In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.

If you do not enter the validation correctly, your message will not be recorded.


Forum Rules

Please be polite, do not USE ALL UPPERCASE, no insults, violance or any other threats.