My Oracle Support Banner

Upgrade Fail For Spatial Component With error ORA-39705: component 'ORDIM' not found in registry (Doc ID 2521349.1)

Last updated on OCTOBER 24, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.0.1 version, Upgrade failed for Spatial component with the error below :

Spatial
  ORA-29532: Java call terminated by uncaught Java exception:
  oracle.aurora.vm.IdNotFoundException: ORDSYS : user or role id does not exist


  ORA-39705: component 'ORDIM' not found in registry
  ORA-06512: at line 8
  ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
  ORA-06512: at "SYS.DBMS_REGISTRY", line 2532
  ORA-06512: at line 4


  ORA-29532: Java call terminated by uncaught Java exception:
  oracle.aurora.vm.IdNotFoundException: ORDSYS : user or role id does not exist

  ORA-29532: Java call terminated by uncaught Java exception:
  oracle.aurora.server.tools.loadjava.ToolsError:
  Error during loadjava: Failures occurred during processing.
   Check trace file for details
Spatial                                 INVALID      18.5.0.0.0  00:02:11


Error in catupgrd0.log :

21:37:48 SQL> call dbms_java.grant_permission('ORDSYS', 'SYS:java.lang.RuntimePermission',
21:37:48   2        'getClassLoader', null);
call dbms_java.grant_permission('ORDSYS', 'SYS:java.lang.RuntimePermission',
    *
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
oracle.aurora.vm.IdNotFoundException: ORDSYS : user or role id does not exist



Elapsed: 00:00:00.01
21:38:14 SQL>
21:38:14 SQL>
21:38:14 SQL> declare
21:38:14   2  begin
21:38:14   3   begin
21:38:14   4     dbms_registry.set_required_comps('SDO',dbms_registry.comp_depend_list_t('JAVAVM','XDB','ORDIM'));
21:38:14   5    exception
21:38:14   6      when others then
21:38:14   7        SYS.DBMS_SYSTEM.KSDWRT(SYS.DBMS_SYSTEM.TRACE_FILE,
21:38:14   8       'EXCEPTION[catmdh.sql(' || $$PLSQL_LINE || ')4]: ' || SQLERRM); RAISE;
21:38:14   9   end;
21:38:14  10  end;
21:38:14  11  /
declare
*
ERROR at line 1:
ORA-39705: component 'ORDIM' not found in registry
ORA-06512: at line 8
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_REGISTRY", line 2532
ORA-06512: at line 4

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
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.