2 Replies Latest reply: Sep 13, 2013 10:16 AM by Courtney Llamas-Oracle RSS

    OEM Warning message

    user8647245

      hi all,

       

      While accessing performance page of a database on grid control i am getting warning message : https://ora2-9:7799/em/cabo/images/t.gifYou must have OEM_MONITOR role to access the performance page.

      I verified that OEM_MONITOR is existing. and also i recreated this role by following
      http://docs.oracle.com/html/A88769_01/ch4.htm#1004690

      but still i can see that warning message and i can't the graph.

      gird version is 11g

      please let me know if you have.


      thanks

        • 1. Re: OEM Warning message
          sb92075

          user8647245 wrote:

           

          hi all,

           

          While accessing performance page of a database on grid control i am getting warning message : You must have OEM_MONITOR role to access the performance page.

          I verified that OEM_MONITOR is existing. and also i recreated this role by following
          http://docs.oracle.com/html/A88769_01/ch4.htm#1004690

          but still i can see that warning message and i can't the graph.

          gird version is 11g

          please let me know if you have.


          thanks

           

          as which Oracle user is logged onto the database.

           

          SQL> show user

          USER is "SYS"

          SQL> alter user sysman identified by newpass1 account unlock;

           

           

          User altered.

           

           

          SQL> grant OEM_MONITOR TO SYSMAN;

           

           

          Grant succeeded.

           

           

          SQL> CONNECT SYSMAN/newpass1

          Connected.

          SQL> select * from user_role_privs;

           

           

          USERNAME                       GRANTED_ROLE                   ADM DEF OS_

          ------------------------------ ------------------------------ --- --- ---

          SYSMAN                         MGMT_USER                      YES YES NO

          SYSMAN                         OEM_MONITOR                    NO  YES NO

          SYSMAN                         RESOURCE                       NO  YES NO

          SYSMAN                         SELECT_CATALOG_ROLE            YES YES NO

           

           

          SQL>

          • 2. Re: OEM Warning message
            Courtney Llamas-Oracle

            The user in question here is the database user (target), not the Grid Control/Cloud Control user.  There are 2 accounts needed.   In Grid/Cloud Control, you need access to the target.  In the database target, your user must have specific permissions to see/use performance functionality. MOS note 420504.1 might help identify which permissions your database user must have in order to use performance pages/tools effectively in Grid/Cloud Control.