My Oracle Support Banner

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, d_name, do.type# d_type,
po.obj# p_obj, 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*


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.