ORA-4068 Errors for Valid Objects

(Doc ID 835792.1)

Last updated on MARCH 19, 2018

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.

This problem can occur on any platform.


-- Problem Statement:
Receiving error ORA-04068: Existing state of packages has been discarded errors even though the packages are valid.

Already at version which includes fix for <Bug 6136074>

We can see timestamp discrepancies exist for valid objects.

set pagesize 10000
column d_name format a20
column p_name format a20
select do.obj# d_obj,do.name d_name, do.type# d_type,
po.obj# p_obj,po.name p_name,
to_char(p_timestamp,'DD-MON-YYYY HH24:MI:SS') "P_Timestamp",
to_char(po.stime ,'DD-MON-YYYY HH24:MI:SS') "STIME",
decode(sign(po.stime-p_timestamp),0,'SAME','*DIFFER*') X
from sys.obj$ do, sys.dependency$ d, sys.obj$ po
where P_OBJ#=po.obj#(+)
and D_OBJ#=do.obj#
and do.status=1 /*dependent is valid*/
and po.status=1 /*parent is valid*/
and po.stime!=p_timestamp /*parent timestamp not match*/
order by 2,1; 

Example output:

SP_CALCULAR_CUSTO_MEDIO 5 82287 CEQ_SP_CALCULAR_CUSTO_MEDIO 09-ABR-2009 10:22:35 20-MAI-2009 19:59:00 *DIFFER* 

SP_ATUALIZA_ESTOQUE 5 82278 CNV_SP_ATUALIZA_ESTOQUE 09-ABR-2009 10:47:14 21-MAI-2009 01:27:43 *DIFFER*


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms