Database Software

Hello all,

I have a SUSE linux 2.6 kernel machine with Oracle Database 10g Enterprise Edition Release 10.1.0.3.0

On this machine, using device-mapper, i have multipath to the array luns. Using udev and a simple rule, i created a device.

But when i try to add this block device as ASM disk, it fails.

I have pasted below all the details. It will be very helpful, if someone can please take a look and suggest on what I'm doing wrong.


dell2800lin1:~ # raw -qa
/dev/raw/raw50: bound to major 8, minor 160
/dev/raw/raw51: bound to major 253, minor 3
dell2800lin1:~ # ls -l /dev/raw/raw51
crwxrwxrwx 1 oracle oinstall 162, 51 Jan 12 15:20 /dev/raw/raw51
dell2800lin1:~ #

oracle@dell2800lin1:~> ls -l /dev/dm-3
brwxrwxrwx 1 oracle oinstall 253, 3 2010-01-11 22:04 /dev/dm-3
oracle@dell2800lin1:~> ls -l /dev/sp_asm_disk
brwxrwxrwx 1 oracle oinstall 253, 3 2010-01-11 22:02 /dev/sp_asm_disk
oracle@dell2800lin1:~> cat /etc/udev/rules.d/10-local.rules
KERNEL=="dm-3", NAME="sp_asm_disk"
oracle@dell2800lin1:~>


SQL> show parameter asm_diskstring;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskstring string /dev/sp_asm_disk, /dev/raw/raw
*
SQL>
SQL> select name, path, group_number from v$asm_disk;

NAME
------------------------------
PATH
--------------------------------------------------------------------------------
GROUP_NUMBER
------------

/dev/raw/raw51
0

TESTDG_0000
/dev/raw/raw50
1

NAME
------------------------------
PATH
--------------------------------------------------------------------------------
GROUP_NUMBER
------------


SQL>
SQL> CREATE DISKGROUP udev_dg external redundancy disk '/dev/sp_asm_disk';
CREATE DISKGROUP udev_dg external redundancy disk '/dev/sp_asm_disk'
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15031: disk specification '/dev/sp_asm_disk' matches no disks
ORA-15025: could not open disk '/dev/sp_asm_disk'
ORA-15059: invalid device type for ASM disk
Linux Error: 24576: Unknown system error
Additional information: 42
Additional information: -1080161616


SQL>