Comp_id 'SDO' Is Missing In Dba_Registry Though Locator Has Been Installed
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Spatial and Graph - Version 22.214.171.124 and later
Information in this document applies to any platform.
comp_id 'SDO' is missing in dba_registry though Locator has been installed
A software vendors (Bentley) is using 'select sdo_version from dual' to check whether Locator functionality is available.
Unfortunately, this query returns NULL because the instance has no comp_id = 'SDO' in the dba_registry.
It contains only CATALOG, CATPROC, OWM, JAVAVM, XML, CATJAVA, EXF, XDB, RUL, ORDIM, EM, CONTEXT.
The situation is that neither our application vendor is able to change his application nor am I willing to tweak the function mdsys.SDO_VERSION.
We provided workaround to customer to return the 126.96.36.199.0 string but he didn't like to hardcode so we provided one based on ORDIM
conn / as sysdba
alter session set current_schema=MDSYS;
create or replace function SDO_VERSION
return varchar2 DETERMINISTIC PARALLEL_ENABLE as
select VERSION into sdo_verno
from dba_registry where comp_id = 'ORDIM';
Still customer is hesitant to use this workaround and would like Oracle to modify the SDO_VERSION function to deal with the case where Locator is installed but not Spatial.
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