Home » SQL & PL/SQL » SQL & PL/SQL » ORA-2391: exceeded simultaneous SESSIONS_PER_USER limit (Oracle 10.2.03)
ORA-2391: exceeded simultaneous SESSIONS_PER_USER limit [message #297809] Sun, 03 February 2008 21:21 Go to next message
anbazrws
Messages: 2
Registered: February 2008
Location: singapore
Junior Member
Hi All,

I am using Oracle 10.2.03 database with asp.net 1.1 web application,

My application deployed on the production, but I got the Oracle Error:

ORA-2391: exceeded simultaneous SESSIONS_PER_USER limit

Can I have suitable remedy for this error?

Thanks & regards,

Anbaz,
Singapore.

Re: ORA-2391: exceeded simultaneous SESSIONS_PER_USER limit [message #297811 is a reply to message #297809] Sun, 03 February 2008 21:36 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8633
Registered: November 2002
Location: California, USA
Senior Member
The following is from the online documentation:

ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
Cause: An attempt was made to exceed the maximum number of concurrent sessions allowed by the SESSION_PER_USER clause of the user prfile.
Action: End one or more concurrent sessions or ask the database administrator to increase the SESSION_PER_USER limit of the user profile.
Re: ORA-2391: exceeded simultaneous SESSIONS_PER_USER limit [message #297813 is a reply to message #297811] Sun, 03 February 2008 21:43 Go to previous messageGo to next message
anbazrws
Messages: 2
Registered: February 2008
Location: singapore
Junior Member
Hi Barbara Boehmer,

Already we set the SESSION_PER_USER limit of the user profile is 80,

So concurrently 80 users session may occur.

But still we get the same error.


thanks & regards,
Anbaz,
Singapore.

Re: ORA-2391: exceeded simultaneous SESSIONS_PER_USER limit [message #297851 is a reply to message #297813] Mon, 04 February 2008 00:24 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8633
Registered: November 2002
Location: California, USA
Senior Member
Perhaps you have something that is starting sessions without exiting them. Try to identify how so many sessions are open at the same time.
Re: ORA-2391: exceeded simultaneous SESSIONS_PER_USER limit [message #599910 is a reply to message #297851] Wed, 30 October 2013 02:57 Go to previous messageGo to next message
sss111ind
Messages: 563
Registered: April 2012
Location: India
Senior Member

I was trying to execute a procedure over db connection but got the error.
Why this error occurs and how to resolve it. And if some session open then how to close it.

[Updated on: Wed, 30 October 2013 02:59]

Report message to a moderator

Re: ORA-2391: exceeded simultaneous SESSIONS_PER_USER limit [message #599913 is a reply to message #599910] Wed, 30 October 2013 03:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

If you don't tell us what you actually did and got we can't help you.
With 365 posts you should know it.
For instance, why is this in this topic and why didn't you create a new one?

Re: ORA-2391: exceeded simultaneous SESSIONS_PER_USER limit [message #602836 is a reply to message #599913] Mon, 09 December 2013 10:19 Go to previous messageGo to next message
sss111ind
Messages: 563
Registered: April 2012
Location: India
Senior Member

Can anyone please help me to resolve the above issue. I got the following error.
 ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit 
Re: ORA-2391: exceeded simultaneous SESSIONS_PER_USER limit [message #602837 is a reply to message #602836] Mon, 09 December 2013 10:27 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Reduce the number if open sessions or get the dba to increase the parameter value mentioned above.
Re: ORA-2391: exceeded simultaneous SESSIONS_PER_USER limit [message #603406 is a reply to message #602837] Mon, 16 December 2013 00:41 Go to previous messageGo to next message
sss111ind
Messages: 563
Registered: April 2012
Location: India
Senior Member

Hi All,

We are USING A dblink TO get THE DATA AND showing A report.But sometime it IS throwing AS follows AND THE whole PACKAGE got invalidated.
And after this we have to compile it manullay to get the package work correct.
Error(1): ORA-04052: error occurred when looking up remote object relSTA.srt@alr_dblink
ORA-00604: ERROR occurred AT recursive SQL LEVEL 1
ORA-02391: exceeded simultaneous SESSIONS_PER_USER LIMIT
ORA-02063: preceding line from alr_dblink

Why THE above ERROR IS happening AT regular basis AND how can it resolved. What IS MAIN cause OF THE above ERROR.
IF we have reached THE MAX SESSIONS_PER_USER THEN we can NOT increase more that its MAX. What IS THE necessary action
must be take care of. Please help I am in big trouble here.

Regards,
Nathan
Re: ORA-2391: exceeded simultaneous SESSIONS_PER_USER limit [message #603418 is a reply to message #603406] Mon, 16 December 2013 01:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
  *Cause: An attempt was made to exceed the maximum number of
          concurrent sessions allowed by the SESSION_PER_USER clause
          of the user profile.
  *Action: End one or more concurrent sessions or ask the database
           administrator to increase the SESSION_PER_USER limit of
           the user profile.
Re: ORA-2391: exceeded simultaneous SESSIONS_PER_USER limit [message #604674 is a reply to message #603418] Thu, 02 January 2014 10:40 Go to previous message
sss111ind
Messages: 563
Registered: April 2012
Location: India
Senior Member

The problem was like

CREATE OR REPLACE procedure p_link_test(p_deptno in number,c_emp_details out sys_refcursor) IS
begin
OPEN c_emp_details FOR SELECT * FROM emp@db_link;
end ;

variable c_emp_details refcursor;
set autoprint on;
BEGIN
p_link_test(10,:c_emp_details);
end;



The procedure p_link_test is called from a different application .And the session over the dblink was getting opened eachtime when the procedure is being called which can never be closed again in frontend because no commit issued anywhere either in frontend and backend. So after maximum session opened the above error was
throwing .In Oracle document mentions that the two phase commit must required in db link even in select statement.
So We have modified the procedure like and it started working perfectly.

CREATE global temporary TABLE eMP_temp
  (
    EMPNO    NUMBER(4,0) ,
    ENAME    VARCHAR2(10 BYTE),
    JOB      VARCHAR2(9 BYTE),
    MGR      NUMBER(4,0),
    HIREDATE DATE,
    SAL      NUMBER(7,2),
    COMM     NUMBER(7,2),
    DEPTNO   NUMBER(2,0)
  )
  ON COMMIT preserve rows;  

CREATE OR REPLACE procedure p_link_test(p_deptno in number,c_emp_details out sys_refcursor) IS
begin
delete from emp_temp;
commit;
insert into eMP_temp SELECT * FROM emp@db_link where deptno=p_deptno;
commit;--the problem solved here
OPEN c_emp_details FOR SELECT * FROM eMP_temp;
end ;

[Updated on: Thu, 02 January 2014 10:44]

Report message to a moderator

Previous Topic: Reading a csv file
Next Topic: CURRENT TIME
Goto Forum:
  


Current Time: Tue Dec 06 10:28:45 CST 2016

Total time taken to generate the page: 0.18617 seconds