CCM RAC Load Balancing Not Using PCP
Hi All:
We have a 2-Node RAC database with a single Apps node front end.
The Web, Forms, JDBC and Concurrent Mangers (CCMs) TWO_TASK settings are set by the following Apps context file configuration variables:
s_apps_jdbc_connect_alias=PROD_BALANCE
s_tools_twotask=PROD_BALANCE
s_weboh_twotask=PROD_BALANCE
s_cp_twotask=PROD
The above were set based on Oracle's documentation for setting up Forms, Web & JDBC in a RAC environment.
Where the PROD_BALANCE tnsnames alias entry is defined to balance connections between
node1 and node2 of the RAC database, with the parameters LOAD_BALANCE=YES and FAILOVER=YES