ORA-00904 :: invalid identifier (awr report generation)

ERROR:

REASON:

respective user doesn't have execution permision on 'dbms_workload_repository' package.

SOLUTION:

Provide the execution permission on dbms_workload_repository to the respective user by using following steps.

$sqlplus / as sysdba 

SQL> grant execute on dbms_workload_repository to test;

SQL> conn test/test1

SQL> @?/rdbms/admin/awrrpt.sql


Hope it will help to resolve your issue.



By
Manjunath