My Oracle Support Banner

ORA-29832, ORA-04045, PLS-500 During Upgrade of Spatial (Doc ID 2824661.1)

Last updated on APRIL 07, 2022

Applies to:

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

Symptoms

Errors were generated during upgrade of Oracle Spatial (SDO). The catupgr0.log shows:

------------------------------------------------------
Identifier SDO 21-11-23 05:04:34
SCRIPT = [/u01/oracle/19.0.0/md/admin/sdomigrt.sql]
ERROR = [ORA-29832: cannot drop or replace an indextype with dependent indexes ORA-06512: at line 27
ORA-06512: at line 22
]
...
<snip>
...
begin
execute immediate ' drop operator mdsys.RTREE_nn';
exception
when others then
SYS.DBMS_SYSTEM.KSDWRT(SYS.DBMS_SYSTEM.TRACE_FILE,
'EXCEPTION[sdomigrt.sql(' || $$PLSQL_LINE || ')224]: ' || SQLERRM); RAISE;
end;
begin
execute immediate 'drop public synonym SDO_RTREE_ADMIN';
exception
when others then
SYS.DBMS_SYSTEM.KSDWRT(SYS.DBMS_SYSTEM.TRACE_FILE,
'EXCEPTION[sdomigrt.sql(' || $$PLSQL_LINE || ')225]: ' || SQLERRM); RAISE;
end;
end;]
------------------------------------------------------
------------------------------------------------------
Identifier SDO 21-11-23 05:04:34
SCRIPT = [/u01/oracle/19.0.0/md/admin/sdomigrt.sql]
ERROR = [ORA-06512: at line 27 ORA-06512: at line 22
]
STATEMENT = [as above]
------------------------------------------------------
------------------------------------------------------
Identifier SDO 21-11-23 05:04:34
SCRIPT = [/u01/oracle/19.0.0/md/admin/sdomigrt.sql]
ERROR = [ORA-06512: at line 22]
STATEMENT = [as above]
------------------------------------------------------
------------------------------------------------------
Identifier SDO 21-11-23 05:06:33
SCRIPT = [/u01/oracle/19.0.0/md/admin/prvtrtr.plb]
ERROR = [ORA-04045: errors during recompilation/revalidation of MDSYS.RTREE_NN ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-500: invalid operator binding
]
STATEMENT = [GRANT EXECUTE ON rtree_nn TO PUBLIC]
------------------------------------------------------
------------------------------------------------------
Identifier SDO 21-11-23 05:06:33
SCRIPT = [/u01/oracle/19.0.0/md/admin/prvtrtr.plb]
ERROR = [ORA-06552: PL/SQL: Compilation unit analysis terminated ORA-06553: PLS-500: invalid operator binding
]
STATEMENT = [as above]
------------------------------------------------------
------------------------------------------------------
Identifier SDO 21-11-23 05:06:33
SCRIPT = [/u01/oracle/19.0.0/md/admin/prvtrtr.plb]
ERROR = [ORA-06553: PLS-500: invalid operator binding]
STATEMENT = [as above]
------------------------------------------------------

 

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


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