This content has been marked as final. Show 7 replies
No of Concurrent Sessions Per User Mismatch with profile settings
you need to do:
alter system set resource_limit=true;
now its working
SQL> conn / as sysdba Connected. SQL> SQL> SQL> SQL> alter system set resource_limit=true; System altered. SQL> conn system/oracle@xe ERROR: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit Warning: You are no longer connected to ORACLE. SQL>
Edited by: Niket Kumar on Jan 17, 2013 6:34 PM
Edited by: Niket Kumar on Jan 17, 2013 6:35 PM
How long have you been on this board? How many times have you read this:
This forum is not a chat line, and it is not paid support.
Everyone here has a job for which they are paid, and this forum is not it.
No one is responsible for monitoring it and giving a quick response.
Furthermore, it is a global forum. The person with the information you seek may very well live 20 time zones away from you and was going to bed just as you posted. He will not even see your post for several more hours.
Your original post went up in the middle of the night for half the world.
*No one with the information you seek is deliberately withholding it until you sound sufficiently desperate.*