While am executing the adop -status, The following got Error
[applmgr@devebsapp admin]$ adop -status
Enter the APPS password:
*******FATAL ERROR*******
PROGRAM : (/prodapps/applmgr/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME : Fri Mar 26 22:40:21 2021
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]
MESSAGES:
SQLPLUS error: buffer=
SQL*Plus: Release 10.1.0.5.0 – Production on Fri Jun 25 22:40:21 2021
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> SQL> Connected.
SQL> select ad_zd_adop.validate_session_id(”) from dual
*
ERROR at line 1:
ORA-04063: package body “APPS.AD_ZD_ADOP” has errors
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
STACK TRACE
at /prodapps/applmgr/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168
TXK::Error::abort(‘TXK::Error’, ‘HASH(0xd58f18)’) called at /prodapps/applmgr/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 299
TXK::Common::doError(‘TXK::SQLPLUS=HASH(0x2bf2ee0)’, ‘SQLPLUS error: buffer=x{a}x{a}SQL*Plus: Release 10.1.0.5.0 – Produc…’, undef) called at /prodapps/applmgr/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 314
TXK::Common::setError(‘TXK::SQLPLUS=HASH(0x2bf2ee0)’, ‘SQLPLUS error: buffer=x{a}x{a}SQL*Plus: Release 10.1.0.5.0 – Produc…’) called at /prodapps/applmgr/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 832
TXK::SQLPLUS::_doExecute(‘TXK::SQLPLUS=HASH(0x2bf2ee0)’, 0) called at /prodapps/applmgr/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 234
TXK::SQLPLUS::execute(‘TXK::SQLPLUS=HASH(0x2bf2ee0)’, ‘HASH(0x31ad498)’)called at /prodapps/applmgr/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 620
[applmgr@devebsapp applmgr]$ adop -validate
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Validating credentials.
Initializing.
Run Edition context : /prodapps/applmgr/fs1/inst/apps/DEV_devebsapp/appl/admin/DEV_devebsapp.xml
Patch edition context: /prodapps/applmgr/fs2/inst/apps/DEV_devebsapp/appl/admin/DEV_devebsapp.xml
Statement Handler Error Code: 4063
Statement Handler Error Message: ORA-04063: package body “APPS.AD_ZD_ADOP” has errors (DBD ERROR: OCIStmtExecute)
Reference of statement-handler is valid, not attempting database reconnect.
Failed to execute SQL statement:
select ad_zd_adop.validate_session_id(”) from dual
Error Message:
ORA-04063: package body “APPS.AD_ZD_ADOP” has errors (DBD ERROR: OCIStmtExecute)
Statement Handler Error Code: 4063
Statement Handler Error Message: ORA-04063: package body “APPS.AD_ZD_ADOP” has errors (DBD ERROR: OCIStmtExecute)
Reference of statement-handler is valid, not attempting database reconnect.
Failed to execute SQL statement:
select AD_ZD_ADOP.GET_INVALID_NODES() from dual
Error Message:
ORA-04063: package body “APPS.AD_ZD_ADOP” has errors (DBD ERROR: OCIStmtExecute)
[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)
[applmgr@devebsapp applmgr]$
Error : ORA-04063: package body “APPS.AD_ZD_ADOP” has errors
I have executed the following command
SQL> alter package APPS.AD_ZD_ADOP compile body;
Warning: Package Body altered with compilation errors.
SQL> show error;
Errors for PACKAGE BODY APPS.AD_ZD_ADOP:
LINE/COL ERROR
——– —————————————————————–
2691/3 PL/SQL: Statement ignored
2691/7 PLS-00201: identifier ‘SYS.DBMS_METADATA_UTIL’ must be declared
SQL>
Solution:
1. Complete the following commands:
SQL> grant execute on DBMS_METADATA_UTIL to apps;
Grant succeeded.
SQL> alter package APPS.AD_ZD_ADOP compile body;
Package body altered.
SQL> show error;
No errors.
2. Verify the Status of APPS.AD_ZD_ADOP package is valid.
[applmgr@devebsapp applmgr]$ adop -status
Enter the APPS password:
Connected.
==============================================================
ADOP (C.Delta.12)
Session Id: 4
Command: status
Output: /prodapps/applmgr/fs_ne/EBSapps/log/adop/4/20210627_003559/adzdshowstatus.out
===============================================================
Node Name Node Type Phase Status Started Finished Elapsed
————— ———- ————— ————— ——————– ——————– ————
devebsapp master APPLY COMPLETED 2021/06/24 12:01:00 2021/06/24 12:40:26 0:39:26
CLEANUP COMPLETED 2021/06/24 12:51:10 2021/03/24 13:52:04 1:00:54
File System Synchronization Type: None
adop exiting with status = 0 (Success)
[applmgr@devebsapp applmgr]$
Other Topics: