Oracle Enterprise Manager SELECT ANY DICTIONARY Privilege Login Error
 OEM Login Error - This application requires you have been granted the SELECT ANY DICTIONARY privilege |
Oracle Enterprise Manager (OEM) version 9.2.0.1.0 is the usual application that I use in the office to manage an Oracle Database. Recently, we’ve upgraded the database to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0. After installation, trying to connect to the upgraded database using OEM with SYSTEM user does not work. It throws an error message – “This application requires you have been granted the SELECT ANY DICTIONARY privilege.”
The pop up error message shows explicitly the solution. I have followed the error message advice of granting SELECT ANY DICTIONARY privilege to SYSTEM.
SQL>connect sys/******@oracleserv as sysdba;
grant select any dictionary to system;
The grant succeeded message showed, but unfortunately, the error still persisted. This seem not to answer the problem that I am facing. The solution is to use a OEM version that is the same version or higher version than the database version. That explains the difficulty.
If OEM version 9.2.0.1.0 should be used to connect to a Oracle 10g Database, try using sys username and connect as sysdba. I have successfully connected to a 10g database with a version 9.2.0.1.0 OEM using this approach. I could do all the things necessary with sys as sysdba user on the Oracle Database for managing database.
Posted on
Tuesday, January 27th, 2009 at 8:35 pm under 
This worked for me logging in as sys and sysdba, I had to log out OEM and then back on. Some of the displays such as a user display acted wierd, such as it would not display a users rols etc until I again logged out OEM and then back in.
February 26th, 2010 at 4:41 amI installed Oracle client OEM on my desk top Window
March 11th, 2010 at 3:54 amxp 32bit When I am trying to open the database it
does connect to the database but it does not pop up every thing else can you tell me what am I doing wrong?
I installed OEM 9.2.0.1.0 I have a DBA that does not
March 11th, 2010 at 3:55 amlet us to start Oracle DB control so I have to you
Oracle 9i OEM to manage 10g database I am new here
just want to follow the rules