try to genereate AWR/ADDM report from Toad.
I am using apps scehma fro generating AWR/ADDM report . Using Toad.
for aold instance its working fine but I am tried on new installation its not working .
Errro When ADDM --
ORA-13616: The current user APPS has not been granted the ADVISOR privilege.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_ADVISOR", line 919
ORA-06512: at "SYS.DBMS_ADVISOR", line 100
ORA-06512: at line 5
error When AWR --
The EXECUTE privilege on package.SYS.DBMS_WORKLOAD_REPOSITORY IS required to runAWR report. The privilege must be granted directly, not thorugh a role.
I find Some data.
------------------------------------------For old Instance ----
for aold instance its working fine but I am tried on new installation its not working .
Errro When ADDM --
ORA-13616: The current user APPS has not been granted the ADVISOR privilege.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_ADVISOR", line 919
ORA-06512: at "SYS.DBMS_ADVISOR", line 100
ORA-06512: at line 5
error When AWR --
The EXECUTE privilege on package.SYS.DBMS_WORKLOAD_REPOSITORY IS required to runAWR report. The privilege must be granted directly, not thorugh a role.
I find Some data.
------------------------------------------For old Instance ----
Tagged:
1