DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Friday, March 31, 2017

Internal Concurrent Manager Issue In R12.2 due to ORA 4061 Error

We've recently encountered ICM process showing Actual=0, Target=1 in Oracle EBS R12.2.
 

Internal concurrent manager may goes down due to invalid objects. We noticed the following error in the internal concurrent manager log file.

Error:

............................................................................
_ 1 _
Error in DBMS lock request by handle. (ROUTINE=AFPGMG) (REASON=ORACLE
error 4068 in afpdlrh
Cause: afpdlrh failed due to ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package body "APPS.FND_DCP" has been invalidate
............................................................................

Fix:
1. Compile invalid objects showed in the log file
Connect to database as apps user and compile invalid object
alter package APPS.FND_DCP compile;
alter package APPS.FND_DCP compile body;
2. Stop concurrent managers
Login to middle tier where concurrent managers are running
cd $ADMIN_SCRIPTS_HOME
adcmctl.sh stop apps/apps_pwd
Note: Make sure all the managers are down. 
3. Start concurrent managers.
cd $ADMIN_SCRIPTS_HOME
adcmctl.sh start apps/apps_pwd

Reference:  
ORA-04061 Internal Concurrent Manager Going Down (Doc ID 1068908.1)
Happy EBS Troubleshooting ..