悠闲的鱼

ORACLE文档提供了相关资料：

使用9.2.0.5以下的export导出工具，导出9.2.0.5或以上版本的数据库的数据，的确会导致报错exp-00003.

具体的bug内容，ORACLE并没有公开。

解决方法：

确实就是您在文档中所查到的方法。

我发给您的文档中，“Workaround 2”就是描述了这样的方法。

Five Rabbits

Five rabbits were hiding,

In the woods one day,

1-2-3-4-5 jumped out,

and then they ran away.

In this Document
Symptoms
Changes
Cause
Solution
References

Applies to:

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 :

References

Keywords

10.2:

Enabling Tracing for Java-Based Tools and Utilities in Oracle Real Application Clusters

All Java-based tools and utilities that are available in Oracle RAC are invoked by executing scripts of the same name as the tool or utility. This includes the Cluster Verification Utility (CVU), Database Configuration Assistant (DBCA), the Net Configuration Assistant (NETCA), the Virtual Internet Protocol Configuration Assistant (VIPCA), Server Control (SRVCTL), and the Global Services Daemon (GSD). For example to run DBCA, enter the command dbca.

By default, Oracle enables traces for DBCA and the Database Upgrade Assistant (DBUA). For the CVU, GSDCTL, SRVCTL, and VIPCA, you can set the SRVM_TRACE environment variable to TRUE to make Oracle generate traces. Oracle writes traces to log files. For example, Oracle writes traces to log files in Oracle home/cfgtoollogs/dbca and Oracle home/cfgtoollogs/dbua for DBCA and the Database Upgrade Assistant (DBUA) respectively.

1. OPTIMIZER_INDEX_COST_ADJ:调整优化器在选择访问路径时更趋于使用索引还是使用全表扫描.缺省值100(即100%,百分比系数)表示按照常规方式计算索引访问路径.若为其他值,表示在计算得出的常规索引代价基础上乘以该百分比系数,使得其索引代价更少或更多.如:设置为50,表示索引访问代价是正常索引代价的50%,使得系统更偏向于使用索引.

在OLTP环境,可以设定此值小于100.

2. OPTIMIZER_INDEX_CACHING

in oracle database 10.2,by default, Oracle enables traces for DBCA and the Database Upgrade Assistant (DBUA). For the CVU, GSDCTL, SRVCTL, and VIPCA, you can set the SRVM_TRACE environment variable to TRUE to make Oracle generate traces.

数据文件丢失, 没有备份, 拥有文件创建以来的全部归档,使用RMAN恢复, 报错RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 726 scn 1757142927; 使用sqlplus恢复, 执行 'Alter Database recover datafile ' Fails with ORA-279

总结: RMAN备份没有使用catalog, controlfile默认保留7天的备份/归档信息,v$archived_log没有记录足够多的归档信息, 所以报RMAN-06102, 需要通过CATALOG命令注册.

SQLPLUS 执行 'Alter Database recover datafile ' Fails with ORA-279 因为9.2.0.6版本使用这个命令不能自动执行recover. 用户版本9.2.0.1也遇到同样的问题, 使用RECOVER DATAFILE即可.

 查看全文

Atempo公司的TimeNevigator是第三方的备份管理软件.声称:"带有Oracle模块的Time Navigator通过提供Oracle数据库高性能在线备份和恢复来提供增强了的应用软件实用性而不影响终端用户。该应用软件能提供一个Oracle数据库对象的逻辑视图,提供先进的诊断工具并实现小部分或完整的恢复。"

其工程师告知针对ORACLE数据库有两种备份方式,一种是RMAN调用,一种是数据文件读取方式,不通过RMAN. RMAN备份大家都理解,对于直接读取数据文件的方式其实就是置表空间为BEGIN BACKUP和END BACKUP状态,并无其他神奇之处.

客户端连接间歇性失败，报错ORA-12519

OERR: ORA-12519 TNS:no appropriate service handler found

 查看全文

locally managed tablespace 使用bitmap来管理tablespace extent. bitmap存储在每个文件的文件头中。每个extent占据bitmap中的一个bit.

管理extent的方式:autoextent(由oracle来自动管理)，和uniform(通过表级存储参数)

V$fixed_table中可以查到所有的X$TABLE的名字。

oracle 统计数据存放于：

user_tables, user_tab_columns, user_tab_cols(including virtual columns), user_tab_histograms.

计算selectivity / cardnality 非常重要。

提供user_tab_columns.low_value和user_tab_columns.high_value的转换函数。 字符串做范围查找时，需要根据编码转换成数字，提供此函数cbo_char_value。

ORACLE RAC 用于INTERCONNECT 的内网卡的物理连接方式的选择：采用交换机连接或是网线直连。

itpub讨论中谈到直连的弊端，一旦一个节点机的内网卡出现故障，oracle从OS得到两个节点的网卡状态都是不正常的，因而会导致两个实例都宕掉。

下面是讨论过程：

• 首页
• 文章归档
• 资源中心
• 网站链接

• EXP-00003 When Exporting From 9.2.0.5.0 or any Higher Release with a Pre-9.2.0.5.0 Export Client
• nursery rhyme: Five Rabbits
• English song:Eensy Weensy spider
• Subject: "GRANT SELECT ANY DICTIONARY" Privilege Required When Connecting from 9i OEM console to 10G DB
• 开启基于java的oracle工具的tracing
• 影响CBO计算代价的系统参数
• Migrating Data to a Different Operating System in 10g2
• Enabling Tracing for Java-Based Tools and Utilities in Oracle Real Application Clusters
• 数据文件丢失, 没有备份, 拥有文件创建以来的全部归档, 'Alter Database recover datafile ' Fails with ORA-279
• Atempo公司的TimeNevigator带库介质管理软件-RMAN WITH CATALOG备份策略

• 生活 [2]
• 配置 [5]
• 备份 [3]
• 性能 [3]
• 一般分类 [4]

• RSS 0.90
• RSS 1.0
• RSS 2.0