My Oracle Support Banner

EM13c : AWR Warehoure Package Update Jobs Fails - ORA-20411 (Doc ID 2897345.1)

Last updated on SEPTEMBER 20, 2022

Applies to:

Enterprise Manager for Oracle Database - Version 13.4.1.0.0 and later
Information in this document applies to any platform.

Symptoms

In Enterprise Manager (EM) Cloud Control, AWR Warehouse Packages are out of date. Update Job submitted and got failed with ORA-20411 error.

Job Output Log:

Applying upgrade prereqs...
Executing: begin
-- create essential synonyms
execute immediate 'create or replace public synonym CAW_LOAD_WORKERS for DBSNMP.CAW_LOAD_WORKERS';
execute immediate 'create or replace public synonym CAW_SRC_DBS for DBSNMP.CAW_SRC_DBS';
execute immediate 'create or replace public synonym CAW_PROPERTIES for DBSNMP.CAW_PROPERTIES';
execute immediate 'create or replace public synonym CAW_SRC_PROPERTIES for DBSNMP.CAW_SRC_PROPERTIES';
end;
Error during Upgrade: ORA-20411: The following parameters have a NULL value: extractInterval, dest_dir
ORA-06512: at "SYSMAN.EM_JOB_OPS", line 307
ORA-06512: at "SYSMAN.EM_JOB_PARAM", line 3452
ORA-06512: at "SYSMAN.EM_JOB_PARAM", line 3514
ORA-06512: at "SYSMAN.EM_JOB_PARAM", line 3530
ORA-06512: at "SYSMAN.EM_JOB_OPS", line 217
ORA-06512: at "SYSMAN.GC_JOB", line 29
ORA-06512: at line 1

 

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.