 Posted 3/5/2009 11:06:44 AM
|
|
|
|
When you try to connect to the database you get the following ora error message:
SQL> conn ecom/
ERROR:
ORA-00019: maximum number of session licenses exceeded
Oracle Error :: 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.
Here is how to fix it:
Login to the database as DBA account:
SQL> connect / as sysdba;
Connected.
You need to check your parameter called: license_max_sessions:
SQL> show parameter license_max_sessions
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
license_max_sessions integer 5
Increase the value of this parameter to say something like 150:
SQL> alter system set license_max_sessions=150;
System altered.
Test the connection to the user again:
SQL> connect ecom/
Connected.
That's all folks.
This is just to immediately fix your problem. You need to take a look in depth at your environment and set the appropriate value. Oracle do***entation states that:
LICENSE_MAX_SESSIONS specifies the maximum number of concurrent user sessions allowed. When this limit is reached, only users with the RESTRICTED SESSION privilege can connect to the database. Users who are not able to connect receive a warning message indicating that the system has reached maximum capacity.
A zero value indicates that concurrent usage (session) licensing is not enforced. If you set this parameter to a nonzero number, you might also want to set LICENSE_SESSIONS_WARNING (see "LICENSE_SESSIONS_WARNING").
Do not enable both concurrent usage licensing and user licensing. Set either LICENSE_MAX_SESSIONS or LICENSE_MAX_USERS to zero.
I hope this topic helps.
|
|
|
|