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>>
                <<Parameter:LICENSE_SESSIONS_WARNING>>
                <<Parameter:LICENSE_MAX_USERS>>
        
  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 
  LICENSE_MAX_SESSIONS is reached.
  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:

WordPress.com Logo

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

Google photo

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

Twitter picture

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

Facebook photo

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

Connecting to %s

%d bloggers like this: