Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

PRPC Caching DB connection string

SA-34398

Summary



During PRPC startup, it is caching DB connection sting which is blocking us to make the environment Hot-Hot or achieve HA. Our business wants the App to be up all the time but below are two scenarios are blocking us doing so. Please advise on how this can be addressed.
  1. The user has Oracle 11g RAC DB which has two DB nodes hosting App requests in parallel. For whatever reason, one of node goes down, the existing requests to that crashed node from a JVM are still trying to connect to the crashed node, until that DB connections timeout.
  2. Changes to DB URL in WebSphere require the user to restart the JVM or else it will not pickup latest value.


Error Messages



Not Applicable


Steps to Reproduce



Not Applicable


Root Cause



A third-party product issue

Resolution



Here’s the explanation for the reported behavior:

Regarding first query :

Please make sure that all the configuration is as per the document below:

https://www.ibm.com/support/knowledgecenter/SSAW57_8.5.5/com.ibm.websphere.nd.iseries.doc/ae/tdat_oracleracconnpool.html

Make sure that connection cache name is unique. Because pega looks into data source URL for the connection and how it is handled for the RAC, the user must consult with Oracle.



Regarding the second query:

It seems to be ideal behaviour but it will most accurately answered by the Oracle , whether this is correct behaviour for RAC or we need some configuration changes.

Suggest Edit

Published March 3, 2017 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us