ORA-04063: package body “APPS.AD_ZD_ADOP” has errors when Running adop -status

 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:
 
 

Leave a Comment

Your email address will not be published. Required fields are marked *