My Oracle Support Banner

DBUA fails and does not complete due to ORA-02303 from sdoseminfmh.plb (Doc ID 2808442.1)

Last updated on SEPTEMBER 20, 2021

Applies to:

Oracle Spatial and Graph - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

DBUA fails and does not complete the post upgrade steps due to (ignorable) ORA-02303 from sdoseminfmh.plb:

Identifier SDO 21-09-08 05:11:38
SCRIPT    = [/u01/oracle/product/19c/md/admin/sdoseminfmh.plb]
ERROR     = [ORA-02303: cannot drop or replace a type with type or table dependents]
STATEMENT = [create or replace type sem_term wrapped

Component                               Current         Full     Elapsed Time
Name                                    Status          Version  HH:MM:SS
Oracle Server                          UPGRADED     19.11.0.0.0  00:12:58
JServer JAVA Virtual Machine              VALID     19.11.0.0.0  00:01:36
Oracle XDK                             UPGRADED     19.11.0.0.0  00:01:17
Oracle Database Java Packages          UPGRADED     19.11.0.0.0  00:00:13
OLAP Analytic Workspace                UPGRADED     19.11.0.0.0  00:00:16
Oracle Label Security                  UPGRADED     19.11.0.0.0  00:00:07
Oracle Database Vault                  UPGRADED     19.11.0.0.0  00:00:41
Oracle Text                            UPGRADED     19.11.0.0.0  00:00:46
Oracle Workspace Manager               UPGRADED     19.11.0.0.0  00:00:46
Oracle Real Application Clusters       UPGRADED     19.11.0.0.0  00:00:00
Oracle XML Database                    UPGRADED     19.11.0.0.0  00:01:19
Oracle Multimedia                      UPGRADED     19.11.0.0.0  00:00:30
Spatial
    ORA-02303: cannot drop or replace a type with type or table dependents
    ORA-02303: cannot drop or replace a type with type or table dependents
    ORA-02303: cannot drop or replace a type with type or table dependents
Spatial                                 INVALID     19.11.0.0.0  00:04:04
Oracle OLAP API                         INVALID     19.11.0.0.0  00:00:13
Datapatch                                                        00:03:10
Final Actions                                                    00:03:13
Post Upgrade                                                     00:00:34

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.