Set Up Parallel Concurrent Processing in Apps/EBS R12
Edit the applications context file via Oracle Applications Manager, and set the value of the variable APPLDCP to ON.Go to - System Administrator responsibility -> OAM Setup -> Site Map -> Auto Config -> click on Edit Parameters icon of the desired application tier node-- Node 1
[oracle@appsnode_new ~]$ hostname
appsnode_new.localdomain
[oracle@appsnode_new ~]$ adautocfg.sh
-- Node 2
[oracle@appsnode2_new ~]$ hostnameappsnode2_new.localdomain
[oracle@appsnode2_new ~]$ adautocfg.sh
-- Node 1
[oracle@appsnode_new forms_default_group_1]$ adalnctl.sh status
adalnctl.sh version 120.3
Checking status for listener process APPS_visr12.
LSNRCTL for Linux: Version 10.1.0.5.0 - Production on 13-AUG-2012 14:04:15
Copyright (c) 1991, 2004, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=appsnode_new)(Port=1626))
STATUS of the LISTENER
------------------------
Alias APPS_visr12
Version TNSLSNR for Linux: Version 10.1.0.5.0 - Production
Start Date 13-AUG-2012 12:37:34
Uptime 0 days 1 hr. 26 min. 41 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/visr12/inst/apps/visr12_appsnode_new/ora/10.1.2/network/admin/listener.ora
Listener Log File /u01/app/oracle/visr12/inst/apps/visr12_appsnode_new/logs/ora/10.1.2/network/apps_visr12.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=appsnode_new.localdomain)(PORT=1626)))
Services Summary...
Service "FNDFS" has 1 instance(s).
Instance "FNDFS", status UNKNOWN, has 1 handler(s) for this service...
Service "FNDSM" has 1 instance(s).
Instance "FNDSM", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@appsnode2_new admin]$ adalnctl.sh status
adalnctl.sh version 120.3
Checking status for listener process APPS_visr12.
LSNRCTL for Linux: Version 10.1.0.5.0 - Production on 13-AUG-2012 11:12:13
Copyright (c) 1991, 2004, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=appsnode2_new)(Port=1626))
STATUS of the LISTENER
------------------------
Alias APPS_visr12
Version TNSLSNR for Linux: Version 10.1.0.5.0 - Production
Start Date 13-AUG-2012 09:51:00
Uptime 0 days 1 hr. 21 min. 12 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/visr12/inst/apps/visr12_appsnode2_new/ora/10.1.2 /network/admin/listener.ora
Listener Log File /u01/app/oracle/visr12/inst/apps/visr12_appsnode2_new/logs/ora/1 0.1.2/network/apps_visr12.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=appsnode2_new.localdomain)(PORT=1626)))
Services Summary...
Service "FNDFS" has 1 instance(s).
Instance "FNDFS", status UNKNOWN, has 1 handler(s) for this service...
Service "FNDSM" has 1 instance(s).
Instance "FNDSM", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
If Entries are not find then try to restart the Applications listener processes on each application tier node.
Log on to Oracle E-Business Suite Release 12 using the SYSADMIN account, and choose the System Administrator Responsibility. Navigate to Install > Nodes screen, and ensure that each node in the cluster is registered.
Verify that the Internal Monitor for each node is defined properly, with correct primary node specification, and work shift details. For example, Internal Monitor: Host1 must have primary node as host1. Also ensure that the Internal Monitor manager is activated: this can be done from Concurrent > Manager > Administrator.
Set the $APPLCSF environment variable on all the Concurrent Processing nodes to point to a valid log directory on both apps tier nodes. If the file systems are local then make sure it has proper privileges. If its on a shared file system, then make sure both apps nodes can write to it.
Set profile option 'Concurrent: PCP Instance Check' to ON.
By setting it to 'ON', a concurrent manager will fail over to a secondary Application tier node if the database instance to which it is connected becomes unavailable for some reason.
Set Up Transaction Managers
Shut down the application services (servers) on all nodes
Shut down all the database instances cleanly in the Oracle RAC environment,
Edit $ORACLE_HOME/dbs/<context_name>_ifile.ora. Add the following parameters:
_lm_global_posts=TRUE
_immediate_commit_propagation=TRUE
Start the instances on all database nodes, one by one.
Start up the application services (servers) on all nodes.
Log on to Oracle E-Business Suite using the SYSADMIN account, and choose the System Administrator responsibility. Navigate to Profile > System, change the profile option ‘Concurrent: TM Transport Type' to ‘QUEUE', and verify that the transaction manager works across the Oracle RAC instance.
Navigate to Concurrent > Manager > Define screen, and set up the primary and secondary node names for transaction managers.
Do this for all needed transaction managers and Restart the concurrent managers on all nodes.
If any of the transaction managers are in deactivated status, activate them from Concurrent > Manager > Administrator.
Test -
Now try to stop CM Processes on all nodes and start the second node. You will be able to see that for the concurrent managers for which primary node down and secondary node up, they will start on secondary node.
That's it. You just configured the Parallel Concurrent Processing for your Apps R12!
But how to run parallel concurrent processing in Non-RAC env?
ReplyDeleteIt is very simple. Assume you dont have RAC and rest of the setting on Apps/CM tier remains the same. you dont define load balanced entries for TWO_TASK variables in context file, your transport type will stays as PIPE and appldcp is on.
ReplyDeleteexcellent work
ReplyDeleteGood info..thanks
ReplyDeleteIs there any changes need to do on custom application while setting up PCP.
ReplyDelete