ORA-04063: package body "APPS.AD_ZD_ADOP" has errors (DBD ERROR: OCIStmtExecute)

 ERROR :

++++++++++

servername[apposuser]_> time adop phase=fs_clone

Enter the APPS password:

Enter the SYSTEM password:

Enter the WLSADMIN password:

Validating credentials.

Initializing.

    Run Edition context  : /dbname/erpapp/122/fs1/inst/apps/dbname_servername/appl/admin/dbname_servername.xml

    Patch edition context: /dbname/erpapp/122/fs2/inst/apps/dbname_servername/appl/admin/dbname_servername.xml

    Patch file system free space: 251.39 GB

Validating system setup.

 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)    [UNEXPECTED]Error determining whether this is a multi-node instance

 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] 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 = 2 (Fail)

real    0m38.172s

user    0m7.350s

sys     0m1.430s

servername[apposuser]_>

Solution :

++++++++++

SQL> show user

USER is "SYS"

SQL>

SQL> alter package APPS.AD_ZD_ADOP compile body;

Warning: Package Body altered with compilation errors.

SQL>

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> grant execute on DBMS_METADATA_UTIL to apps;

Grant succeeded.

SQL> alter package APPS.AD_ZD_ADOP compile body;

Package body altered.

SQL>