Home » RDBMS Server » Enterprise Manager » Accessing 10g from 9i OEM
Accessing 10g from 9i OEM [message #394415] Thu, 26 March 2009 22:19 Go to next message
Messages: 58
Registered: March 2006

I am using 9i OEM and connecting to different 9i databases. Recently I have upgraded one of the database to 10gR2.

When I try to access the 10g database from 9i OEM, I am getting the error

"This application requires the that you have been granted the SELECT ANY DICTIONARY privilege. Contact your DBA to grant you this privilege".

I have tried to login with the user SYSTEM, which has the DBA role and also SELECT ANY DICTIONARY privilege. Still getting the same error. If I login with sys/<pwd> as sysdba from 9i OEM, then I am able to login successfully.

Can we access the 10g db from 9i OEM?
Are there any restrictions and any drawbacks for the same?

Kindly let me know the pros and cons of the same.

All the replies are welcome

Thanks in Advance

Re: Accessing 10g from 9i OEM [message #394416 is a reply to message #394415] Thu, 26 March 2009 22:22 Go to previous message
Messages: 2794
Registered: April 2006
Senior Member
9i OEM is not compatible with 10g. If you like, you can install the 10g OEM java console from the 10g client CD and/or use the native 10g web based OEM.
Previous Topic: OEM 10g
Next Topic: Error java.lang.Exception
Goto Forum:

Current Time: Sun Aug 20 21:56:26 CDT 2017

Total time taken to generate the page: 0.04203 seconds