My Oracle Support Banner

ORA-04045 ORA-04043 While installing Oracle Multimedia and Oracle Spatial (Doc ID 2614281.1)

Last updated on APRIL 12, 2022

Applies to:

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

Symptoms

Oracle Spatial installation failed due to the following errors:

GRANT EXECUTE ON MDSYS.ST_POINT         to PUBLIC WITH GRANT OPTION
                      *
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of MDSYS.ST_POINT
ORA-06545: PL/SQL: compilation error - compilation aborted


GRANT EXECUTE ON MDSYS.ST_CURVE         to PUBLIC WITH GRANT OPTION
                      *
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of MDSYS.ST_CURVE
ORA-06545: PL/SQL: compilation error - compilation aborted


GRANT EXECUTE ON MDSYS.ST_SURFACE         to PUBLIC WITH GRANT OPTION
                      *
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of MDSYS.ST_SURFACE
ORA-06545: PL/SQL: compilation error - compilation aborted


GRANT EXECUTE ON MDSYS.ST_CURVEPOLYGON         to PUBLIC WITH GRANT OPTION
                      *
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of MDSYS.ST_CURVEPOLYGON
ORA-06545: PL/SQL: compilation error - compilation aborted

SYS@p1cy2d80:SQL> drop type ST_DOUBLE_PRECISION_ARRAY;
drop type ST_DOUBLE_PRECISION_ARRAY
*
ERROR at line 1:
ORA-04043: object ST_DOUBLE_PRECISION_ARRAY does not exist

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.