oracle 11g升级步骤,不遵守Oracle 11gR2升级步骤的后果

摘自:

ORA-00600 [rwoirw: check ret val] After 11.2.0.4 Upgrade (Doc ID 1910573.1)

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later

Information in this document applies to any platform.

SYMPTOMS

The following error is received after an upgrade to 11.2.0.4:

ORA-00600: internal error code,arguments: [rwoirw: check ret val],[],[]

You find some or all of the following function codes in the 'Call Stack' portion of the incident trace file:

qertqostart qerpxslavefetch qerpxfetch opiexe kpoal8 opiodr

CHANGES

Upgrade to 11.2.0.4.

CAUSE

This can occur if the optimizer statistics are stale.

SOLUTION

Cross-check for any information about this while executing Pre-Upgrade Information Tool (utlu111i.sql)

Next,try to collect the data dictionary and fixed objects stats using following procedures:

sql> exec dbms_stats.gather_dictionary_stats;

sql> exec dbms_stats.gather_fixed_objects_stats;

Follow the steps mentioned inNote: 837570.1Complete Checklist for Manual Upgrades to 11gR2,and be sure to run the data dictionary and fixed objects statistics.

When upgrading to Oracle Database 11g Release 2 (11.2),optimizer statistics are collected for dictionary tables that lack statistics. This procedure gathers statistics

for dictionary schemas 'SYS','SYSTEM' and schemas of RDBMS components.

REFERENCES

总结

如果觉得编程之家网站内容还不错，欢迎将编程之家网站推荐给程序员好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。