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 10.2.0.4 and later
Information in this document applies to any platform.

This problem can occur on any platform.

Symptoms

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

Already at version 10.2.0.4 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*

Cause

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
Symptoms
Cause
Solution
References


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.