"Oracle" ORA-00600: [kfgfinalize_2]

Source: Internet
Author: User

Environment:

OS:OEL5.6

RAC:10.2.0.1.0

[Email protected] ~]# 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

second Node instance of RAC cannot start

Try to start manually

[Email protected] ~]$ export ORACLE_SID=RACDB2

[Email protected] ~]$ Sqlplus/as SYSDBA

Sql*plus:release 10.2.0.1.0-production on Thu 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 was not mounted

Ora-06512:at Line 4

Show diskgroup no Mount

Then go to ASM to view the status of the DiskGroup and try mount

[Email protected] ~]$ export ORACLE_SID=+ASM2

[Email protected] ~]$ Sqlplus/as SYSDBA

Sql*plus:release 10.2.0.1.0-production on Thu 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], [], [], [], [], [],

[], []

Reported ORA-600: [kfgfinalize_2]

After online verification:

ASM exception crashes, may cause an ASM instance to restart the first time the exception , reported ORA-600: [kfgfinalize_2]

The final solution is to stop the ASMon all nodesand reboot.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.