ORA-04068: existing state of packages has been discarded

Cause: java.sql.SQLException: ORA-04068: existing state of packages has been discarded ORA-04061: existing state of package “XXX” has been invalidated

ORA-04065: not executed, altered or dropped package “XXXXX”

ORA-06508: PL/SQL: could not find program unit being called: “XXX” ORA-06512: at line 1

 

Recompilation is resulting in invalidation of packages by database for existing database sessions related to ICS.

Avoid recompilation of packages during the working hours and plan such all migrations at once during the weekend.

Hope next execution of ICS integration run should be fine, if not, restarting Agent is the solution at the moment or contact Oracle Support.

 

Thank you !!