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.