ORA-04061/ORA-04065/ORA-06508
531473Oct 8 2009 — edited Nov 3 2009I've been battling with this for almost 4 hours, have tried all (that I could fine) proposed solutions on OTN but cannot for the life of me figure out what's going on.
"ORA-04061: existing state of package "INTEGRATE.SCHEDULER" has been invalidated
ORA-04065: not executed, altered or dropped package "INTEGRATE.SCHEDULER"
ORA-06508: PL/SQL: could not find program unit being called: "INTEGRATE.SCHEDULER"
"
SELECT object_name, object_type, owner, status, last_ddl_time FROM dba_objects WHERE object_name = 'SCHEDULER';
SCHEDULER SYNONYM COMPINTR VALID 08-OCT-09
SCHEDULER SYNONYM APPLINTR VALID 08-OCT-09
SCHEDULER PACKAGE INTEGRATE VALID 08-OCT-09
SCHEDULER PACKAGE BODY INTEGRATE VALID 08-OCT-09
SELECT object_name, object_type, owner, status, last_ddl_time FROM
dba_objects WHERE ( object_name, object_type ) IN ( SELECT
referenced_name, referenced_type FROM dba_dependencies WHERE name =
'SCHEDULER' );
DUAL SYNONYM PUBLIC VALID 26-DEC-08
STANDARD PACKAGE SYS VALID 26-DEC-08
DBMS_UTILITY SYNONYM PUBLIC VALID 26-DEC-08
DBMS_OUTPUT SYNONYM PUBLIC VALID 26-DEC-08
DBMS_SCHEDULER SYNONYM PUBLIC VALID 26-DEC-08
ALL_SCHEDULER_JOBS SYNONYM PUBLIC VALID 06-MAR-09
ALL_SCHEDULER_JOB_LOG SYNONYM PUBLIC VALID 06-MAR-09
ALL_SCHEDULER_RUNNING_JOBS SYNONYM PUBLIC VALID 06-MAR-09
TYPES TABLE INTEGRATE VALID 12-MAR-09
TYPE_GROUPS TABLE INTEGRATE VALID 12-MAR-09
TYPES TABLE XVERT VALID 05-FEB-09
TYPE_GROUPS TABLE XVERT VALID 05-FEB-09
SCHEDULER PACKAGE INTEGRATE VALID 08-OCT-09
RUN_PLAN_SEQ SEQUENCE INTEGRATE VALID 30-SEP-09
In addition, I removed all global variables, tried PRAGMA SERIAL_REUSABLE, and ran the following query with no results:
select do.obj# d_obj,do.name d_name,
po.obj# p_obj,po.name p_name,
to_char(p_timestamp,'DD-MM-YYYY HH24:MI:SS') p_timestamp,
to_char(po.stime ,'DD-MM-YYYY HH24:MI:SS') stime,
decode(sign(po.stime-p_timestamp),0,'SAME','*DIFFER*') X,
do.type#,po.type#
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;
Any help is appreciated.
Thanks,
Joe