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

本文档描述了使用9i Oracle Enterprise Manager (OEM) 控制台连接10g数据库时遇到的问题及解决方案。主要症状包括无法通过'SYSTEM'用户或'SYS'用户连接,并收到权限不足错误。解决办法是推荐使用Grid Control、Database Control或10g Java控制台进行监控。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

Doc ID: 340951.1Type: PROBLEM
Modified Date : 06-MAY-2007Status: 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/

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值