My Oracle Support Banner

Database Upgrade for OEM repository fails with error:"ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property of an existing object" (Doc ID 2607261.1)

Last updated on NOVEMBER 04, 2019

Applies to:

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

Symptoms

 Database upgrade  from 12.1.0.2.0 to 18c of OEM repository failed. The  Upgrade procedure failed when  recreating SYSMAN objects .

catupgrd1.log shows:

SQL> CREATE OR REPLACE VIEW dbsnmp.mgmt_response_baseline AS
SELECT b.instance_number, s.sql_text, s.hash_value, v.address, s.t_per_exec
FROM dbsnmp.mgmt_baseline b, dbsnmp.mgmt_baseline_sql s, v$sqlarea v
WHERE b.instance_number = s.instance_number
AND s.hash_value = v.hash_value;
CREATE OR REPLACE VIEW dbsnmp.mgmt_response_baseline AS
                              *
ERROR at line 1:
ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property
of an existing object.

..

..



Changes

 

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.