I log into the OMS which run Oracle 9i, this OMS running OEM can connec to all of our instances. Last week, I upgrade one of our instance on different server from 8.1.7 to 9.2.0.4. Today, when I log into the OMS server and try to connect to this new upgrade instance and I got the message (I log in as SYSTEM):
this application requires you have been granted the SELECT ANY DICTIONARY privilege. Contact your DBA to grant you this privilege.
Why do I need that privilege and how come there is no problem with 8i
thanks,