Set Up PCP
1. Execute AutoConfig by running $INST_TOP/admin/scripts/adautocfg.sh on all concurrent nodes.
2. Source the application environment.
3. Check the configuration files tnsnames.ora and listener.ora located at $INST_TOP/ora/10.1.2/network/admin. Ensure that you have information of all the other concurrent nodes for FNDSM and FNDFS entries.
4. Restart the application listener process on each application tier node.
5. Log on to Oracle E-Business Suite Release 12 as SYSADMIN, and choose the System Administrator Responsibility. Navigate to Install > Nodes screen and ensure that each node in the cluster is registered.
6. Verify whether the Internal Monitor for each node is defined properly with correct primary and secondary node specification and work shift details. Also ensure the Internal Monitor manager is activated by going to Concurrent -> Manager -> Administrator and activating the manager. (For example, Internal Monitor: Host2 must have primary node as host2 and secondary node as host3).
The secondary nodes for Internal Monitor: host2 and Internal Monitor: host3 were not defined.
Also the workshifts were not present. Set them as 24 hrs and the processes was set to 1.
Went to the concurrent - > manager - > administrator screen and activated the above 2 managers.
7. Set the $APPLCSF environment variable on all the CP nodes pointing to a log directory on a shared file system.
Change to be made in the context file. Initially it was :
$ORACLE_SID $> grep -i applcsf $CONTEXT_FILE
Changed it to :
$ORACLE_SID $ > grep -i applcsf $CONTEXT_FILE
Do not run autoconfig yet, you have to make more changes in the below step. We will run autoconfig after that.
These changes need to be on just the conc manager tiers.
8. Set the $APPLPTMP environment variable on all the CP nodes to the value of the UTL_FILE_DIR entry in init.ora on the database nodes. This value should be pointing to a directory on a shared file system.
Initially, APPLTMP was set as ‘/usr/tmp’.
We need this to be on a file system, that is shared across all the CM nodes and is also writable by the owner of the oracle db.
Now we will need this to be the first entry in the “utl_file_dir” parameter in the db.
Use grid to have this change done, to the “utl_file_dir” parameter for database. This would need a bounce of db.
Also, modify the CONTEXT FILE on all the apps tier , to have APPLPTMP and APPLTMP point to shared mount point and run autoconfig.
$ORACLE_SID $> grep -i s_applptmp $CONTEXT_FILE
$ORACLE_SID $> grep -i s_appltmp $CONTEXT_FILE
Both of the above were changed to
$ORACLE_SID $> grep -i s_applptmp $CONTEXT_FILE
$ORACLE_SID $ > grep -i s_appltmp $CONTEXT_FILE
These changes need to be on just the conc manager tiers.
9. Set profile option ' Concurrent: PCP Instance Check' to OFF if database instance-sensitive failover is not required. By setting it to 'ON', Concurrent Managers will fail over to a secondary Application tier node if the database instance they are connected to fails.
Set Up Transaction Managers
1. Shut down the application services (servers) on all nodes.
2. In the Oracle RAC environment, shut down all the database instances cleanly with the command:
SQL>shutdown immediate;
3. Edit $ORACLE_HOME/dbs/
_lm_global_posts=TRUE
_immediate_commit_propagation=TRUE
4. Start the instances on all database nodes, one by one.
5. Start up the application services (servers) on all nodes.
6. Log on to Oracle E-Business Suite Release 12 using SYSADMIN login and System Administrator Responsibility.
Navigate to Profile > System and change the profile option ‘Concurrent: TM Transport Type' to ‘QUEUE' and verify the transaction manager works across the RAC instance.
7. Navigate to Concurrent > Manager > Define screen, and set up the primary and secondary node names for transaction managers.
8. Restart the concurrent managers.
9. If any of the transaction managers have a deactivated status, activate them using Concurrent > Manager > Administrator.
Set Up Load Balancing on Concurrent Processing Nodes
1. Edit the applications context file through Oracle Applications Manager interface and set the value of Concurrent Manager TWO_TASK (s_cp_twotask) to load balancing alias (
Change need to be made in CONTEXT_FILE.
Initially it was:
$ORACLE_SID $ > grep -i s_cp_twotask $CONTEXT_FILE
It was changed to :
$ORACLE_SID $> grep -i s_cp_twotask $CONTEXT_FILE
These changes need to be on just the conc manager tiers ( host2 and host3).
2. Execute AutoConfig by running $INST_TOP/admin/scripts/adautocfg.sh on all concurrent nodes.
