Subject: "GRANT SELECT ANY DICTIONARY" Privilege Required When Connecting from 9i OEM console to 10

Doc ID:	340951.1	Type:	PROBLEM
	Modified Date :	06-MAY-2007	Status:	MODERATED

In this Document
Symptoms
Changes
Cause
Solution
References

---

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:

Oracle Enterprise Manager - Version: 10.1.0.2
This problem can occur on any platform.

Symptoms

Trying to connect a 10G database via 9i OEM standalone console.
- Try connect with 'SYSTEM' user as 'normal': returns the error that this user requires 'SELECT ANY DICTIONARY' privilege.
- Try connect with 'SYS' user as 'SYSDBA' : got ORA-01031 insufficient privilege.

Both sys and system have been granted 'SELECT ANY DICTIONARY' privilege.
Connection is possible via the sqlplus tool but not via the 9i OEM console.

Connection works fine when connecting to a 9i database.

Changes

Newly created 10G database or 9i database upgraded to 10G.

Cause

This combination is not certified. It is not possible to monitor a 10G database via 9i OEM console.

For more information, check :
Bug 4154109 : Abstract: GRANT SELECT ANY DICTIONARY WHEN CONNECT FROM 9I EM TO 10G DB

Solution

9i OEM console should NOT be used to monitor a 10G database, as this is not a certified combination.

For monitoring a 10G database you will have to make use of the Grid control, database control or the 10G java console.

- The Grid control is similar to the OMS setup in 9i where there is a grid agent on the target
machine being monitored. Using this, you can monitor 8.1.7.4 and above, 9.2.0.1 and above, 10g
databases.

- Database control is for a single 10G database (sinlge instance or RAC). You can only monitor a
single 10g database from each database control. For a second 10G database, you will have to
configure another database control.

- 10G Java console is similar to the standalone console of the 9i version. This can be installed
from the 10G Client software.
You can monitor 8i, 9i and 10G databases using this console.

For more information, refer to the documentation :

Oracle® Enterprise Manager Grid Control Installation and Basic Configuration 10 g Release 1 (10.1), Appendix D - Enterprise Manager Java Console

References

Bug 4154109 - GRANT SELECT ANY DICTIONARY WHEN CONNECT FROM 9I EM TO 10G DB

Keywords

GRID~CONTROL; DATABASE~CONTROL; ENTERPRISE~MANAGER; OMS; JAVACONSOLE;[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/87149/viewspace-1019653/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/87149/viewspace-1019653/