RE: Profile limit concurrent sessions for a user not limiting as expected
Date: Wed, 17 Jan 2024 08:22:31 +0000
Message-ID: <PR1P264MB1824BD26EBC89798E8452F31F6722_at_PR1P264MB1824.FRAP264.PROD.OUTLOOK.COM>
Hi,
I make a little test, and it works as expected :
SQL> create profile proftest limit SESSIONS_PER_USER 2; SQL> alter user pierre profile proftest; SQL> alter system set resource_limit=true;
First session for PIERRE: OK
Second session for PIERRE : OK
Third session for PIERRE :
[oracle_at_vmoel8 ~]$ sqlplus pierre
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jan 17 09:13:09 2024
Version 19.18.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
Enter user-name: pierre
Enter password:
ERROR:
ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
Enter user-name: pierre
Enter password:
ERROR:
ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
So, I'm not able to connect more than 2 sessions with username PIERRE.
Are you sure you have defined RESOURCE_LIMIT to TRUE into your database because if it is defined to FALSE profile limits are not checked ?
Best regards.
Pierre
De : oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> de la part de Jack van Zanen <jack_at_vanzanen.com> Envoyé : mercredi 17 janvier 2024 03:57
À : oracle-l_at_freelists.org <oracle-l_at_freelists.org> Objet : Profile limit concurrent sessions for a user not limiting as expected
Hi
We have an application and want to limit the number of sessions a user can open so are experimenting with the profile and setting "Concurrent sessions(Per user)" set to 2
When I start the application I can see one session, so far so good. I can start another one and that works fine too..However on the third one is where things do not behave as I expected. I correctly get the pop up that the sessions have exceeded the value for concurrent max sessions. But when I click "ok" I get an application logon error popup. When I click that it starts a third session and logs into the application just fine and leaves me with 3 working sessions in the database for my username. I was hoping to get just the error popup and that would be it.
Can anyone explain under what conditions does oracle allow me to have 3 sessions when my max is set to 3?
database 12.2
Regards
Jack van Zanen
This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies.
Thank you for your cooperation
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 17 2024 - 09:22:31 CET