My Oracle Support Banner

ORA-38824 from Spatial Scripts When Running Datapatch (Doc ID 2703695.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

After applying a 19c DBRU via opatch, ORA-38824 errors are generated when datapatch runs Oracle Spatial (SDO) scripts:

Installing patches...
Patch installation complete. Total patches installed: 1

Validating logfiles...done
Patch _patchnumber_ apply: WITH ERRORS
   logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/_patchnumber_/24589353/_patchnumber__apply_TARSM_2022Mar03_08_09_13.log (errors)
   -> Error at line 70766: script md/admin/sdoutlh.sql
         - ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property
         - of an existing object.
   -> Error at line 71197: script md/admin/sdocs.sql
        - ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property
        - of an existing object.
        - ORA-06512: at line 17
        - ORA-06512: at line 8
   -> Error at line 72268: script md/admin/sdocs.sql
        - ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property
        - of an existing object.
...
...
   -> Error at line 123378: script md/admin/catsem.sql
         - ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property
         - of an existing object.
   -> Error at line 123414: script md/admin/catsem.sql
        - ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property
        - of an existing object.
   -> Error at line 123458: script md/admin/catsem.sql
        - ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property
        - of an existing object.

Please refer to MOS Note 1609718.1 and/or the invocation log
/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_18231_2022_03_03_08_08_43/sqlpatch_invocation.log
for information on how to resolve the above errors.

SQL Patching tool complete on Thu Mar 3 08:11:20 2022

 

Querying dba_objects shows multiple objects owned by MDSYS are INVALID:

 

Changes

The errors are seen during datapatch post-DBRU apply.

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.