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