Skip to content

ORA-00019: maximum number of session licenses exceeded

ORA-00019: maximum number of session licenses exceeded

Cause: All licenses are in use.
Action: Increase the value of the LICENSE MAX SESSIONS initialization parameter.



elated: 	<<View:V$LICENSE>>
  Users received ORA-19 if they are not allowed to connect.
  Eg:  ORA-19 "maximum number of session licenses exceeded"
  Messages are written to the alert log for each connect attempt made once 
  Eg: If the user has RESTRICTED SESSION privilege:
             "License maximum (10) exceeded, DBA logon allowed"

      If the user was refused from connecting:
             "Non-DBA logon denied; current logons equal maximum (10)"


No comments yet

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: