My Oracle Support Banner

Datapatch errors with "ORA-22308: operation not allowed on evolved type" (Doc ID 2907253.1)

Last updated on APRIL 17, 2023

Applies to:

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

Symptoms

After installing RU 19.17.0.0.0, while executing datapatch following errors are seen in logs

sqlpatch_invocation.log

Patch 31771877 rollback (pdb TSD): WITH ERRORS
  logfile: <ORACLE_BASE>/cfgtoollogs/sqlpatch/31771877/23869227/31771877_rollback_<SID>_2022Oct31_10_52_38.log (errors)
  -> Error at line 109127: script md/admin/catmdloc.sql
  - ORA-22308: operation not allowed on evolved type
  - ORA-06512: at line 12
  - ORA-06512: at line 4
  -> Error at line 127276: script md/admin/catmdloc.sql
  - ORA-22308: operation not allowed on evolved type
  - ORA-06512: at line 32
  - ORA-06512: at line 6



31771877_<rollback_SID>_2022Oct31_10_52_38.log

SQL> declare
2 begin
3 begin
4 execute immediate
5 'CREATE OR REPLACE TYPE SDO_GEOMETRY_ARRAY
6 TIMESTAMP ''2008-11-18:10:54:01''
7 OID ''5BF8B4041C603EAEE040578CB2051995''
8 AS VARRAY(10485760) OF MDSYS.SDO_GEOMETRY ';
9 exception
10 when others then
11 SYS.DBMS_SYSTEM.KSDWRT(SYS.DBMS_SYSTEM.TRACE_FILE,
12 'EXCEPTION[sdotypes.sql(' || $$PLSQL_LINE || ')65]: ' || SQLERRM); RAISE;
13 end;
14 begin
15 execute immediate
16 ' create or replace public synonym SDO_GEOMETRY_ARRAY for
17 MDSYS.SDO_GEOMETRY_ARRAY';
18 end;
19 end;
20 /
declare
*
ERROR at line 1:
ORA-22308: operation not allowed on evolved type
ORA-06512: at line 12
ORA-06512: at line 4


 

Changes

Installed 19.17 RU

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
Changes
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.