ORA -00904 while generating AWR report can

Ramakrishna Tata · Sep 21, 2010 7:10PM

Kanda-Oracle · Sep 21, 2010 8:01PM

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 · Sep 21, 2010 8:35PM

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 · Sep 21, 2010 9:18PM

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

Database ORA-600 / ORA-7445 Analysis , Diagnostic Repository (ADR) & Packaging (MOSC)

ORA -00904 while generating AWR report can

Comments

Category Leaderboard

Top contributors this month