User not able to login through OEM
Posted by Pavan DBA on May 7, 2013
Have you any time tried to login as normal user like scott or HR into OEM and landed up with below message?
The application requires more database privileges than you have currently been granted. Click on Help to get more version specific information.
Unfortunately, when you click on HELP, it may not give proper details on which privilege is missing.
When checked at DB level, may be that user will have all the required privileges to connect to the database, but still login to OEM is impacted.
The solution for this is to grant SELECT_CATALOG_ROLE to that user.
sqlplus / as sysdba
SQL> grant select_catalog_role to schemaname;
for example, if you are facing issue with scott schema, then issue below command
SQL> grant select_catalog_role to scott;
After above grant, user should able to login to OEM.
But, even after granting the above role, still if you face issue, then you may need to grant select on dictionary views to that user. But do remember, with this user can able to retrieve dictionary information from oracle database. So, grant it only if it is very much required.
SQL> grant select any dictionary to scott;
Hope this helps…
raj said
Hello sir ,
I tried above solution regarding OEM but still can’t connect to database through EM , what to check now.
Pavan DBA said
what is the error?
Ram said
Hi Pavan,
Could you please let me know whether we use the Oracle Automatic SQL tuning in real time situations to tune a badly performing query. The Automatic SQL tuning has been evolved to considerable extent with Oracle 11g. Please also share any situation where you have used this feature in your work place. I’m interested to know the applicability of this feature because some of the DBAs will be the ones who have no prior experience as developer , I being one of them, who find it difficult when it comes to SQL tuning. Well, in a perfect world developer to senior developer to DBA is the ideal track. Any response would be appreciated. Thanks in advance.
Pavan DBA said
hi, this feature is used only with tuning pack which requires extra license. till now whomever the clients I worked with didn’t have this option enabled, so I have not got chance to work on it. I worked only on sql tuning advisor
Murthy>G said
Hi Pavan ,Please help me how to configure OEM grid control or OEM12c with database
Pavan DBA said
http://www.gokhanatil.com/2011/07/how-to-install-oracle-grid-control-11g-step-by-step-guide.html
muralidharan said
Hai pavan,
Can u please explain oracle database architecture cycle with diagram
Pavan DBA said
Hi Murali, you can read that here…
http://docs.oracle.com/cd/E11882_01/server.112/e25789/toc.htm
http://docs.oracle.com/cd/E11882_01/server.112/e25494/toc.htm