Thursday, July 31, 2008

ORA-00019: maximum number of session licenses exceeded

Problem Description
Normal user can't connect to oracle database. Whenever they try to connect to database it fails with ORA-00019.

SQL> conn india/a
ERROR:
ORA-00019: maximum number of session licenses exceeded

Solution of The Problem
1)Log on to database as a DBA user.
SQL> conn arju/a
Connected.

2)Check the license_max_sessions parameter.
SQL> show parameter license_

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

3)Increase the value of license_max_sessions parameter.
SQL> alter system set license_max_sessions=100;
System altered.

4)Test database to connect with the normal user.
SQL> conn india/a
Connected.

No comments:

Post a Comment