4.0.6 upgrade, hit Oracle max processes limit - Is there a suggested value for this parameter?
3 answers
Hi Jason,
Usually decreasing the number of JDBC and Mediator pool connections would be the alternative to raising the Oracle limits. Are you using WAS or Tomcat?
You do need to set the Oracle limit higher than the JDBC/Mediator connections due to ETLs and other system connections, but I am afraid there is no rule of thumb that I am aware of.
If you can provide the additional info, it might be able to comment further. If you can get your DBA to give you the list of users accessing the databases, then it should also be able to guesstimate how many you (should) require.
Paul
Comments
I'm running with Tomcat.
Hi again Jason,
I have been holding off replying, as I too am unsure of why this limit would peak other than through natural causes, such as the upgrade. I am afraid I am the wrong person to comment on the intricacies of upgrade in those terms.
Are you using Suspect Links in 4.x? I know that this could take some time in the initial indices build...as will undoing the Suspect Links (turning it off, so be warned if you did!)
As you do have 300 Oracle connections, if you do continue to monitor the $vprocesses in Oracle and note you're not going above say 150, then you could increase the JDBC/Mediator pool sizes accordingly...see https://jazz.net/library/article/790. These JDBC/Mediator pool sizes are 128 by default btw
this section of the info center talks about the limits for open files and processes:
Planning to install on UNIX and Linux systems
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m6/topic/com.ibm.jazz.install.doc/topics/c_special_considerations_linux.html
* hard nofile 65536
* soft nofile 65536
* hard nproc 10000
* soft nproc 10000
Best Regards,
Francesco Chiossi
Comments
Hi Sterling,
Which aspect of this post were you interested in? There is no absolute value for the Oracle connections, as it is usually based on your mediator pool sizes. However, this is usually for the main Jazz applications. I have seen admin and ETL users go outside this.
Please let me know if I didn't address something from your perspective too.
Hello,
I have 2 Oracle customers I am about to upgrade. We have experienced the file limit error above, but I was just researching any additional problems that may occur and how to combat them in advance.