ORA -00904 while generating AWR report can

Ramakrishna Tata

Kanda-Oracle

Hi,

Please let me know which user are you using to run awrrpt.sql

If required, you may need to grant

grant SELECT_CATALOG_ROLE to <user name>;

grant execute on dbms_workload_repository to <user name>;

Hope this helps!

Thanks

N Kandasamy

Ramakrishna Tata

Hi,

Please let me know which user are you using to run awrrpt.sql

If required, you may need to grant

grant SELECT_CATALOG_ROLE to <user name>;

grant execute on dbms_workload_repository to <user name>;

Hope this helps!

Thanks

N Kandasamy

 Thanks for reply, to check that i dont have permitions..to granting all ..

Kanda-Oracle

 Thanks for reply, to check that i dont have permitions..to granting all ..

Hi,

 Thanks. Please let me know if the issue persists after granting.

 In future, You may choose to post your queries as "Discussions" instead of "Documents". 

Thanks

N Kandasamy