ADOP STATUS – FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ] Solution.

Problem :

[ebsprd@myebstes01 ~]$ adop -status

Enter the APPS password:
*******FATAL ERROR*******
PROGRAM : (/u01/app/ebs/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME : Fri Aug 27 03:42:33 2021
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]
MESSAGES:
SQLPLUS error: buffer=

SQL*Plus: Release 10.1.0.5.0 – Production on Fri Aug 27 03:42:33 2021

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, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options

STACK TRACE
at /u01/app/ebs/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168
TXK::Error::abort(‘TXK::Error’, ‘HASH(0x19573a8)’) called at /u01/app/ebs/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 299
TXK::Common::doError(‘TXK::SQLPLUS=HASH(0x37625e8)’, ‘SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 – Produc…’, undef) called at /u01/app/ebs/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 314
TXK::Common::setError(‘TXK::SQLPLUS=HASH(0x37625e8)’, ‘SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 – Produc…’) called at /u01/app/ebs/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 832
TXK::SQLPLUS::_doExecute(‘TXK::SQLPLUS=HASH(0x37625e8)’, 0) called at /u01/app/ebs/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 234
TXK::SQLPLUS::execute(‘TXK::SQLPLUS=HASH(0x37625e8)’, ‘HASH(0x33a0808)’) called at /u01/app/ebs/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 620
TXK::TechstackDB::_getSQLValue(‘TXK::TechstackDB=HASH(0x3795eb8)’, ‘ select ad_zd_adop.validate_session_id(\’\’) from dual\x{a}’) called at /u01/app/ebs/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 573
TXK::TechstackDB::getSQLValue(‘TXK::TechstackDB=HASH(0x3795eb8)’, ‘ select ad_zd_adop.validate_session_id(\’\’) from dual\x{a}’) called at /u01/app/ebs/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 507
ADOP::GlobalVars::_getADOPStatus(undef, undef) called at /u01/app/ebs/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 2468
ADOP::GlobalVars::_ValidateArgs() called at /u01/app/ebs/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 3373
ADOP::GlobalVars::ValidateArgs(‘ADOP::GlobalVars’) called at /u01/app/ebs/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/AdopMain.pm line 1906
ADOP::AdopMain::adopMain(‘ADOP::AdopMain’) called at /u01/app/ebs/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl line 148

[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)
[ebsprd@myebstes01 ~]$

Workaround:

To fix the issue I checked in the db level.

SQL> alter package APPS.AD_ZD_ADOP compile body;

Warning: Package Body altered with compilation errors.

SQL> show err

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

Note : Apps user not able to access the “SYS.DBMS_METADATA_UTIL”

So I granted the access by executing the below command and compiled the package.

As sys user:

SQL> grant execute on DBMS_METADATA_UTIL to apps;

As apps user:

SQL> alter package APPS.AD_ZD_ADOP compile body;

Package body altered.

SQL> show err
No errors.
SQL> exit

After fixing the issue. I checked the status It went fine without any issue

[ebsprd@myebstes01 ~]$ adop -status

Enter the APPS password:
Connected.
==============================================================
ADOP (C.Delta.12)
Session Id: 30
Command: status
Output: /u01/app/ebs/fs_ne/EBSapps/log/adop/30/20210827_035802/adzdshowstatus.out
===============================================================
Node Name Node Type Phase Status Started Finished Elapsed
————— ———- ————— ————— ——————– ——————– ————
myebstes01 master PREPARE COMPLETED 2021/08/20 09:54:35 2021/08/20 10:03:13 0:08:38
APPLY COMPLETED 2021/08/20 11:16:32 2021/08/20 15:07:33 3:51:01
FINALIZE COMPLETED 2021/08/20 16:48:31 2021/08/20 16:57:14 0:08:43
CUTOVER COMPLETED 2021/08/20 20:24:07 2021/08/20 20:30:36 0:06:29
CLEANUP COMPLETED 2021/08/20 20:38:23 2021/08/20 20:56:40 0:18:17

File System Synchronization Type: Full

adop exiting with status = 0 (Success)
[ebsprd@myebstes01 ~]$

Thanks for reading this post.

Pushparaj Vijayan