My Oracle Support Banner

ORA-39706: "schema 'SI_INFORMTN_SCHEMA' not found" During Upgrade From 8.1.7 To 10.2 (Doc ID 363998.1)

Last updated on FEBRUARY 14, 2022

Applies to:

Oracle Multimedia - Version 10.2.0.1 to 10.2.0.2 [Release 10.2]
Information in this document applies to any platform.
*** ***


Symptoms

  • Upgrading a database from 8.1.7 to 10.2 results in errors
  • Errors seen in the Oracle_Server.log are: 
        BEGIN dbms_registry.upgrading('ORDIM', NULL, 'validate_ordim', NULL, 
    dbms_registry.schema_list_t('ORDPLUGINS','SI_INFORMTN_SCHEMA')); END; 
    * 
    ERROR at line 1: 
    ORA-39706: schema 'SI_INFORMTN_SCHEMA' not found 
    ORA-6512: at "SYS.DBMS_SYS_ERROR", line 86 
    ORA-6512: at "SYS.DBMS_REGISTRY", line 71 
    ORA-6512: at "SYS.DBMS_REGISTRY", line 688 
    ORA-6512: at line 1
  • Selecting from DBA_REGISTRY reports interMedia still being in a pre-8.1.7 release after the upgrade has been completed: 
        select (substr(dbms_registry.version('ORDIM'), 1, 5)) from dual; 
   (SUBSTR(DBMS_RE 
    --------------- 
    8.1.6

Changes

Upgraded database from 8.1.7 to 10.2

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution
References

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