AWR Warehouse is tightly integrated with Enterprise Manager, both the database which acts as the repository plus any databases that will contribute to it need to be discovered as targets within OEM before they can be used. If you are already using OEM to manage your databases (and you should be), this means that configuration …
Migrating AWR Warehouse Repository to a new OEM Target Read More »
Unfortunately AWR Warehouse and Data Guard do not work together seamlessly, however by understanding some of the implementation details, and following some simple steps you can help to mitigate most problems that may be encountered. It is not possible to add an instance to AWRW when it is in standby mode, worse still if you …
Continuing the investigation, I wanted to check the effect of deleting one of the two data guard instances from AWRW; remember I have updated the mapping table such that both DGA and DGA both map to the same DBID. We can check from load metadata and AWR itself which snapshots have been loaded SQL> SELECT …
After a brief interlude I wanted to follow up on something I noticed on John Hallas’s blog. He mentioned that specifying a shared location for the extract metadata did not work, and was waiting on a fix for bug number 21826657. I checked that this bug should be fixed in db plugins version 13.2.2 and …
Note, in preparing next entry, I reviewed the results from previous entries and found that although extracts were being transferred successfully they had all failed to load; I should have noticed they had status 4 (IMPORT_FAILED), in the load metadata table. Reviewing dbms_scheduler_job_run_details of the load task revealed the following error: “move error: ORA-20105: Unable …
This entry continues with the setup configured in parts one and two. I stated that ideally you should perform “Upload Snapshots Now” on the primary database before performing switch-over to prevent remove the possibility of missing snapshots in AWRW. We will see what happens if you don’t, either because you forgot, or it was not …
I realize that the majority of blog posts I have made are for problems I have encountered. I think is only natural as most of my time is spent investigating the few occasions where things don’t work as expected rather than the 99.99% of the time when things just work. Even when there are problems …
We will continue with setup configured for the previous blog entry. This post includes details about updating some internal AWRW tables. These steps are provided for education purposes only; if you do this on a real system make sure you know exactly what you are doing and understand the risks. If you break anything, Oracle …
Note, if you are not interested in the nitty gritty of my testing and results, you may just want to skip ahead to the blog entry i have made that summarizes my findings, and makes some recommendations. One limitation of AWR Warehouse (AWRW) is that it doesn’t play nicely with Data Guard. I have been …
Checking the AWR warehouse health after we upgraded the repository database from 12cR1 to 12cR2 I noticed that for some source databases the transfer task had been failing. Performing “Upload Snapshots Now” I was also able to reproduce the problem and identify the error message “ORA-28040: No matching authentication protocol”. This was initially puzzling as …
Transfer Tasks failing with ORA-28040 after Upgrading AWR Warehouse to 12cR2 Read More »