Invalid SAMCLUST_IMP_T Type Body after Upgrading to 11.1.0.x or 11.2.0.x

(Doc ID 783767.1)

Last updated on JULY 04, 2014

Applies to:

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


The database was upgraded from 10.2.0.x to 11.1.0.x (or to 11.2.0.x).
Log file from Pre-Upgrade Information Tool shows Oracle interMedia was VALID prior to the upgrade.

Components: [The following database components will be upgraded or installed]
--> Oracle Catalog Views         [upgrade]  VALID
--> Oracle Packages and Types    [upgrade]  VALID
--> JServer JAVA Virtual Machine [upgrade]  VALID
--> Oracle interMedia            [upgrade]  VALID

After the upgrade, dba_registry shows Oracle Multimedia is INVALID.

-------  ------ ------------ ------------------------------
CATALOG  VALID   Oracle Database Catalog Views
CATJAVA  VALID   Oracle Database Java Packages
ORDIM    INVALID   Oracle Multimedia

Spatial is NOT installed:

SQL> select comp_id, schema, version, status, comp_name
  2  from dba_registry
  3  where comp_id='SDO';

no rows selected

SQL>  select sdo_version from dual;



Output from SYS.validate_ordim() and DBA_OBJECTS indentify an INVALID type body:

SQL> set serveroutput on;
SQL> EXECUTE SYS.validate_ordim();

PL/SQL procedure successfully completed.

SQL> SELECT owner, object_name, object_type
  2  FROM dba_objects
  3  WHERE status = 'INVALID'
  4  ORDER BY owner, object_name, object_type;

OWNER                OBJECT_NAME                    OBJECT_TYPE
-------------------- ------------------------------ -------------------
MDSYS                SAMCLUST_IMP_T                 TYPE BODY


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