Adding Source Database To AWR Warehouse Fails With "ORA-01536" Error

(Doc ID 2218697.1)

Last updated on JANUARY 05, 2017

Applies to:

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


Trying to add a new Source Database to AWR Warehouse Repository fails. The "Snapshot Upload Enabled" status for the affected Source Database in the AWR Warehouse page is "Database addition to AWR failed" (yellow X icon).

The "CAW_EXTRACT_SETUP" EM job fails with the following error:


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