Skip to Content
author's profile photo Former Member
Former Member

Erro Oracle 00020: Maximum connections execeeded (150) in RAR

Hi All,

I have been experiencing some problem from past 1 week. The problem is that, we have scheduled background jobs in RAR. These jobs are getting status error after sometime. When I checked the logs, I found that it repeatedly gave the below error:

Got minus one from a read call

Upon further investigation, I found that it is causing because of Oracle error:

Ora:00020: Maximum number of processes exeeced (150)

When i got this error, I tried to log onto Oracle, but it did not allow and refused the connection. When I restarted the J2EE server where these GRC applications are installed, it freed all the processes and allowed me to log onto oracle using SLQ.

We have standard setting 150 processes at DB level and based upon the SAP recommendations, we maintained 100 as the Max. connections in JCO Pool Connection for each JCO connections.

I have gone through the SAP notes which suggests us to increase the number work processes at DB level. My question is:

How many number of work processes should I increase to? What is the correct calculation?

What is the guarantee that the increased number of work processes at DB level will not cause this error in future?

How to control the user session?

How to monitor the user sessions from GRC applications?

May somebody suggest?

Regards,

Faisal

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jun 22, 2011 at 09:49 AM

    Hi,

    You should increase number of processes and session parameter on database level. Correct calculation for number of processes and sessions can be done by SAP note 830576 (I am assuming you are using oracle 10g).

    If number of processes at database level is 150 then this value is very less. And you should increase it.

    This error is not coming because number of user sessions. Database has number of threads which is controlled by parameter processes. So, these processes can be used even if you are scheduling background jobs not because of only user sessions.

    By the way, you can monitoring user sessions from NWA of your GRC system.

    Thanks

    Sunny

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi All,

      There is a SAP note#1431798 - Oracle 11.2.0: Database Parameter Settings which is relevant to this problem. This is suggested by SAP.

      Since we are running on Oracle 11.2.0, this note is applicable. Hope this will help others.

      Thanks.

      Regards,

      Faisa

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.