Tuesday 13 October 2015

ASM Disks Permissions (HP-UX)

On a fateful day permissions of ASM disks in a production database were changed after the system administrator added new disks on the server. The process of adding the new disks led to all the disk permissions changing to bin:sys. Because I did not set up the database, I did not know the correct ownership/permissions for the disks and had to do some permutations before eventually getting it right.
In such a situation this command kfod disks=all would come in handy. It would run with both ASM and database instance down. See sample output below;

testsvr:/home/grid$kfod disks=all

--------------------------------------------------
Disk    Size   Path               User   Group
======= ====== ================== ====== =========
1:      1024Mb /dev/rdisk/disk10  grid   asmadmin
2:      1024Mb /dev/rdisk/disk15  grid   asmadmin
3:      2622Mb /dev/rdisk/disk11  grid   asmadmin
4:      2560Mb /dev/rdisk/disk12  grid   asmadmin
--------------------------------------------------
ORACLE_SID ORACLE_HOME

==================================================

For system administrators presenting new disks during which they might be installing new devices they should use "insf –ed" instead of "insf –e". The latter command usually resets the permission/ownership of all the disks.


Hope this helps!

Kehinde.

No comments:

Post a Comment