Patch Reviews - DB (MOSC)

MOSC Banner

Invalid packages after upgrading 9.2.0.7 database to 9.2.0.8

edited May 2, 2011 2:24AM in Patch Reviews - DB (MOSC) 3 commentsAnswered
I have upgraded a 9.2.0.7 database to 9.2.0.8 (so that I can eventually upgrade to 11g).  I noticed the following packages as invalid in the 9.2.0.8 database.  Tried to run utlrp.sql  but no use.

OWNER      OBJECT_NAME          OBJECT_TYPE        STATUS
---------- -------------------- ------------------ -------
SYS        DBMS_CDC_PUBLISH     PACKAGE BODY       INVALID
SYS        DBMS_CDC_SUBSCRIBE   PACKAGE BODY       INVALID
SYS        DBMS_CDC_UTILITY     PACKAGE BODY       INVALID
SYS        DBMS_REPCAT_RGT      PACKAGE BODY       INVALID
SYS        DBMS_SQLJTYPE        PACKAGE BODY       INVALID
SYS        DBMS_SUMADVISOR      PACKAGE BODY       INVALID

6 rows selected.

Please advise. Thanks!

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