Datapatch error for July RU for 12.2.0.1
Few of our databases got errors similar as following during datapatch for patch 29757449/23009673 (July RU for 12.2.0.1):
Error at line 23953: ORA-04045: errors during recompilation/revalidation of
Error at line 23955: ORA-01775: looping chain of synonyms
Wonder if any of you encountered the similar error and how you resolved it?
Following is an example:
SQL> begin
2 for invalid_object in
3 (select object_id
4 from dba_objects
5 where status = 'INVALID'
6 order by object_id)
7 loop
8 dbms_utility.validate(invalid_object.object_id);
9 end loop;
10 end;
11 /
begin
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of
FLOWS_FILES.WWV_BIU_FLOW_FILE_OBJECTS
ORA-01775: looping chain of synonyms