Sunday, May 16, 2021

ORA-20008 When Running "adop phase=prepare"


 
Error while running command: adop phase=prepare


ORA-20008 When Running "adop phase=prepare"

During the Prepare Phase of the patching cycle, the ADZDPATCH Concurrent Program is failing.

Internal Manager is also unstable and fails to restart.

ADZDPATCH.ldt log:
Submitting ADZDPATCH concurrent program.
   Waiting for conflicting requests to complete.
   [ERROR]     Failed to execute sql statement:
select AD_ZD_ADOP.WAIT_FOR_CP_TO_RUN(32251926) from dual
   [ERROR]     SQLPLUS error: buffer=
SQL*Plus: Release 10.1.0.5.0 - Production
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
SQL> SQL> Connected.
SQL> select AD_ZD_ADOP.WAIT_FOR_CP_TO_RUN(32251926) from dual

      *
ERROR at line 1:
ORA-20008: No Concurrent Manager is defined that can run concurrent program
ADZDPATCH
ORA-06512: at "APPS.AD_ZD_ADOP", line 274
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options

   [UNEXPECTED]Error calling runConcurrentProgram subroutine.
   Stopping services on patch file system.
   Stopping admin server.
   Stopping node manager.
   [ERROR]     Prepare phase has failed.

CAUSE -

adzdpatch.ldt not completely loaded into database

Solution :-

Set the Run filesystem / environment and run command:


FNDLOAD apps/<password> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct $AD_TOP/patch/115/import/US/adzdpatch.ldt - CUSTOM_MODE=FORCE

Sometimes check the Package AD_ZD_ADOP becomes invalid.
that could be the cause as well.

Rerun the adop=prepare  
(Success) without any issues .



No comments: