Mani's Blog

December 2, 2011

ORA-15018: diskgroup cannot be created : ORA-00600: internal error code, arguments: [kfmNew], [2], [], [], [], [], [], [], [], [], [], []

Filed under: Uncategorized — mani @ 6:15 pm

We were using SSD for one of our Databases,  that SSD is crashed and the server is replaced with new SSD.   I was able to create ASM disk successfully, however I couldn’t create diskgroup.  Following error was thrown.  I have seen this error when we install used SSD.  Thought may be helpful to others.

Problem:

SQL> select name, state, free_mb, total_mb from v$asm_diskgroup;

no rows selected

SQL> select path,header_status from v$asm_disk;

PATH
——————————————————————————————————————————————————————————————————–
HEADER_STATUS
————————————
ORCL:ASM_SSD1
PROVISIONED

/dev/oracleasm/disks/ASM_SSD1
PROVISIONED

SQL> CREATE DISKGROUP XN_DATA EXTERNAL REDUNDANCY DISK ‘ORCL:*’;
CREATE DISKGROUP XN_DATA NORMAL REDUNDANCY DISK ‘ORCL:*’
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-00600: internal error code, arguments: [kfmNew], [2], [], [], [], [], [], [], [], [], [], []

Solution:

Zero out the disk with dd command.

[oracle@m120359 ~]$ su –
Password:
[root@m120359 ~]# dd if=/dev/zero of=/dev/sdb bs=4096 count=1
1+0 records in
1+0 records out
4096 bytes (4.1 kB) copied, 0.000191 seconds, 21.4 MB/s

[oracle@m120359 ~]$ export ORACLE_SID=+ASM
[oracle@m120359 ~]$ dba

SQL*Plus: Release 11.1.0.7.0 – Production on Thu Dec 1 21:48:09 2011

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

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate;
ORA-15100: invalid or missing diskgroup name

ASM instance shutdown
SQL> startup
ASM instance started

Total System Global Area  283930624 bytes
Fixed Size            2158992 bytes
Variable Size          256605808 bytes
ASM Cache           25165824 bytes
ORA-15110: no diskgroups mounted

SQL> CREATE DISKGROUP XN_DATA EXTERNAL REDUNDANCY DISK ‘ORCL:*’;

Diskgroup created.

SQL>

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: