Troubleshooting

Improving Oracle OLTP database performance with Dell Fluid Cache for DAS
27
KERNEL=="sd*", PROGRAM="scsi_id --page=0x83 --whitelisted --
device=/dev/%k", RESULT=="<WWID_for_sdh>", OWNER:="grid",
GROUP:="asmadmin", MODE:=”0660”
KERNEL=="sd*", PROGRAM="scsi_id --page=0x83 --whitelisted --
device=/dev/%k", RESULT=="<WWID_for_sdi>", OWNER:="grid",
GROUP:="asmadmin", MODE:=”0660”
KERNEL=="sd*", PROGRAM="scsi_id --page=0x83 --whitelisted --
device=/dev/%k", RESULT=="<WWID_for_sdj>", OWNER:="grid",
GROUP:="asmadmin", MODE:=”0660”
KERNEL=="sd*", PROGRAM="scsi_id --page=0x83 --whitelisted --
device=/dev/%k", RESULT=="<WWID_for_sdk>", OWNER:="grid",
GROUP:="asmadmin", MODE:=”0660”
KERNEL=="sd*", PROGRAM="scsi_id --page=0x83 --whitelisted --
device=/dev/%k", RESULT=="<WWID_for_sdl>", OWNER:="grid",
GROUP:="asmadmin", MODE:=”0660”
KERNEL=="sd*", PROGRAM="scsi_id --page=0x83 --whitelisted --
device=/dev/%k", RESULT=="<WWID_for_sdm>", OWNER:="grid",
GROUP:="asmadmin", MODE:=”0660”
KERNEL=="sd*", PROGRAM="scsi_id --page=0x83 --whitelisted --
device=/dev/%k", RESULT=="<WWID_for_sdn>", OWNER:="grid",
GROUP:="asmadmin", MODE:=”0660”
3. Restart the udev rules to apply the rules.
3.1. $> start_udev
Appendix C.2.2. Udev settings for Fluid Cache based solution
After enabling caching on the block devices that belong to the DATA_DG, Fluid Cache creates an
equivalent fldc cache block device as noted in Appendix C.1.1 Enabling Fluid Cache. In order for ASM
to be able to mount the DATA_DG again, we need to disable Oracle permission on those VDs and give
permission to the equivalent fldc block devices. In order to achieve this edit the
/etc/udev/rules.d/20-Dell_Oracle.rules file configured for the baseline configuration as
described in Appendix C.2.1. Udev settings for baseline configuration and do the following steps:
1. Add the following line to set the permission for the Fluid Cache block devices
KERNEL==”fldc*”, OWNER:=”grid”, GROUP:=”asmadmin”, MODE:=”0660”
2. Comment out the lines containing the block devices enabled for caching while leaving the block
devices belonging to the FRA_DG as is.
# KERNEL=="sd*", PROGRAM="scsi_id --page=0x83 --whitelisted --
device=/dev/%k", RESULT=="<WWID_for_sdc>", OWNER:="grid",
GROUP:="asmadmin", MODE:=”0660”
# KERNEL=="sd*", PROGRAM="scsi_id --page=0x83 --whitelisted --
device=/dev/%k", RESULT=="<WWID_for_sdd>", OWNER:="grid",
GROUP:="asmadmin", MODE:=”0660”