After EM Upgrade To 13.4, AWR Warehouse Uploads Cannot Be Run Or Disabled In EM Interface - EMDB-00763: Disabling Snapshot Upload failed for following targets: <Database Name> (Doc ID 2673234.1)

Last updated on NOVEMBER 16, 2022

Applies to:

Symptoms

After Upgrading from OEM 13.3 with AWR Warehouse configured and working,  to 13.4, AWR Warehouse Uploads cannot be run or disabled in Console Interface

Trying to disable uploads, receive an error message,

 Trying to correct the problem by executing the following sql against the AWR REPOS as the DBSNMP user. (NOT against the OMS Repository)

<Middleware_Home>/plugins/oracle.sysman.db.oms.plugin_XXXXX/sql/db/latest/caw/caw_load_pkgbody.sql

Does not resolve the issue due to errors 

cd $ORACLE_HOME/plugins/oracle.sysman.db.oms.plugin_13.4.1.0.0/sql/db/latest/caw/
sqlplus dbsnmp/<passwd>

SQL> @caw_load_pkgdef.sql

Package created.

No errors.
SQL> @caw_load_pkgbody.sql

Package body created.

No errors.
SQL> desc dbsnmp.CAW_SRC_ERRORS;
ERROR:
ORA-04043: object dbsnmp.CAW_SRC_ERRORS does not exist

SQL> set serveroutput on;
SQL> exec mgmt_caw_load.CREATE_SCHEMA;
error creating source dbs table: ORA-00955: name is already used by an existing
object
error creating source db intances table: ORA-00955: name is already used by an
existing object
error creating metadata table: ORA-00955: name is already used by an existing
object
error creating index metadata table: ORA-00955: name is already used by an
existing object
error creating errors table: ORA-00955: name is already used by an existing
object
error creating mapping table: ORA-00955: name is already used by an existing
object
error creating space usage table: ORA-00955: name is already used by an existing
object
error creating properties table: ORA-00955: name is already used by an existing
object
error creating grants table: ORA-00955: name is already used by an existing
object
error creating workers table: ORA-00955: name is already used by an existing
object
error creating dbid sequence: ORA-01031: insufficient privileges
error creating mapping id sequence: ORA-01031: insufficient privileges
error creating dump id sequence: ORA-01031: insufficient privileges
error creating em id sequence: ORA-01031: insufficient privileges
error creating source id sequence: ORA-01031: insufficient privileges
error creating source id sequence: ORA-01031: insufficient privileges
error creating src sequence: ORA-01031: insufficient privileges
error creating src id sequence: ORA-01031: insufficient privileges
error creating src dump id sequence: ORA-01031: insufficient privileges
error renaming caw_space_usage.delta_size_mb: ORA-00054: resource busy and
acquire with NOWAIT specified or timeout expired
error creating caw_space_usage.delta_size_mb: ORA-00054: resource busy and
acquire with NOWAIT specified or timeout expired
error creating caw_src_dbs.num_loadnow_snaps: ORA-01430: column being added
already exists in table

PL/SQL procedure successfully completed.

SQL>
SQL> desc dbsnmp.CAW_SRC_ERRORS;
Name Null? Type
----------------------------------------- -------- ----------------------------
DUMP_ID NUMBER
ERROR_MSG VARCHAR2(4000 CHAR)
LOG_FILE VARCHAR2(2000 CHAR)
LAST_UPDATED TIMESTAMP(6)

Changes

 Upgraded OEM from 13.3 to 13.4.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.