Oracle RAC and PCP in R12.2
Posted by mi_singh@hotmail.com on Jun 02, 2021; 8:48pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Oracle-RAC-and-PCP-in-R12-2-tp9835.html
We have a 3 node RAC (12.1.0.2) and 3 nodes for application tier. Both concurrent processing and application services run on application tiers. Application version is 12.2.7.
We've defined database services for node-affinity to reduce the block shipping across the interconnect. We've defined 3 services for concurrent processing(cp1,cp2 and cp3) and 3 services for application (ap1,ap2 and ap3). cp1 and ap1 run on application node 1 and connect to RAC instance 1.
It seems Oracle document "Configuring and Managing Oracle E-Business Suite Release 12.2.x Forms and Concurrent Processing for Oracle RAC (Doc ID 2029173.1)" is not written for scenario where concurrent processing and application services are running on the same node.
Can you help clarify the following?
1. Do we need to create ap1.dbc file and set service_name to ap1 or we can just update <database>.dbc for service_name to ap1?
2. Do we need to create dbc file for concurrent processing?
3. what service_name should be used in s_apps_jdbc_connect_descriptor?
Thanks
M