【Oracle】ORA-00600: [kfgFinalize_2]

环境：

OS：OEL5.6

RAC：10.2.0.1.0

[root@rac2 ~]# crs_stat -t

Name           Type           Target    State     Host        

------------------------------------------------------------

ora....B1.inst application    ONLINE    ONLINE    rac1        

ora....B2.inst application    ONLINE    OFFLINE               

ora.RACDB.db   application    ONLINE    ONLINE    rac2        

ora....SM1.asm application    ONLINE    ONLINE    rac1        

ora....C1.lsnr application    ONLINE    ONLINE    rac1        

ora.rac1.gsd   application    ONLINE    ONLINE    rac1        

ora.rac1.ons   application    ONLINE    ONLINE    rac1        

ora.rac1.vip   application    ONLINE    ONLINE    rac1        

ora....SM2.asm application    ONLINE    ONLINE    rac2        

ora....C2.lsnr application    ONLINE    ONLINE    rac2        

ora.rac2.gsd   application    ONLINE    ONLINE    rac2        

ora.rac2.ons   application    ONLINE    ONLINE    rac2        

ora.rac2.vip   application    ONLINE    ONLINE    rac2 

rac的第二个节点实例无法启动

尝试手动启动

[oracle@rac2 ~]$ export ORACLE_SID=RACDB2

[oracle@rac2 ~]$ sqlplus / as sysdba

 

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 21 14:34:44 2014

 

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

 

Connected to an idle instance.

 

SQL> startup

ORA-01078: failure in processing system parameters

ORA-01565: error in identifying file '+DATA/RACDB/spfileRACDB.ora'

ORA-17503: ksfdopn:2 Failed to open file +DATA/RACDB/spfileRACDB.ora

ORA-15056: additional error message

ORA-17503: ksfdopn:DGOpenFile05 Failed to open file +DATA/racdb/spfileracdb.ora

ORA-17503: ksfdopn:2 Failed to open file +DATA/racdb/spfileracdb.ora

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-06512: at line 4

显示diskgroup没有mount

那么去ASM下查看diskgroup的状态，并尝试mount

[oracle@rac2 ~]$ export ORACLE_SID=+ASM2

[oracle@rac2 ~]$ sqlplus / as sysdba

 

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 21 14:41:59 2014

 

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, Real Application Clusters, OLAP and Data Mining options

 

 

SQL> desc v$asm_diskgroup;

 Name                                      Null?    Type

 ----------------------------------------- -------- ----------------------------

 GROUP_NUMBER                                       NUMBER

 NAME                                               VARCHAR2(30)

 SECTOR_SIZE                                        NUMBER

 BLOCK_SIZE                                         NUMBER

 ALLOCATION_UNIT_SIZE                               NUMBER

 STATE                                              VARCHAR2(11)

 TYPE                                               VARCHAR2(6)

 TOTAL_MB                                           NUMBER

 FREE_MB                                            NUMBER

 REQUIRED_MIRROR_FREE_MB                            NUMBER

 USABLE_FILE_MB                                     NUMBER

 OFFLINE_DISKS                                      NUMBER

 UNBALANCED                                         VARCHAR2(1)

 COMPATIBILITY                                      VARCHAR2(60)

 DATABASE_COMPATIBILITY                             VARCHAR2(60)

 

SQL> select NAME,STATE from v$asm_diskgroup;

 

NAME                           STATE

------------------------------ -----------

FRA                            DISMOUNTED

DATA                           DISMOUNTED

 

SQL> alter diskgroup DATA mount;

alter diskgroup DATA mount

*

ERROR at line 1:

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

[], []

报了ORA-600: [kfgFinalize_2]

上网查证之后：

ASM异常崩溃后，可能会导致ASM实例第一次重启出现异常，报ORA-600: [kfgFinalize_2]

最终的解决方法就是停止所有节点上的ASM，重启即可。