某客户一体机平台ORA-00600 : [rwoirw: check ret val]问题分析-解决方法

时间:2024-07-18 07:10:26

        通过调整参数或者安装补丁可以解决该问题。

        1.相关参数设置

        alter session set "_pred_move_around"=FALSE;

        2.补丁修复

        补丁修复该bug参考了客户exadata环境。

        Exadata环境Patch分析说明:

Patch  21761335     : applied on Wed Dec 16 22:19:07 CST 2015

Unique Patch ID:  19326074

Patch description:  "DATABASE PATCH FOR EXADATA (OCT2015 - 11.2.0.4.20) : (21761335)"

  Created on 21 Sep 2015, 01:49:45 hrs PST8PDT

Sub-patch  21637587; "DATABASE PATCH FOR EXADATA (Sep2015 - 11.2.0.4.19) : (21637587)"

Sub-patch  21439740; "DATABASE PATCH FOR EXADATA (AUG2015 - 11.2.0.4.18) : (21439740)"

Sub-patch  21025821; "DATABASE PATCH FOR EXADATA (JUL2015 - 11.2.0.4.17) : (21025821)"

Sub-patch  20449729; "DATABASE PATCH FOR EXADATA (APR2015 - 11.2.0.4.16) : (20449729)"

Sub-patch  20059375; "DATABASE PATCH FOR EXADATA (JAN2015 - 11.2.0.4.15) : (20059375)"

Sub-patch  19893780; "DATABASE PATCH FOR EXADATA (Dec2014 - 11.2.0.4.14) : (19893780)"

Sub-patch  19698715; "DATABASE PATCH FOR EXADATA (Nov2014 - 11.2.0.4.13) : (19698715)"

Sub-patch  19495869; "DATABASE PATCH FOR EXADATA (OCT2014 - 11.2.0.4.12) : (19495869)"

Sub-patch  19307276; "DATABASE PATCH FOR EXADATA (SEP2014 - 11.2.0.4.11) : (19307276)"

Sub-patch  19061859; "DATABASE PATCH FOR EXADATA (AUG2014 - 11.2.0.4.10) : (19061859)"

Sub-patch  18825509; "DATABASE PATCH FOR EXADATA (JUL2014 - 11.2.0.4.9) : (18825509)"

Sub-patch  18642122; "DATABASE PATCH FOR EXADATA (JUN2014 - 11.2.0.4.8) : (18642122)"

Sub-patch  18552960; "DATABASE PATCH FOR EXADATA (MAY2014 - 11.2.0.4.7) : (18552960)"

Sub-patch  18293775; "DATABASE PATCH FOR EXADATA (APR2014 - 11.2.0.4.6) : (18293775)"

Sub-patch  18136151; "DATABASE PATCH FOR EXADATA (MAR2014 - 11.2.0.4.5) : (18136151)"

Sub-patch  18006299; "DATABASE PATCH FOR EXADATA (FEB2014 - 11.2.0.4.4) : (18006299)"

Sub-patch  17943261; "DATABASE PATCH FOR EXADATA (JAN2014 - 11.2.0.4.3) : (17943261)"

Sub-patch  17741631; "DATABASE PATCH FOR EXADATA (DEC 2013 - 11.2.0.4.2) : (17741631)"

Sub-patch  17628006; "DATABASE PATCH FOR EXADATA (NOV 2013 - 11.2.0.4.1) : (17628006)"

  Bugs fixed:

    17288409, 16188701, 21051852, 16930924, 17205719, 17811429, 13640676

    18607546, 20506699, 14705949, 17816865, 17922254, 17754782, 13364795

    16934803, 17311728, 18418934, 16809786, 17284817, 17441661, 14275161

………