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.
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:
Post a Comment