Thursday, July 27, 2017

EBS adop error:ORA-20008: No Concurrent Manager is running that can run concurrent program

While i was on my way to apply a patch in EBS 12.2.6, i enountered an error which is very common.

ORA-20008: No Concurrent Manager is running that can run concurrent program

I checked the concurrent manager status from front end and saw that it was not correct. I then checked the manager status

adcmctl.sh status apps/password

You are running adcmctl.sh version 120.19.12020000.7

Internal Concurrent Manager is Not Active at this time.

adcmctl.sh: exiting with status 0


adcmctl.sh: check the logfile /u01/r12/application/fs1/inst/apps/PROD_ebs1/logs/appl/admin/log/adcmctl.txt for more information ...


Thus the information stored in the Concurrent manager tables are not correct. In EBS 12.2 cmclean.sql is not supported, instead there is an alterative option known as cpadmin.sh.I Stopped the concurrent manager and then invoked cpadmin.sh


[applmgr@ebs1 scripts]$ cpadmin.sh


                     Copyright (c) 2015 Oracle Corporation
                        Redwood Shores, California, USA

                   Oracle E-Business Suite CP Administration
                             $Revision: 120.0.12020000.5 $

Logging to file /u01/r12/application/fs_ne/inst/PROD_ebs1/logs/appl/conc/log/cpadmin.022620170737

Enter the password for your 'APPS' ORACLE schema:
Connecting to database...



         CP Administration Main Menu
   --------------------------------------------------

   1.    Administer Concurrent Managers

   2.    Administer Concurrent Requests


   E.    (E)xit CP Administration


Enter your choice: [E] :  1
        Administer Concurrent Managers
   --------------------------------------------------

   1.    Manager Status
          - Show status of all managers

   2.    Clean concurrent processing tables--choose the second option
          - Ensure concurrent processing tables are cleaned and reset for ICM startup

   3.    Set Manager Diagnostics
          - Turn diagnostics on/off for specific managers

   4.    Control a manager or service
          - Send a control request to a manager or service

   5.    Rebuild Concurrent Manager Views
          - Rebuild Views for Fnd_Concurrent_Worker_Requests and Fnd_Concurrent_CRM_Requests


   R.    (R)eturn to previous menu

   E.    (E)xit CP Administration




Thereafter, adop phase=prepare successfully got completed.







No comments:

Post a Comment