In Oracle EBS version 12.2.6, Internal concurrent manager had an unexpected Outage.
ICM logfile has the error message ORA-04068: existing state of packages has been discarded
====================
Shutting down Internal Concurrent Manager : 30-JAN-2018 12:09:54
List of errors encountered:
…………………………………………………………………..
_ 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
ICM logfile has the error message ORA-04068: existing state of packages has been discarded
====================
Shutting down Internal Concurrent Manager : 30-JAN-2018 12:09:54
List of errors encountered:
…………………………………………………………………..
_ 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
==========================================
Issue Resolution
1. Shut down the Concurrent manager completely using adcmctl.sh
cd $ADMIN_SCRIPTS_HOME
adcmctl.sh stop apps/<appspassword>
2. Compile the invalids in database
SQL>alter package FND_DCP compile body;
OR
Run the utlrp.sql script to recompile all the invalid objects in the database.
3. Startup Concurrent manager using adcmctl.sh
cd $ADMIN_SCRIPTS_HOME
adcmctl.sh start apps/<appspassword>
4. Verify Oracle EBS Concurrent manager is running fine.