Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

SYS Owned Package Invalid !

edited Mar 24, 2017 5:00AM in Database Install/Upgrade/Opatch (MOSC) 3 commentsAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center