ORA-29832, ORA-04045, PLS-500 During Upgrade of Spatial
(Doc ID 2824661.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Spatial and Graph - Version 19.3.0.0.0 and laterInformation 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]
------------------------------------------------------
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 |