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 laterInformation 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 |