ACFS Filesystem Monitoring and Group Ownership
By Martin | January 10th, 2011 | Category: 11gR2, Linux, Oracle Database, Oracle Enterprise Manager, Unix | No Comments »When you create an ACFS Filesystem in Grid Infrastructure 11.2.0.1 or 11.2.0.2, the filesystem root directory group ownership is set to Group SS_ASM_GRP, e.g. asmadmin.
1 2 3 4 5 6 7 8 9 10 11 12 | [grid@md1 ~]$ cd /opt/oracle/gridbase/acfsmounts [grid@md1 acfsmounts]$ ls -al total 12 drwxr-xr-x 3 grid oinstall 4096 Jan 10 09:44 . drwxr-xr-x 10 grid oinstall 4096 Jan 10 09:43 .. drwxrwx--- 4 root asmadm 4096 Jan 10 09:44 data_testvol SQL> select * from v$asm_filesystem where fs_name = '/opt/oracle/gridbase/acfsmounts/data_testvol' FS_NAME AVAILABLE BLOCK_SIZE STATE CORRU NUM_VOL TOTAL_SIZE TOTAL_FREE TOTAL_SNAP_SPACE_USAGE ---------------------------------------------- --------- ---------- ------------- ----- ---------- ---------- ---------- ---------------------- /opt/oracle/gridbase/acfsmounts/data_testvol 10-JAN-11 4 AVAILABLE FALSE 1 256 119.769531 0 |
If – for whatever reason – you change the group ownership from asmadm to a different group, ASM can not populate the views v$asm_filesystem and v$asm_acfsvolumes which in turn means that you can not monitor the filesystem with Oracle Enterprise Manager Grid Control because it uses those 2 views for monitoring.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | [root@md1 data_testvol]# chgrp myapp . [root@md1 data_testvol]# ls -la total 80 drwxrwx--- 4 root myapp 4096 Jan 10 09:45 . drwxr-xr-x 3 grid oinstall 4096 Jan 10 09:44 .. drwxr-xr-x 5 root root 4096 Jan 10 09:44 .ACFS -rw-r--r-- 1 root asmadm 610 Jan 10 09:45 .fslimit drwx------ 2 root root 65536 Jan 10 09:44 lost+found SQL> select * from v$asm_filesystem where fs_name = '/opt/oracle/gridbase/acfsmounts/data_testvol' 2 ; no rows selected |
From my point of view, this is a severe limitation. ACFS Filesystems, should like any other filesystem, be able to allow any user/group ownership and still be able to monitor it. However, I could not convince my oracle support engineer to see it the same way…