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 11.1.0.7.0 and later
Information in this document applies to any platform.
***Checked for relevance on 24-Apr-2013***

Symptoms

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.

COMP_ID  STATUS VERSION      COMP_NAME
-------  ------ ------------ ------------------------------
CATALOG  VALID   11.1.0.7.0   Oracle Database Catalog Views
CATJAVA  VALID   11.1.0.7.0   Oracle Database Java Packages
...
ORDIM    INVALID 11.1.0.7.0   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;

SDO_VERSION
------------------------------------

SQL>

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

SQL> set serveroutput on;
SQL> EXECUTE SYS.validate_ordim();
Locator INVALID OBJECTS: SAMCLUST_IMP_T - 5 - 14

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

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