AWR Warehouse Frequent Data Load Failures
(Doc ID 2125350.1)
Last updated on NOVEMBER 16, 2022
Applies to:
Enterprise Manager Base Platform - Version 12.1.0.4.0 and laterEnterprise Manager for Oracle Database - Version 12.1.0.6.0 and later
Information in this document applies to any platform.
Symptoms
EM 12.1.0.5.0 w/both main & AWR-WH Repositories on 12.1.0.2.0 DBs, and Target/Source DBs a mix of 12.1.0.2.0 & 11.2.0.4.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.
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 |
References |