ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
I'm useing Oracle 11g on the Linux operating system.On this computer I have installed an application made in Oracle APEX.
Error during execution of these applications is that the opening of every particular routines cause the opening of a new session on the Oracle database. Thus, a user have on the same aplikacji to 100 open sessions.
This causes an error:
ORA-2391 ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
I know that the Oracle database can change the parameter value SESSIONS_PER_USER in user profiles.
But this is not the correct solution.
The solution should be in the correct installation of Oracle IAS http service on the linux computer to act in such a way that one user for this application only one open session.
Error during execution of these applications is that the opening of every particular routines cause the opening of a new session on the Oracle database. Thus, a user have on the same aplikacji to 100 open sessions.
This causes an error:
ORA-2391 ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
I know that the Oracle database can change the parameter value SESSIONS_PER_USER in user profiles.
But this is not the correct solution.
The solution should be in the correct installation of Oracle IAS http service on the linux computer to act in such a way that one user for this application only one open session.
0