Multimedia upgrade errors from 11.2.0.2 to 11.2.0.4 (Doc ID 2127081.1)

Last updated on SEPTEMBER 28, 2023

Applies to:

Symptoms

dbupgdiag.sql reports :

  Validating Oracle Multimedia/interMedia...(no output if component status is
  valid)
  DECLARE
  *
  ERROR at line 1:
  ORA-06550: line 1, column 7:
  PLS-00905: object SYS.VALIDATE_ORDIM is invalid
  ORA-06550: line 1, column 7:
  PL/SQL: Statement ignored
  ORA-06512: at line 114

The multimedia component is valid:
  ORDIM Oracle Multimedia 11.2.0.2.0 VALID

The same errors was obtained during:
  SQL>execute validate_ordim;
  BEGIN validate_ordim; END;

  *
  ERROR at line 1:
  ORA-06550: line 1, column 7:
  PLS-00905: object SYS.VALIDATE_ORDIM is invalid
  ORA-06550: line 1, column 7:
  PL/SQL: Statement ignored

Below objects are INVALID

SYS@logdv1_1>SELECT OWNER, OBJECT_NAME, OBJECT_TYPE
2 FROM DBA_INVALID_OBJECTS
3 WHERE OWNER IN ('PUBLIC','SYS','SYSTEM','XDB','ORDSYS','ORDPLUGINS','ORDDATA','MDSYS','CTXSYS')
4 ORDER BY OWNER, OBJECT_NAME, OBJECT_TYPE;

OWNER OBJECT_NAME OBJECT_TYPE
-------------------- ---------------------------------------- -------------------
ORDDATA ORDDCM_CT_PRED_OPRD_USR VIEW
ORDDATA ORDDCM_DOCS_USR VIEW
ORDDATA ORDDCM_DOCUMENTS VIEW
ORDDATA ORDDCM_MAPPING_DOCS_USR VIEW
ORDSYS ORD_DICOM_ADMIN PACKAGE BODY
ORDSYS ORD_DICOM_ADMIN_PRV PACKAGE BODY
ORDSYS ORD_DICOM_CT PACKAGE BODY
PUBLIC ORDDCM_DOCUMENTS SYNONYM
SYS CWM2_OLAP_INSTALLER PACKAGE BODY
SYS VALIDATE_ORDIM PROCEDURE

Changes

Cause

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