KU$ objects under SYS, CATPROC and ORDIM (Multimedia) Invalid after Applying PATCH 9858539 (Doc ID 1387147.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Multimedia - Version 11.2.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 21-Oct-2013***

Symptoms


KU$ objects under SYS, CATPROC and ORDIM (Multimedia) Invalid after Applying PATCH 9858539 DATA PUMP IMPORT FAILS FOR LOGON TRIGGER ORA-04072: INVALID TRIGGER TYPE on 11.2.0.3 Home

SQL> select object_type,object_name, owner from dba_objects where status ='INVALID' and owner ='SYS';

OBJECT_TYPE OBJECT_NAME OWNER
------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------
PACKAGE BODY DBMS_METADATA SYS
PACKAGE BODY DBMS_METADATA_DIFF SYS
VIEW KU$_10_1_AUDIT_VIEW SYS
VIEW KU$_10_2_FHTABLE_VIEW SYS
VIEW KU$_10_2_IND_STATS_VIEW SYS
VIEW KU$_10_2_STRMCOLTYPE_VIEW SYS
VIEW KU$_10_2_STRMCOL_VIEW SYS
VIEW KU$_10_2_STRMSUBCOLTYPE_VIEW SYS
VIEW KU$_10_2_STRMTABLE_VIEW SYS
VIEW KU$_10_2_TABLE_DATA_VIEW SYS
VIEW KU$_10_2_TAB_COL_VIEW SYS
VIEW KU$_10_2_TAB_STATS_VIEW SYS
VIEW KU$_ACPTABLE_VIEW SYS
VIEW KU$_BASE_PROC_OBJNUM_VIEW SYS
VIEW KU$_COLLECTION_VIEW SYS
VIEW KU$_DEPTABLE_OBJNUM_VIEW SYS
VIEW KU$_EDITION_OBJ_VIEW SYS
VIEW KU$_EDITION_SCHEMAOBJ_VIEW SYS
VIEW KU$_EQNTABLE_DATA_VIEW SYS
VIEW KU$_EXPREG SYS
VIEW KU$_EXP_XMLSCHEMA_VIEW SYS
VIEW KU$_MARKER_VIEW SYS
VIEW KU$_MV_DEPTBL_OBJNUM_VIEW SYS
VIEW KU$_NIOTABLE_DATA_VIEW SYS
VIEW KU$_OPTION_OBJNUM_VIEW SYS
VIEW KU$_OPTION_VIEW_OBJNUM_VIEW SYS
VIEW KU$_PKG_OBJNUM_VIEW SYS
VIEW KU$_PLUGTS_EARLY_TBLSP_VIEW SYS
VIEW KU$_PLUGTS_TSNAME_FULL_VIEW SYS
VIEW KU$_PLUGTS_TSNAME_INDEXP_VIEW SYS
VIEW KU$_PLUGTS_TSNAME_INDEX_VIEW SYS
VIEW KU$_PLUGTS_TSNAME_TABLE_VIEW SYS
VIEW KU$_REFPAR_LEVEL SYS
VIEW KU$_SCHEMAOBJNUM_VIEW SYS
VIEW KU$_SIMPLE_TYPE_VIEW SYS
VIEW KU$_TYPE_ATTR_VIEW SYS
VIEW KU$_XDB_NTABLE_OBJNUM_VIEW SYS
PACKAGE BODY KUPP$PROC SYS
PACKAGE BODY KUPW$WORKER

 

SQL> select comp_id, version, status from dba_registry;

COMP_ID VERSION STATUS
------------------------------ ------------------------------ ---------------------------------
XDB 11.2.0.3.0 VALID
AMD 11.2.0.3.0 VALID
CONTEXT 11.2.0.3.0 VALID
SDO 11.2.0.3.0 VALID
ORDIM 11.2.0.3.0 INVALID
CATALOG 11.2.0.3.0 VALID
CATPROC 11.2.0.3.0 INVALID
JAVAVM 11.2.0.3.0 VALID
CATJAVA 11.2.0.3.0 VALID
XML 11.2.0.3.0 VALID
RAC 11.2.0.3.0 VALID
APS 11.2.0.3.0 VALID
XOQ 11.2.0.3.0 VALID
ODM 11.2.0.3.0 VALID

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms