Source Database Credentials

Before adding source database targets to the AWR Warehouse Repository, set Preferred Credentials (Normal Credentials should be sufficient) for each of the source databases and their hosts. This facilitates adding multiple source databases at once (select multiple databases in the Search and Select: Database dialog).

• Database credentials–the database user requires the following:

  • DBA role

  • Execute privileges on SYS.DBMS_SWRF_INTERNAL package

• Database host credentials–the user should be the same as the agent user.