Understanding and Configuring PCP in Oracle EBS

By -

1. What is PCP?

PCP stands for Parallel Concurrent Processing.

It allows Concurrent Managers in Oracle E-Business Suite to run on multiple nodes instead of just one.

Why use PCP?

  • Load Balancing – Distributes workload across multiple nodes for better performance.
  • High Availability – If one node fails, managers can failover to another node.
  • Failover and Failback – Automatically moves managers to available nodes during failure and back when the node is restored.

 

2. PCP Setup Types

  • RAC Database Setup – Commonly used with PCP.
  • Non-RAC Setup – PCP can still work without RAC by using TNS aliases for connectivity.

3. How PCP Works

  • Each node runs Concurrent Managers.
  • Managers connect to the database using TWO_TASK (TNS alias) defined in:

adcmctl.sh

gsmstart.sh

 

4. Internal Monitor (IMON)

  • Optional Service but recommended.
  • Monitors the Internal Concurrent Manager (ICM).
  • If the primary node fails:
    • IMON detects failure.
    • Starts ICM and other managers on another node.
  • Best Practice: Enable IMON on all nodes where ICM can start.

 

5. Internal Concurrent Manager (ICM)

  • Monitors other managers during PMON cycle.
  • Can run on any concurrent processing node.
  • Ensures managers are up and running.

6. Service Manager (FNDSM)

  • Required for PCP.
  • Manages services/managers on each node.
  • Started by APPS TNS Listener.
  • Listener spawns Service Manager when needed.
  • Stops when ICM stops.

Environment Setup:

  • Defined in gsmstart.sh and APPSORA.env.

7. Key Benefits of PCP

  • Better Performance: Workload distributed across nodes.
  • High Availability: Failover capability.
  • Scalability: Add more nodes easily.

Below is an example of how these parameters appear in the EBS context file:


-bash-4.2$ cat $CONTEXT_FILE |grep s_appldcp

                       <APPLDCP oa_var="s_appldcp">ON</APPLDCP>

-bash-4.2$ cat $CONTEXT_FILE |grep s_applcsf

                       <APPLCSF oa_var="s_applcsf">/u01/oracle/R122/DEV/fs_ne/DEV_<SERVER_NAME>/logs/appl/conc</APPLCSF


Comments

Post a Comment

Popular posts from this blog

How to troubleshoot long running concurrent request in R12.2

By -
We frequently encounter issues with concurrent programs running long and concurrent requests not picking up jobs. These problems are often expected from the development and functional team we need to address this issue To solve this, we should take the following steps: Collect below basis level of information to development team 1 Oracle seeded program/Custom program? 2 How much time it used earlier? 3 Is there any recent code change done in concurrent program? 4 Is this program fetching higher data compare to last run? 5 Does this job running any specific time/ It can be run any time? 6 Does this job fetching data using DB link? 7 Does the problem happen on both the test and production instance?   Troubleshooting Steps for Concurrent Requests Check for Locks and Blocking sessions Identify if the request is running but blocked by database locks/Blocking sessions. Use DBA tools or queries to identify and release locks if necessary. Review Parameters and Data ...
Read more

How to find EBS URL in R12.2

By -
There are different way to find the EBS URL Method 1 Login the R12.2 application server Source the Env File [oracle@san ~]$ grep login $CONTEXT_FILE          <login_page oa_var="s_login_page">http://dev1.apps.com:8001/OA_HTML/AppsLogin</login_page> [oracle@san~]$ Method 2: Connect sqlplus apps user SQL> SELECT home_url  FROM icx_parameters; HOME_URL -------------------------------------------------------------------------------- http://<Hostname>:8007/OA_HTML/AppsLogin How to find Weblogic URL and PORT number: Login the R12.2 application server Source the Env File [oracle@sanprod ~]$ grep s_wls_adminport $CONTEXT_FILE          <wls_adminport oa_var="s_wls_adminport" oa_type="PORT" base="7001" step="1" range="-1" label="WLS Admin Server Port"> 7002 </wls_adminport> [oracle@sanprod ~]$ Weblogic Port Number:7002  Weblogic URL:http://<...
Read more

How to Grant Privileges in Oracle EBS R12.2 Using AD_ZD.GRANT_PRIVS

By -
When working with Oracle E-Business Suite (EBS) R12.2, granting privileges to applicatation objects requires special care to avoid invalidating objects in the current edition.  Grants cannot be performed in the run edition when the application is being used. A direct GRANT (DDL) command can potentially cause object invalidation when the application is actively being used. To handle this in a more controlled manner, Oracle introduced the AD_ZD.GRANT_PRIVS utility. Why Use AD_ZD.GRANT_PRIVS? In Oracle EBS R12.2, all grants should be performed using the AD_ZD.GRANT_PRIVS procedure rather than the traditional GRANT statement.  The reason is simple: the GRANT statement directly modifies objects in the database, and this can invalidate them in the current edition. Invalidations during runtime can cause service interruptions, which is unacceptable in a live system. Syntax for Granting and Revoking Privileges The AD_ZD package provides two p...
Read more