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

Last updated on JULY 20, 2024

Applies to:

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

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