AWR Warehouse

AWR Warehouse and Data Guard (Interlude)

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 …

AWR Warehouse and Data Guard (Interlude) Read More »

Transfer Tasks failing with ORA-28040 after Upgrading AWR Warehouse to 12cR2

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 »