Error1:
Submitting ADZDPATCH concurrent program...
Request ID: 11092151
Waiting for conflicting requests to complete.
[ERROR] Failed to execute
sql statement :
select AD_ZD_ADOP.WAIT_FOR_CP_TO_RUN(11092151) from dual
[ERROR] SQLPLUS error:
buffer=
SQL*Plus: Release 10.1.0.5.0 - Production on Sun Mar 13 14:57:06 2016
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> SQL> Connected.
SQL> select AD_ZD_ADOP.WAIT_FOR_CP_TO_RUN(11092151) 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 241
Disconnected from Oracle Database 11g Enterprise Edition Release
11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[UNEXPECTED]Error while runConcurrentProgram
sub-routine is called.
Stopping services on patch file system...
Stopping admin server...
Stopping node manager...
[ERROR] Prepare phase completed
with errors or warnings. Please check logfiles.
[STATEMENT] Please run adopscanlog utility, using the command
"adopscanlog -latest=yes"
to get the list of the log files along with snippet of the error
message corresponding to each log file.
adop exiting with status = 1 (Fail)
Resolution: As the above error was reported as known issue in similar environments.
We are able to resolve the above error using below action plan.
ServerName: [/u01/oracle] FNDLOAD apps/**** 0 Y UPLOAD
$FND_TOP/patch/115/import/afcpprog.lct
$AD_TOP/patch/115/import/US/adzdpatch.ldt - CUSTOM_MODE=FORCE
Log filename : L1000000.log
Error2:
Submitting ADZDPATCH concurrent program...
Request ID: 1000000
ADZDPATCH is now running.
Saving database logs from previous session...
Output:
/u01/oracle/fs_ne/EBSapps/log/adop/11/prepare_20160314_000627/UAT_servername/adzdshowlog_cleanup.out
Creating Database Patch Edition...
Log: @ADZDSHOWLOG.sql "2016/03/14 00:12:57"
[ERROR] Cannot connect to database
[ERROR] Error Message : ORA-12514: TNS:listener
does not currently know of service requested in connect descriptor (DBD ERROR:
OCIServerAttach)
[ERROR] *** Error occurred while calling
ad_zd_log. Please check log file for the details. ***
[ERROR] *** Error occurred while calling
ad_zd_log. Please check log file for the details. ***
[ERROR] *** Error occurred while calling
ad_zd_log. Please check log file for the details. ***
[ERROR] *** Error occurred while calling
ad_zd_log. Please check log file for the details. ***
[ERROR] *** Error occurred while calling
ad_zd_log. Please check log file for the details. ***
[ERROR] Cannot connect to database
[ERROR] Error Message : ORA-12514: TNS:listener
does not currently know of service requested in connect descriptor (DBD ERROR:
OCIServerAttach)
[ERROR] *** Error occurred while calling
ad_zd_log. Please check log file for the details. ***
[UNEXPECTED]Error while runPendingClone sub-routine is called
Stopping services on patch file system...
Stopping admin server...
You are running adadminsrvctl.sh version 120.10.12020000.9
The AdminServer is already shutdown
adadminsrvctl.sh: exiting with status 2
adadminsrvctl.sh: check the logfile
/u01/oracle/fs2/inst/apps/UAT_servername/logs/appl/admin/log/adadminsrvctl.txt
for more information ...
Stopping node manager...
You are running adnodemgrctl.sh version 120.11.12020000.11
The Node Manager is already shutdown
adnodemgrctl.sh: exiting with status 2
adnodemgrctl.sh: check the logfile
/u01/oracle/fs2/inst/apps/UAT_servername/logs/appl/admin/log/adnodemgrctl.txt
for more information ...
[ERROR] Prepare phase completed with errors or
warnings. Please check logfiles.
[STATEMENT] Please run adopscanlog utility, using the command
"adopscanlog -latest=yes"
to get the list of the log files along with snippet of the error
message corresponding to each log file.
adop exiting with status = 1 (Fail)
---------------------------------------------------------------------------------------------------------------------------
Resolution: Verified database settings before resolving above issues.
from DB server
Service "UAT1" has 1 instance(s).
Instance "UAT1", status READY, has 1 handler(s) for this service...
Service "UAT1_XPT" has 1 instance(s).
Instance "UAT1", status READY, has 1 handler(s) for this service...
Service "ebs_patch" has 1 instance(s).
Instance "UAT", status READY, has 1 handler(s) for this service...
The command completed successfully
---------------------------------------------------------------------------------------------------------------------
Verified Tns Entry for patch service
UAT_patch=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=servername)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=ebs_patch)
(INSTANCE_NAME=UAT)
)
)
IFILE=/u01/oraupg/fs2/inst/apps/UAT_servername/ora/10.1.2/network/admin/UAT_servername_ifile.ora
In the pfile local_listener was commented out, uncommented as per note 2007225.1 also added UAT_LOCAL.world entry in tnsnames.ora file
#########
# Service Parameters
#########
local_listener = UAT_LOCAL
#########
# NLS parameters
tnsnames.ora file changes.
UAT_LOCAL,UAT_LOCAL.world=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=testserver.com)(PORT=1521))
)
from DB server
Service "UAT1" has 1 instance(s).
Instance "UAT1", status READY, has 1 handler(s) for this service...
Service "UAT1_XPT" has 1 instance(s).
Instance "UAT1", status READY, has 1 handler(s) for this service...
Service "ebs_patch" has 1 instance(s).
Instance "UAT", status READY, has 1 handler(s) for this service...
The command completed successfully
---------------------------------------------------------------------------------------------------------------------
Verified Tns Entry for patch service
UAT_patch=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=servername)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=ebs_patch)
(INSTANCE_NAME=UAT)
)
)
IFILE=/u01/oraupg/fs2/inst/apps/UAT_servername/ora/10.1.2/network/admin/UAT_servername_ifile.ora
In the pfile local_listener was commented out, uncommented as per note 2007225.1 also added UAT_LOCAL.world entry in tnsnames.ora file
#########
# Service Parameters
#########
local_listener = UAT_LOCAL
#########
# NLS parameters
tnsnames.ora file changes.
UAT_LOCAL,UAT_LOCAL.world=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=testserver.com)(PORT=1521))
)
