Home > Workload Solutions > Oracle > Guides > Design Guide — Oracle Big Data SQL on Dell EMC PowerFlex > For VM hosting Oracle: Operating system devices and Oracle ASM disk group design
After we presented the database volumes to the VM as virtual disks, we performed the following steps to prepare the virtual disks for Oracle ASM disk group creation:
KERNEL=="sd[a-z]*[1-9]", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="368ccf09800cd6a0eaf106e5a2155cf92",OWNER="grid", GROUP="asmadmin", MODE="0660"
The string “368ccf09800cd6a0eaf106e5a2155cf92” is the SCSI ID of the device.
lrwxrwxrwx 1 root root 10 Nov 9 10:21 /dev/sdh1
lrwxrwxrwx 1 root root 10 Nov 9 10:21 /dev/sdi1
lrwxrwxrwx 1 root root 10 Nov 9 10:21 /dev/sdj1
lrwxrwxrwx 1 root root 10 Nov 9 10:21 /dev/sdk1
lrwxrwxrwx 1 root root 10 Nov 9 10:21 /dev/sdl1
lrwxrwxrwx 1 root root 10 Nov 9 10:21 /dev/sdm1
lrwxrwxrwx 1 root root 10 Nov 9 10:21 /dev/sdn1
lrwxrwxrwx 1 root root 10 Nov 9 10:21 /dev/sdo1
lrwxrwxrwx 1 root root 10 Nov 9 10:21 /dev/sdg1
We created the Oracle ASM disk groups based on the raw devices shown in the following table. The ASM disk groups were created using external redundancy setting. We used the coarse striping setting for the DATA disk group and the fine-grain striping setting for the REDO and TEMP disk groups.
ASM disk group |
Purpose |
ASM striping |
ASM disk group size (GB) |
Device alias in /dev/oracleasm/disks |
Virtual disk |
DATA |
Various database files |
Coarse |
1200 |
ora-data1, ora-data2 |
Hard disk3-4 |
REDO |
Online Redo logs |
Fine grain |
200 |
ora-redo1, ora-redo2, ora-redo3, ora-redo4 |
Hard disk5-8 |
TEMP |
Temp files |
Fine grain |
500 |
ora-temp |
Hard disk9 |
FRA |
Archive logs |
Coarse |
200 |
Ora-fra |
Hard disk10 |