【Oracle】ORA-00600:[kfgFinalize_2]

2014-11-24 15:08:38 · 作者: · 浏览: 0

环境:

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,重启即可。