ORA-00600 [kfgFinalize_2]的解决办法

ORA-00600 [Kfgfinalize_2] While Mounting Diskgroups In Rac [ID 418063.1]
 

---

 Modified 14-MAY-2008Type PROBLEMStatus PUBLISHED 

In this Document
Symptoms
Cause
Solution
References

---

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.2.0
This problem can occur on any platform.
Oracle Enterprise Server 10.2.0.2.0 (RAC)

Symptoms

1. If you experience a crash in a RAC environment using ASM and the instances fail to start with the following error:

ORA-00600: internal error code, arguments: [kfgFinalize_2], [], [], [], [], []

2. The trace file may show the following SQL and call stack:

Current SQL statement for this session:
ALTER DISKGROUP ALL MOUNT

Call Stack Trace : kfgFinalize kfxdrvMount kfxdrvEntry

Cause

The error is caused by Unpublished Bug 4450268.
Details: Mounting diskgroups on multiple instances in 10.1 and 10.2 are serialized. Thus it may take a long time or hang if coupled with instance failures.

Solution

To resolve the problem, you can choose one of the following solutions:

1. Apply the 10.2.0.3.0 patch to resolve this issue. The bug is corrected in this patchset.

2. Apply the 10.2.0.2 one-off Patch 4450268 from MetaLink if available for your platform. and version.

3. Workaround:

Try starting the database on one node only. That will mount the ASM diskgroups and then kill the PMON process on that node. Then restart that database to force a recovery.

The database instances should be able to open after doing the recovery.

References

BUG:5393792 - ASM: ORA-00600 [KFGFINALIZE_2] WHILE MOUNTING DISKGROUPS IN RAC

---

Related

---

Products

---

• Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition

Errors

---

ORA-600[KFGFINALIZE_2]

Back to top

Copyright (c) 2007, 2010, Oracle. All rights reserved. Legal Notices and Terms of Use | Privacy Statement

===================================================================================================================

不幸中的万幸:遭遇ORA-00600 [kfgFinalize_2]

今天客户的一个RAC集群系统出现问题,一个节点被重启后,ASM磁盘组无法mount,报出如下错误:

 ORA-00600: internal error code, arguments: [kfgFinalize_2], [], [], [], [], [], [], []

检查trac文件如下:
Errors in file /u01/app/oracle/admin/+ASM/udump/+asm2_ora_11560.trc:
ORA-00600: internal error code, arguments: [kfgFinalize_2], [], [], [], [], [], [], []

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kfgFinalize_2], [], [], [], [], [], [], []
Current SQL statement for this session:
ALTER DISKGROUP ALL MOUNT

后面就是一堆二进制码，看来是磁盘组mount的时候出现问题。

查找各方面资料,发现是oracle的一个bug。

解决的办法有三个：

1、升级到10.2.0.3
2、打一个patch上去
3、把活着的那个节点的PMON进行kill掉，然后重新启动活着的节点的实例，使得强制对数据库进行恢复

评估一下，

方案1动作太大，而且这个版本没有测试使用过。

方案2的readme文件里明确写着这个patch可能会造成数据丢失，要在oracle support的支持下做，我没有support，

看来方案三比较可行，可问题是现在至少有一个节点活着，如果强行kill pmon进程后，节点2也起不来了，那就全玩完了，只有准备好切dataguard的方案先了。

此时在oracle的论坛上看见说不用kill pmon的，只要把两个节点都宕下来，然后启动就ok。

于是重启两个节点（的主机）,看见见SUCCESS: diskgroup DATA was mounted提示出来了，放心了。

数据库全部起来后，业务回复正常!

========================================================================================================================
本人遇到的问题：
startup ASM实例时，提示ORA-00600: internal error code, arguments: [kfgFinalize_2], [], [], [], [], [], [], []，接着关闭实例时遇到
ORA-15100: invalid or missing diskgroup name。关于ora-15100的解决，参见《Oracle ORA-01078 ORA-01565 ORA-17503 ORA-15077问题的解决（及ORA-15100和ora-1031）》

==============================================================================================================

遇到错误提示的一般解决步骤：

1、检查alert.log文件，发现提示如下：

跟踪文件是跟踪用户及系统自身的整个操作过程的，故而可以包含产生问题的信息。
2、查看产生的跟踪文件，由此可以获得更多更准确的关于产生问题的原因的信息。