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!