Sunday, December 25, 2016

Run concurrent program on Specific Database RAC/PCP node

In Oracle E-Business Suite R12 there is an interesting feature where we can control a concurrent program to Run In Specific Database RAC/PCP node. To achieve this one can go to, concurrent program define window where we can define which node and instance a concurrent program should connect and run, through a concurrent program session control.

Navigation: System Administrator Responsibility > Concurrent > Program > Define > Click 'Session Control'

You can define in this screen Target Node and Target Instance for that particular concurrent program.

Irrespective of the managers running on the node and connected to which ever RAC instance, This definition makes sure the program is run in the specified RAC/PCP node.



What is Target Node
If you specify the target node on which requests for this program will run. When requests for this program are submitted, They run on this node if that is node is available,
If no specification is made for the target node of a concurrent program, a request for it will be picked up by any manager available to run it.
If a node specification is made for a concurrent program and the node is up, only available managers running on the specified node will pick up the request.

What is Target Instance
When requests for this program are submitted, they run on this database instance node If it is available.
If no specification is made for the target instance of a concurrent program, a request for it will be picked up by the first manager available to run it and will be run in the instance where the manager is already connected.
If an instance specification is made for a concurrent program and the instance is up, it will be picked up by the first manager available to run it and the manager will run the request in the specified instance.
However, if the target RAC instance is down, the manager will run the request in the instance where it is already connected and log an appropriate message.


For any questions please email me on samiappsdba@gmail.com