EBS 11i - JDBC connection from XDO/OPP - how to pin to a specific RAC node
We have a two node RAC cluster. Let's call the service PRD and the instances are PRD1 and PRD2 on HOST1 and HOST2 respectively.
We have EBS11i concurrent processing also on HOST1 and HOST2 - primary and secondary respectively.
All of our concurrent managers run on primary HOST1 including the java based concurrent managers.
We deliberately pin the standard managers to HOST1 and PRD1 using s_cp_twotask/CP_TWOTASK. We do not want the database blocks to be pinging back and forwards between the instances.
If we have a failure in PRD1 or with HOST1 then concurrent processing failover kicks in and moves all the processes over to HOST2 and PRD2 and we carry on.