<<Back to Oracle ASM Main Page
ORA-15106: missing or invalid operating system disk locator string
+ASM2>alter diskgroup DATA
add
failgroup DATA_1 disk
'/dev/mapper/oradata_s2_45',
'/dev/mapper/oradata_s2_47',
failgroup DATA_2 disk
'/dev/mapper/oradata_s2_46',
'/dev/mapper/oradata_s2_48'
rebalance power 3;
ERROR at line 3:
ORA-15106: missing or invalid operating system disk locator string
Cause: The command did not specify a valid operating system path for the device as a string.
Troubleshooting TIPPS
1> Check if all the disks got correct permissions at OS level
eg, ls -lrt /dev/mapper/oradata_s2_45
2> Verify the asm_diskstring parameter is set to discover the newly added disks
SQL> show parameter string
NAME TYPE VALUE
asm_diskstring string /dev/mapper/*s2*
3> Check if ASM can see these disks
+ASM2> select MOUNT_STATUS,HEADER_STATUS,NAME,PATH,FAILGROUP from v$asm_disk
where
HEADER_STATUS= in ('CANDIDATE','PROVIOSINED')
order by path;
If the disks are visible to ASM it can be added without any issues
4> Even if everything is fine but you are still having the issue check out the syntax
In my case it was the syntax problem. Look at line number 6 where I put an extra comma which caused the issue
Comments
Post a Comment