When generating reports in the ADDM/AWR reports tab from Database | Monitor | ADDM/AWR Reports (OEM), the following error may occur:
Error occurred: [13616] (ORA-13616: The current user <username> has not been granted the ADVISOR privilege.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_ADVISOR", line 986
ORA-06512: at "SYS.DBMS_ADVISOR", line 100
ORA-06512: at line 5
)
GRANT EXECUTE ON SYS.DBMS_ADVISOR TO USERNAME;
GRANT ADVISOR TO USERNAME ;
