Installation of Oracle Spatial in 12c generates errors (Doc ID 2109068.1)

Last updated on APRIL 08, 2022

Applies to:

Symptoms

After creating a container database and a portable database without any error during the creation, the script sdoupggeom.sql is executed running:

sqlplus / as sysdba
alter pluggable database all open;
exit

perl "${ORACLE_HOME}/rdbms/admin/catcon.pl" -l "${LOG_BOOK}" -u sys/oracle -s -e -b sdoupggeom.log "${ORACLE_HOME}/md/admin/sdoupggeom.sql"
or
perl $ORACLE_HOME/rdbms/admin/catcon.pl -e -E ON -n 1 -l $LOGBOOK -b spatial_sdoupggeom $ORACLE_HOME/md/admin/sdoupggeom.sql;

But it raises errors:
SQL> create or replace type body sdo_index_method_10i wrapped
....
Warning: Type Body created with compilation errors.
Errors for TYPE BODY SDO_INDEX_METHOD_10I:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1/11 PLS-00304: cannot compile body of 'SDO_INDEX_METHOD_10I' without its specification
1/11 PLS-00905: object MDSYS.SDO_INDEX_METHOD_10I is invalid

Many
ORA-01775: looping chain of synonyms
executing statements
grant execute on <mdsys object> to public with grant option;

Plus some other errors.

and it ends with following invalid objects:
select owner, object_name, object_type from cdb_invalid_objects

OWNER OBJECT_NAME OBJECT_TYPE
-------------------- ---------------------------------------- ------------------------------
APEX_040200 WWV_FLOW_SPATIAL_API PACKAGE
APEX_040200 WWV_FLOW_SPATIAL_API PACKAGE BODY
MDSYS RTREE_FILTER OPERATOR
MDSYS RTREE_NN OPERATOR
.... many PUBLIC synonyms poiting to MDSYS' objects

Changes

Cause

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