Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Datapatch error for July RU for 12.2.0.1

edited Aug 1, 2019 2:28PM in Database Install/Upgrade/Opatch (MOSC) 6 commentsAnswered ✓

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center