Also see following error messages:
EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
ORA-00019: maximum number of session licenses exceeded
Database administrators can set a hard limit for the amount of sessions allowed to connect to a database.
This is done when you are using Named User Licenses in order to prevent violation of your license agreement
First you can check at what value to limit is set to:
SQL> show parameter license NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ license_max_sessions integer 30 license_max_users integer 20 license_sessions_warning integer 20Next you can get the an overview of the current sessions connected to the database:
SQL> select count(*) from v$session;
COUNT(*)
----------
23
When the number of connected session is equal to the license_max_sessions, you will get this error message.
In order to resolve this error you will either need to buy extra licenses and up the license_max_sessions parameter, or disconnect some idle sessions using the following command:
alter session kill session 'sid, serial#';
Welcome to our forum for Oracle error: ORA-00019 Add your own message
Hi in my GL module i unable to open my periods.First i opened 3 months in GL module and i try to open the other periods after one week i unable to do so.My open periods screen greyed out .on that screen 3 periods are open status and two periods are Future entry.
Add your message
Ask Your Question
If you need more information about this particular error message, you can leave a forum message.
We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.
Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.
Spam Protection
In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.
If you do not enter the validation correctly, your message will not be recorded.
Forum Rules
Please be polite, do not USE ALL UPPERCASE, no insults, violance or any other threats.
