Oracle Database Discussions

Hello,

I am trying to run SQL tuning advisor in the OEM grid, and encountered the following error in the OEM grid:

...You have insufficient privileges to run advisors. You must have OEM_ADVISOR role in order to do so....

I have grant OEM_ADVISOR role to the users system and DBSNMP in both the OEM db (oem_rep) and the client db, but still encountered the issue.

SQL>  select GRANTEE, GRANTED_ROLE from dba_role_privs where GRANTEE in ('DBSNMP','SYSTEM')
  2  and GRANTED_ROLE like 'OEM%';

GRANTEE                        GRANTED_ROLE
------------------------------ ------------------------------
SYSTEM                         OEM_ADVISOR
DBSNMP                         OEM_ADVISOR
DBSNMP                         OEM_MONITOR

What did I miss? Can someone advice?

Thanks!