unable to add disks to asm diskgroup
- From: Mohan <krisgator@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 18 Nov 2010 17:07:51 -0600
Hi folks,
I am facing this wierd ASM diskgroup issue. I am trying to add disks to
already existing diskgroups data and fra and found the below error:
SQL> alter diskgroup DATA add disk
'/dev/oracleasm/disks/DISK3,/dev/oracleasm/disks/DISK4';
alter diskgroup DATA add disk
'/dev/oracleasm/disks/DISK3,/dev/oracleasm/disks/DISK4'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15031: disk specification
'/dev/oracleasm/disks/DISK3,/dev/oracleasm/disks/DISK4' matches no disks
I do not see any candidate disks when I query v$asm_disk:
SQL> select group_number, disk_number, mount_status, header_status, path
from v$asm_disk;
GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU PATH
------------ ----------- ------- ------------
--------------------------------------------------
1 0 CACHED MEMBER ORCL:DISK1
2 0 CACHED MEMBER ORCL:DISK15
2 1 CACHED MEMBER ORCL:DISK16
2 2 CACHED MEMBER ORCL:DISK17
1 1 CACHED MEMBER ORCL:DISK2
I see the ASM disks when I check the disk string location:
SQL> show parameter disk
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
asm_diskgroups string data, fra
asm_diskstring string /dev/oracleasm/disks
[root@duifddd1 disks]# ls -l /dev/oracleasm/disks/
total 0
brw-rw---- 1 oracle dba 253, 19 Aug 17 16:06 DISK1
brw-rw---- 1 oracle dba 253, 28 Aug 17 16:06 DISK10
brw-rw---- 1 oracle dba 253, 29 Aug 17 16:06 DISK11
brw-rw---- 1 oracle dba 253, 30 Aug 17 16:06 DISK12
brw-rw---- 1 oracle dba 253, 33 Aug 17 16:06 DISK15
brw-rw---- 1 oracle dba 253, 34 Aug 17 16:06 DISK16
brw-rw---- 1 oracle dba 253, 35 Aug 17 16:06 DISK17
brw-rw---- 1 oracle dba 253, 20 Aug 17 16:06 DISK2
brw-rw---- 1 oracle dba 253, 21 Aug 17 16:06 DISK3
brw-rw---- 1 oracle dba 253, 22 Aug 17 16:06 DISK4
brw-rw---- 1 oracle dba 253, 23 Aug 17 16:06 DISK5
brw-rw---- 1 oracle dba 253, 24 Aug 17 16:06 DISK6
brw-rw---- 1 oracle dba 253, 25 Aug 17 16:06 DISK7
brw-rw---- 1 oracle dba 253, 26 Aug 17 16:06 DISK8
brw-rw---- 1 oracle dba 253, 27 Aug 17 16:06 DISK9
[root@duifddd1 disks]# /usr/sbin/oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
[root@duifddd1 disks]# oracleasm-discover
Using ASMLib from /opt/oracle/extapi/64/asm/orcl/1/libasm.so
[ASM Library - Generic Linux, version 2.0.4 (KABI_V2)]
Discovered disk: ORCL:DISK1 [10485760 blocks (5368709120 bytes), maxio 512]
Discovered disk: ORCL:DISK10 [10485760 blocks (5368709120 bytes), maxio 512]
Discovered disk: ORCL:DISK11 [10485760 blocks (5368709120 bytes), maxio 512]
Discovered disk: ORCL:DISK12 [10485760 blocks (5368709120 bytes), maxio 512]
Discovered disk: ORCL:DISK15 [10485760 blocks (5368709120 bytes), maxio 512]
Discovered disk: ORCL:DISK16 [10485760 blocks (5368709120 bytes), maxio 512]
Discovered disk: ORCL:DISK17 [10485760 blocks (5368709120 bytes), maxio 512]
Discovered disk: ORCL:DISK2 [10485760 blocks (5368709120 bytes), maxio 512]
Discovered disk: ORCL:DISK3 [10485760 blocks (5368709120 bytes), maxio 512]
Discovered disk: ORCL:DISK4 [10485760 blocks (5368709120 bytes), maxio 512]
Discovered disk: ORCL:DISK5 [10485760 blocks (5368709120 bytes), maxio 512]
Discovered disk: ORCL:DISK6 [10485760 blocks (5368709120 bytes), maxio 512]
Discovered disk: ORCL:DISK7 [10485760 blocks (5368709120 bytes), maxio 512]
Discovered disk: ORCL:DISK8 [10485760 blocks (5368709120 bytes), maxio 512]
Discovered disk: ORCL:DISK9 [10485760 blocks (5368709120 bytes), maxio 512]
[root@duifddd1 disks]# /usr/sbin/oracleasm listdisks
DISK1
DISK10
DISK11
DISK12
DISK15
DISK16
DISK17
DISK2
DISK3
DISK4
DISK5
DISK6
DISK7
DISK8
DISK9
my /etc/sysconfig/oracleasm is as follows:
[root@duifddd1 disks]# cat /etc/sysconfig/oracleasm
#
# This is a configuration file for automatic loading of the Oracle
# Automatic Storage Management library kernel driver. It is generated
# By running /etc/init.d/oracleasm configure. Please use that method
# to modify this file
#
# ORACLEASM_ENABELED: 'true' means to load the driver on boot.
ORACLEASM_ENABLED=true
# ORACLEASM_UID: Default user owning the /dev/oracleasm mount point.
ORACLEASM_UID=oracle
# ORACLEASM_GID: Default group owning the /dev/oracleasm mount point.
ORACLEASM_GID=dba
# ORACLEASM_SCANBOOT: 'true' means scan for ASM disks on boot.
ORACLEASM_SCANBOOT=true
# ORACLEASM_SCANORDER: Matching patterns to order disk scanning
ORACLEASM_SCANORDER="multipath"
# ORACLEASM_SCANEXCLUDE: Matching patterns to exclude disks from scan
ORACLEASM_SCANEXCLUDE="sd dm"
Am I missing anything here?
-Mohan
Other related posts:
