当前位置: 首页 > Oracle, oracle 10g > 正文

ORA-00600 [kghfrf1]错误

在给客户写优化方案时,客户的环境是AIX 5.3,ORACLE 10.2.0.4.0,发现客户的告警日志存在ORA-00600错误,如下:

Fri Oct  5 06:20:27 2012
Errors in file /home/oracle/app/admin/wssb/udump/wssb_ora_4272180.trc:
ORA-00600: internal error code, arguments: [kghfrf1], [0x000000000], [], [], [], [], [], []

查看trace文件发现是物化视图刷新的时候触发了这个错误,如下:

*** 2012-10-05 06:20:27.599
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kghfrf1], [0x000000000], [], [], [], [], [], []
Current SQL statement for this session:
BEGIN isso.rph(:1) ; END;
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
70000018ea40960        81  package body SYS.DBMS_SNAPSHOT
70000018ea40960      1727  package body SYS.DBMS_SNAPSHOT
70000018ea40960      2220  package body SYS.DBMS_SNAPSHOT
70000018ea40960      2457  package body SYS.DBMS_SNAPSHOT
70000018d8668a0       685  package body SYS.DBMS_IREFRESH
70000018ea4ff60       195  package body SYS.DBMS_REFRESH
7000001751170d8         3  procedure ISSO.RPH
70000018eb80490         1  anonymous block

经过分析并与MOS(ID 816733.1)对比,发现这是刷新物化视图时触发的BUG(Bug 5879082),该BUG在10.2.0.5和11.2版本已经修复,也可安装Patch:5879082进行修复。
0998
 

 

 

 

 

 

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 Server - Enterprise Edition - Version: 9.2.0.7 to 11.1.0.6 - Release: 9.2 to 11.1
Information in this document applies to any platform.
Symptoms
On a MV refresh, it can be reported:
ORA-00600: internal error code, arguments: [kghfrf1], [0x000000000], [], [], [], [], [], []
The call stack looks like:
kghfrf kkzufsnap kkzfcobwu kkzfrsh kkzifr3g spefcmpa spefmccallstd pextproc peftrusted psdexsp
rpiswu2 psdextp pefccal pefcal pevm_FCAL pfrinstr_FCAL pfrrun_no_tool pfrrun plsql_run peicnt
kkxexe
Cause
The cause of this problem has been identified and verified in an unpublished Bug 5879082:
the error ORA-600 [kghfrf1] is reported on MV refresh while doing cleanup of oracle memory.
Solution
Unpublished Bug:5879082 is fixed in Oracle RDBMS 11.1 and 10.2.0.5 release.
There is currently no known workaround available.

Check for the availability of one-off Patch:5879082 for your platform on My Oracle Support.
References
NOTE:5879082.8 - Bug 5879082 - Dump[kghfrf] during refresh of MView
NOTE:139056.1 - ORA-600 [kghfrf1]

本文固定链接: http://www.dbdream.com.cn/2012/10/ora-00600-kghfrf1%e9%94%99%e8%af%af/ | 信春哥,系统稳,闭眼上线不回滚!

该日志由 dbdream 于2012年10月25日发表在 Oracle, oracle 10g 分类下, 你可以发表评论,并在保留原文地址及作者的情况下引用到你的网站或博客。
原创文章转载请注明: ORA-00600 [kghfrf1]错误 | 信春哥,系统稳,闭眼上线不回滚!
关键字: , , , ,

ORA-00600 [kghfrf1]错误:等您坐沙发呢!

发表评论

快捷键:Ctrl+Enter