Below error coming while executed adop phase=prepare.
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(35360925) from dual
[ERROR] SQLPLUS error: buffer=
SQL*Plus: Release 10.1.0.5.0 - Production on Sat Sep 8 14:01:00 2018
Copyright (c) 1982, 2005, Oracle. All rights reserved.
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(35360925) from dual
[ERROR] SQLPLUS error: buffer=
SQL*Plus: Release 10.1.0.5.0 - Production on Sat Sep 8 14:01:00 2018
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> SQL> Connected.
SQL> select AD_ZD_ADOP.WAIT_FOR_CP_TO_RUN(35360925) from dual
*
ERROR at line 1:
ORA-20008: No Concurrent Manager is running that can run concurrent program
ADZDPATCH
ORA-06512: at "APPS.AD_ZD_ADOP", line 282
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining 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.
Set the Run filesystem / environment and run command:
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct $AD_TOP/patch/115/import/US/adzdpatch.ldt - CUSTOM_MODE=FORCE
*
ERROR at line 1:
ORA-20008: No Concurrent Manager is running that can run concurrent program
ADZDPATCH
ORA-06512: at "APPS.AD_ZD_ADOP", line 282
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining 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.
Solution:-
Set the Run filesystem / environment and run command:
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct $AD_TOP/patch/115/import/US/adzdpatch.ldt - CUSTOM_MODE=FORCE
If still not resolve the issue. Pls follow the below steps.
First of all truncate the following tables.
truncate table applsys.fnd_nodes;
truncate table applsys.fnd_oam_context_files;
truncate table applsys.adop_valid_nodes;
If on AD/TXK 8 or higher:
truncate table applsys.ad_nodes_config_status;
run autoconfig on DB and appsTier.
To check whether its working or not.
The syntax to run an empty patch cycle is:
Quick Version:
$ cd <EBS_ROOT>
$ source EBSapps.env run
$ adop phase=prepare,finalize,cutover
$ source EBSapps.env run
$ adop phase=cleanup
Complete Version:
$ cd <EBS_ROOT>
$ source EBSapps.env run
$ adop phase=prepare
$ adop phase=actualize_all
$ adop phase=finalize finalize_mode=full
$ adop phase=cutover
$ source EBSapps.env run
$ adop phase=cleanup cleanup_mode=full
