ADZDDBCC after upgrade from 12.1.3 to 12.2.6 ORA-04021 ad.plsql.ad_zd_parallel_exec.execute (Doc ID 2596860.1)

Last updated on MAY 20, 2021

Applies to:

Goal

While running the ADZDDBCC report after upgrading instance from 12.1.3 to 12.2.6. getting the below messages at the end of the Section-1.
These messages doesn't contain any object name's or issue details. 

ad.plsql.ad_zd_parallel_exec.execute ERROR [CLEANUP 8:1 ddl_id=5221] ORA-04021: timeout occurred while waiting to lock object SQL: begin sys.ad_grants.cleanup; end;
ad.plsql.ad_zd_parallel_exec.execute ERROR [CLEANUP 1:1 ddl_id=5221] ORA-04021: timeout occurred while waiting to lock object SQL: begin sys.ad_grants.cleanup; end;
ad.plsql.ad_zd_parallel_exec.execute ERROR [CLEANUP 1:1 ddl_id=5221] ORA-04021: timeout occurred while waiting to lock object SQL: begin sys.ad_grants.cleanup; end;
ad.plsql.ad_zd_parallel_exec.execute ERROR [CLEANUP 1:1 ddl_id=5221] ORA-04021: timeout occurred while waiting to lock object SQL: begin sys.ad_grants.cleanup; end;
ad.bin.adop ERROR [CLEANUP 1:1 ddl_id=5221] ORA-04021: timeout occurred while waiting to lock object SQL: begin sys.ad_grants.cleanup; end;
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.