Setting up load balancing

Load balancing is important, as it enables you to distribute the load of the various EBS components to the less-active instances. Implementing load balancing for the Oracle Applications database connections is achieved by following the steps outlined here:

1. Run the Context Editor (through the Oracle Applications Manager interface) and set the value of Tools OH TWO_TASK (s_tools_two_task), iAS OH TWO_TASK (s_weboh_twotask), and Apps JDBC Connect Alias (s_apps_ jdbc_connect_alias).

2. To load-balance the forms-based applications database connections, set the value of Tools OH TWO_TASK to point to the <database_name>_balance alias generated in the tnsnames.ora file.

3. To load-balance the self-service applications database connections, set the value of iAS OH TWO_TASK and Apps JDBC Connect Alias to point to the <database_name>_balance alias generated in the tnsnames.ora file:

   Execute AutoConfig by running the command:

   $AD_TOP/bin/adconfig.sh contextfile=$INST_TOP...