Locator is Not Upgraded during Database Upgrade from 9.2 to 10.2 or to 11.2.0.1 / 11.2.0.2 / 11.2.0.3 (Doc ID 1091950.1)

Last updated on DECEMBER 11, 2014

Applies to:

Oracle Spatial and Graph - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

While upgrading a Oracle 9.2.0.4 database with Oracle Intermedia/Locator to 10gR2, 10.2.0.4, found that after the upgrade, although the Oracle Intermedia product shows up as 'VALID' but seems that the Locator related objects in MDSYS schema are NOT upgraded.

Per document <Note 357943.1>, in Oracle 9iR2, when Oracle Locator/Oracle Intermedia is installed, there is an entry in the DBA_REGISTRY for Spatial as well. In Oracle 10g/11g, when Locator/Intermedia is installed, there is no entry in the registry for Spatial.

I was looking at the Intermedia scripts that gets invoked as part of the DBUA upgrade. The script in question, '?/ord/im/admin/imdbmig.sql', had the following logic:

declare
mdsyscnt NUMBER := 0;
begin
-- Check whether MDSYS exists.
-- If not, Do not upgrade Locator
select count(*) into mdsyscnt from dba_users where username='MDSYS';
-- Check whether SDO is installed.
-- If not, upgrade Locator
if ((dbms_registry.is_valid('SDO') is NULL) and (mdsyscnt > 0)) then
:script_name := '?/md/admin/locdbmig.sql';
else
:script_name := '?/rdbms/admin/nothing.sql';
end if;
end;
/


It seems that the locator upgrade script will get skipped if there is already an 'SDO' entry in the registry. Since all Intermedia installs on 9.2.0.x will have an 'SDO' entry in the registry, the logic seem to indicate that 9i to 10g upgrades will always skip upgrading the Locator if Intermedia (Oracle Multimedia) is installed.

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