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

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

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 

 

Cause

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

Environment

OS Version: N/A

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