My Oracle Support Banner

Datapatch for 18.9 DBRU fails with ORA-38824: A CREATE OR REPLACE Command May Not Change The EDITIONABLE Property (Doc ID 2731315.1)

Last updated on NOVEMBER 23, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 18.9.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Datapatch for the 18.9 DBRU (Patch 30480385) fails with the following error:

Validating logfiles...done
Patch 30480385 apply: WITH ERRORS
logfile: /oradb/appl/oracle/cfgtoollogs/sqlpatch/30480385/23306198/30480385_apply_DWINA_2020Apr09_14_17_40.log (errors)
-> Error at line 19429: script rdbms/admin/prvtxdbz.plb
- ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property
- of an existing object.
-> Error at line 19445: script rdbms/admin/prvtxdbz.plb
- ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property
- of an existing object.
-> Error at line 19474: script rdbms/admin/prvtxdb.plb
- ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property
- of an existing object.

All database components are VALID and there are no invalid objects.

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.