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

Document ID : KB000084913
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.

Investigation

When using Oracle 12.1.0.2 with applications manager the following error may be found in the RmiServer logs:
 
jdbc:oracle:thin:@//Database:1521/AMPROD:AMPRODDB 
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 

 
Environment:
OS Version: N/A
Cause:
Cause type:
Defect
Root Cause: Bug in Oracle 12: 19450314 - UNNECESSRAY INVALIDATIONS IN 12C
Resolution:
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