I built two RHEL 6.5 servers that will have Oracle DBs running on them. I created a udev-disk file in /etc/udev/rules.d/ that includes the scsi ids, user/group ownership, devices names, etc. After I was done I ran partprobe and start_udev. All is good, devices names show under /dev with the correct permissions.

Problem, after reboots, disk devices show root:root as the owners. I then run command start_udev and then correct permissions appear, in this case oracleracle.

How do I fix it, so oracleracle stay after reboot?

THanks.

add a entry for them in /etc/fstab

and mount them as rw

He may be using the disks as raw table spaces - in which case, the Oracle database has total control over the disk and allocations. This can be a bit more efficient (less overhead specifically) than using a filesystem to hold files for tablespaces.

What he needs is for udev to set the ownership of the device names to that of the oracle database (last I knew this was the "oracle" login).

I think what the OP wants is in:

http://www.oracle-base.com/articles/...ux-5-and-6.php

Please attach the rule file, it might be easier to help.

Yes jpollard, you are correct. Oracle has control of the devices, so no entries in /etc/fstab, no pvcreate/vgcreate/lvcreate. Basically you only partition the disks with fdisk and configure UDEV.

The linux servers I configured use Quest/VAS to authenticate to the domain. After reboot the UDEV service started before the VAS service, so the oracle owners could not be authenticated, therefore assigning root:root.

The fix: use the uid and gid of the owner:group in place of the names within the udev-asm file created at /etc/udev/rules.d/. Below is what inside of the file looks like, for one disk.

KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -d /dev/$parent", RESULT=="36000c295c17f976e30ac061baeb62a08", NAME="cst_data_01", OWNER="199", GROUP="209", MODE="0660"

If these are non-raid disks, you should be able to use LVM to set up the raid and partitions - then hand them over to Oracle.

I do think it is still better to have hardware raid external to the operating system.

I have also faced Oracle db cluster user/group ownership issues with devices after server reboot (RHEL 6.8 64bit).
I found that there is a bug in package "udev-147-2.73.el6_8.1.x86_64" (RHEL 6.8)
The problem solved after updating package to "udev-147-2.73.el6_8.2.x86_64"

The temporary work around was to run #/sbin/start_udev to set permissions on devices under /dev/

A possible workaround is to run:

@Satishk: Thank you very much! I was for 2 days looking for this issue. You really helped me!

Cheers Mate!