OID Repository Database Upgrade Pre-Upgrade Check Found Invalid Objects (Owned by SYS) (Doc ID 2191509.1)

Last updated on OCTOBER 03, 2023

Applies to:

Goal

Oracle Internet Directory (OID).

OID Repository database upgrade pre-upgrade check found some invalid objects.

While preparing OID repository database for 12c upgrade, one of the upgrade pre-checks to verify invalid objects in the database found several objects are in "INVALID" status, for example:

  1* select owner,object_name,object_type from dba_objects where status='INVALID'
OWNER  OBJECT_NAME      OBJECT_TYPE
------ ---------------- -------------
SYS    ASRTOLDAP        PACKAGE BODY
SYS    BLKDEL           PACKAGE BODY
SYS    BLKLOAD          PACKAGE BODY
SYS    BLKMOD           PACKAGE BODY
SYS    CATMGMT          PACKAGE BODY
SYS    CATMGMT          PACKAGE
SYS    DELETEV8         PACKAGE BODY
SYS    ENTRYBACKUPRECOV PACKAGE
SYS    ENTRYBACKUPRECOV PACKAGE BODY
SYS    LDAPUPGUTLS      PACKAGE BODY
SYS    MANAGEHIQ        PACKAGE
SYS    MANAGEHIQ        PACKAGE BODY
SYS    MODIFYDN         PACKAGE
SYS    MODIFYDN         PACKAGE BODY
SYS    OIDRIPKG         PACKAGE
SYS    OIDRIPKG         PACKAGE BODY
SYS    OIDSECEVENTS     PACKAGE BODY
SYS    OIDSECEVENTS     PACKAGE
SYS    OID_STATS        PACKAGE
SYS    OID_STATS        PACKAGE BODY
SYS    OLADD            PACKAGE BODY
SYS    OLDELETE         PACKAGE BODY
SYS    PURGEADMIN       PACKAGE BODY
SYS    REPLEMUTLS       PACKAGE BODY
SYS    TSPURGE          PACKAGE BODY

25 rows selected.


How to make these package/bodies valid?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.