Oracle 12c bug causing ORA-04068 errors to be written to RmiServer log


Article ID: 84913


Updated On:


CA Automic Applications Manager (AM)


Error Message :
ORA-04068: existing state of packages has been discarded

An Oracle 12c defect causes the above error message to appear in the RmiServer logs.


When using Oracle with applications manager the following error may be found in the RmiServer logs:
java.sql.SQLException: ORA-04068: existing state of packages has been discarded 
ORA-04061: existing state of package body "AMPRODDB .AWAPI2" has been invalidated 
ORA-04065: not executed, altered or dropped package body "AMPRODDB .AWAPI2" 
ORA-06508: PL/SQL: could not find program unit being called: "AMPRODDB .AWAPI2" 
ORA-06512: at "AMPRODDB .UPD_BP", line 28 
ORA-06512: at line 1 



Cause type:
Root Cause: Bug in Oracle 12: 19450314 - UNNECESSRAY INVALIDATIONS IN 12C


OS Version: N/A


As this is an Oracle product issue and not an Automic product issue, have your Database Administrator install the patch for Oracle bug: 19450314 - UNNECESSRAY INVALIDATIONS IN 12C.

The patch along with additional information about the bug can be found using the following link to Oracle:  Patch 19450314: UNNECESSARY INVALIDATIONS IN 12C


Fix Status: No Fix

Additional Information

Workaround :
The following steps will provide a temporary work around:
  1. Stop all processes rerun awinstall option 1, and allow to finish.
  2. Once finished do not exit, but recompile the objects using awinstall by running the following: 
  • Select option 3 Data checks 
  • Select option 2 Check for invalid objects 
  • Press return to continue 
  • Select option 4 Setups 
  • Select option 5 Recompile invalid objects 
  • Select option q Quit