AWR Warehouse Frequent Data Load Failures
Last updated on MAY 06, 2016
Applies to:Enterprise Manager Base Platform - Version 220.127.116.11.0 and later
Enterprise Manager for Oracle Database - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
EM 22.214.171.124.0 w/both main & AWR-WH Repositories on 126.96.36.199.0 DBs, and Target/Source DBs a mix of 188.8.131.52.0 & 184.108.40.206.0.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms