privilege issue on OMS

Printable View

10-22-2003, 11:21 AM
learning_bee

privilege issue on OMS

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,
10-22-2003, 11:53 AM
marist89

ahhh, different version?
10-22-2003, 12:02 PM
learning_bee

Jeff,

the remote database is running on 9.2.0.4 and the OMS is running on 9.2.0.3, does it make any difference???
10-22-2003, 12:52 PM
marist89

No, no, no. You upgraded from 8.x to 9.x on the instance you are trying to connected to. Find out what's different and you've found your solution.
10-22-2003, 01:34 PM
learning_bee

Jeff,

how can I find out the different??? BTW, I use DUA to upgrade my database, could you please throw some light on this issue???

thanks
10-22-2003, 02:42 PM
marist89

Look into the privs on both databases (dba_role_privs, dba_tab_privs) for the userid you are trying to connect as.
10-22-2003, 03:13 PM
learning_bee

I connect in as SYSTEM and I got the error.
10-22-2003, 03:21 PM
marist89

Quote:

Originally posted by marist89
Look into the privs on both databases (dba_role_privs, dba_tab_privs) for the userid you are trying to connect as.
10-22-2003, 03:23 PM
marist89

closing, duplicate of 39487