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

[former_member184114]

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

[sunny_pahuja2]

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

[luis_bustamante]

By the way, I checked some other reports on this issue and besides increasing the number of connection as suggested by Sunny, we've seen this issue been triggered in instances where there is a support pack upgrade and the latest "CC5.3_MESSAGES.txt" has not been imported. Can you confirm you did this on the last SP upgrade?

Thanks,

Luis

[former_member184114]

Hi Sunny,

Thanks for your detailed response.

Yes, I am using Oracle 10g. I found "processes" and "session" details under /oracle/<SID>/102_64/dbs/init<SID>.ora as:

*.processes= 130

*.sesions=260

Should I increase it? I have also checked the SAP note#34432 which says, "processes" and "sessions" should be increased by 50% for ORA-00020 error.

As far user monitoring, I checked in NWA....but unfortunately could not find the option to monitor the users. May you guide me?

Regards,

Faisal

[former_member184114]

Hi Luis,

Thanks for your reply.

No, I have not done any SP upgrade for GRC applications on our production system. However, on our DEV system, I have completed it successfully and did not get any issues after SP upgrade to SP15. I am in a process to upgrade SP for GRC applications on our Productions system.

Regards,

Faisal

[sunny_pahuja2]

Hi,

I think you can make number of processes=500 and sessions=1000. But make sure that you have sufficient resources on the server for the same.

User sessions monitoring path is- Go to NWA --> Monitoring --> Session Monitoring.

Thanks

Sunny

[former_member184114]

Hi Sunny,

Thanks for your response.

I will check with the server details if I can increase these parameters suggested by you.

As far User monitoring, I checked the path mentioned by you. I found the below options/links under "Monitoring"

1. Overview

2.Availability

3.Central Reports

4.Java System Reports

5.Logs and Traces

However, I could not find the "user" option. May you suggest?

Regards,

Faisal

[sunny_pahuja2]

What is your netweaver version of GRC portal ?

Thanks

Sunny

[former_member184114]

It is 7.0 SP24

Regards,

Faisal

[former_member184114]

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