Mount point permissions

[Cara Tock]

I have a two node MC/Service Guard cluster. When I fail a package over from one node to the other the owner of the mount point and any directories under it change to a different user. I need for the user to remain oracle. The owner of the mount point is correct before the package failover.

[Thierry Poels_1 · Accepted solution]

Hi,

check user IDs on both systems they should be the same. My guess is that Oracle has different UIDs on both systems. (remember file ownership is determined by UID and not by user name, the user name is derived from /etc/passwd)

regards,
Thierry.

[PIYUSH D. PATEL]

Hi,
The UID for oracle should be same on both the systems. Was this working previously or you got to know this now only. It may be possible that Oracle UID was not set properly during installation.

Piyush

[Andrew Cowan]

This can also occur if the underlying mountpoints have the wrong permissions. Stop the package and unmount the filesystem (if required and do an ls -l and ls -ld on the mountpoint. I usually make all mountpoints owned by root and 0777. There should also be no files in the directory beneath the mountpoint. If there are, delete them!
Now restart the package, remount etc. and check the permissions of the directory. If you repeat this on the other node(s) it may clear your problem.

[Nick Wickens]

Ideally any users that would use a Service guard package should have the same UID's on both nodes especially if they will be using filesystem data as well as the database.

I believe that using NIS will do this for you, but in my case because the second node had an alternate use and I was not able to simply update the entire user area I wrote a script to synchronise the UIDS across the two systems. You can use the usermod -u command to do this.

Once done I now use a script on both systems when creating new users that ensures that the UIDS don't conflict.