Troubleshooting

Improving Oracle OLTP database performance with Dell Fluid Cache for DAS

7.1. $> su – grid

7.2. grid@$> sqlplus / as sysasm

7.3. SQL> crsctl start has

7.4. SQL> exit

7.5. Run the following command as grid user to check if the entire OHAS stack is up and running

7.5.1. grid@$> crsctl stat –res -t

Appendix C.2. Setting up ownership and permission for Oracle disks

This section describes the udev rules that need to be set for both the baseline and the Fluid

Cache based storage solution.

Appendix C.2.1. Udev settings for baseline configuration

1. It is recommended to set the udev rules for the block devices to be used for ASM disk using

their WWIDs. Identify the WWIDs for all the VDs that are to be configured for Oracle ASM by

running the following command

$> scsi_id --page=0x83 --whitelisted --device=/dev/sdX

where sdX is the name of the block device to be used for Oracle

E.g. output:

sdc 360026b900061855e000008a54ea5356a

2. Edit the /etc/udev/rules.d/20-Dell_Oracle.rules file (create a new file if it doesn’t

already exist) and add the following lines to set the permissions needed for the baseline

configuration. Replace each of the <WWID_for_sdX> below with the correct equivalent WWID

result obtained from step 1 for that sdX block device. The example below adds all the twelve

block devices to be configured for the baseline configuration.

KERNEL=="sd*", PROGRAM="scsi_id --page=0x83 --whitelisted --

device=/dev/%k", RESULT=="<WWID_for_sdc>", OWNER:="grid",