Error ORA-02391

Today I have been notified the following error;

 

ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

 
The problem is that a user attempted to open more than five connections. The user has an associated resource profile in which he can open up to five connections, he try a sixth connection when he get this error. This limit is set for a subject app functionality. Basically there are two solutions, see for trying open a new connection over the five connections established, it has been the solution in this case. The other solution is to change the profile and set a higher value. The following command raises the limit to ten connections.

 

alter profile AGENTPRFL limit SESSIONS_PER_USER 2;

 
You can check the current value with the following query;

 

select * from dba_profiles where profile =’AGENTPRFL’
and resource_name =’SESSIONS_PER_USER’;

 

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s