Queries Against Tables Protected by OLS Are Erroring Out
(Doc ID 577569.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.3 to 10.2.0.4
This problem can occur on any platform.
ORA-04045:errors during recompilation/revalidation of PUBLIC.RECYCLEBIN
ORA-04064:not executed, invalidated
ORA-04064:not executed, invalidated package body "LBACSYS.LBAC_EVENTS"
ORA-06508:PL/SQL:could not find program unit being called: "LBACSYS.LBAC_EVENTS"
This can happen in an environment where the OLS component is at version 10.2.0.1 whereas the rest of the database components are at version 10.2.0.3. The DBA_REGISTRY view is wrongly listing the OLS component as being at version 10.2.0.3 so using the output from DBA_REGISTRY as an evidence that OLS is at version 10.2.0.3 is not enough. One can get into this situation if OLS is enabled in a 10.2.0.3 database without re installing the 10.2.0.3 patchset.
It is possible to have the same symptoms in environments which do not fall in the above scenario, however the solution described below will solve those issues as well.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document