Enterprise Manager Generic (MOSC)

MOSC Banner

OEM 12C and utilizing such tools as the SQL Tuning Advisor

edited Oct 27, 2013 4:52AM in Enterprise Manager Generic (MOSC) 3 commentsAnswered
Hello.  I created an OEM 12C user and assigned this user a role to permit it to access specific database instances.  Then, with this OEM12C I access OEM 12C and  Performance-> Top Activity and execute the SQL Tuning Advisor which returns with an "ORA-942 Table or View does not exist".  The DB user I use to access the Performance-> Top Activity option has the following DB privileges:

SQL> select * from user_Role_privs;

USERNAME                       GRANTED_ROLE                   ADM DEF OS_
------------------------------ ------------------------------ --- --- ---
ADVANCE_OEM                    CONNECT                        NO  YES NO
ADVANCE_OEM                    OEM_ADVISOR                    NO  YES NO
ADVANCE_OEM                    SELECT_CATALOG_ROLE            NO  YES NO

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center