My Oracle Support Banner

AWR Warehouse Frequent Data Load Failures (Doc ID 2125350.1)

Last updated on NOVEMBER 16, 2022

Applies to:

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


EM w/both main & AWR-WH Repositories on DBs, and Target/Source DBs a mix of &

AWR Warehouse was configured with Property 'dest_dir' set to the NFS (NetApp) mount '/data/software/awrwh' (since 5 of the 9 DBs we're collecting from are RAC).  

The EM Console Database for AWR Warehouse Page shows the automatic/scheduled uploads from the RAC DBs are frequently failing; however if the upload is rerun manually, it works just fine.

The solution from unpublished Bug 20131398  ("AWR reports not getting uploaded from source databases") has been tried on all 5 RAC Databases.  

Two showed up on the (EM Console AWR ) Errors page, with the exact same errors as before; but the other 3 also failed to upload, even though they did not show up on the Errors page.


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

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