R12.2 Apps DBA. Powered by Blogger.

adop phase=cleanup Failed

No comments :
Log: @ADZDSHOWLOG.sql "2015/05/14 19:21:47"
    [ERROR]     Failed to execute SQL statement :
       begin
        execute immediate 'alter session set DDL_LOCK_TIMEOUT = 600';
        ad_zd.cleanup('STANDARD');
      end;
    [ERROR]     Error Message :
    [UNEXPECTED]Error occurred while calling cleanup plsql API
    [UNEXPECTED]Cleanup phase completed with errors/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)
SQL> select count(*) from dba_obJects where status='INVALID' AND object_name like 'AD%';
  COUNT(*)
----------
         1
SQL> SQL> select object_name from dba_obJects where status='INVALID' AND object_name like 'AD%';
OBJECT_NAME
--------------------------------------------------------------------------------
AD_ZD_TABLE
SQL> alter package apps.AD_ZD_TABLE compile;
Warning: Package altered with compilation errors.
SQL> alter package apps.AD_ZD_TABLE compile body;
Warning: Package Body altered with compilation errors.
Solution:
SQL> @/ad_TXK_patches_delta_6/19197270/admin/adgrants.sql APPS
Connected.
then compile the object.
SQL> alter package apps.AD_ZD_TABLE compile;
Package altered.
SQL> alter package apps.AD_ZD_TABLE compile body;
Package body altered.

No comments :

Post a Comment

Note: only a member of this blog may post a comment.