SYS Owned Package Invalid !
Greetings!
we need to apply patch 10205 then subsequent upgrade to 11204, currently we are at 10201.
any suggestions about how to make below VALID before proceeding further ?
SQL> select OBJECT_NAME,SUBOBJECT_NAME,OBJECT_TYPE,CREATED,LAST_DDL_TIME,TIMESTAMP,TEMPORARY,GENERATED,SECONDARY from dba_objects
2 where status='INVALID' and owner='SYS';
OBJECT_NAME
--------------------------------------------------------------------------------
SUBOBJECT_NAME OBJECT_TYPE CREATED
------------------------------ ------------------- -------------------
LAST_DDL_TIME TIMESTAMP T G S
------------------- ------------------- - - -
PACKAGE
PACKAGE BODY 2015-05-04 10:27:15
2017-03-15 13:04:55 2017-03-15:13:04:55 N N N
3 components also found Invalid in DBA_REGISTRY:-
COMP_ID VERSION STATUS
------------------------------ ------------------------------ -----------
ODM 10.2.0.1.0 INVALID