执行adrci检查命令发现报错
[grid@db1-[+ASM1]-/home/grid]$ adrci exec="select SHORTP_POLICY,LONGP_POLICY from adr_control"
DIA-48251: Failed to open relation due to following error
DIA-48122: error with opening the ADR block file [/u01/app/grid/diag/crs/db1/crs_jiankong/metadata/ADR_CONTROL.ams] [0]
DIA-48191: user missing read or write permission on specified file
Linux-x86_64 Error: 13: Permission denied
Additional information: 6
Additional information: 438
Additional information: 33184
正常情况应该显示:
ADR Home = /u01/app/grid/diag/kfod/db1/kfod:
*************************************************************************
SHORTP_POLICY LONGP_POLICY
-------------------- --------------------
720 8760
ADR Home = /u01/app/grid/diag/asm/+asm/+ASM1:
*************************************************************************
SHORTP_POLICY LONGP_POLICY
-------------------- --------------------
720 2160
...
检查文件属主和权限
[grid@db1-[+ASM1]-/home/grid]$ ls -l /u01/app/grid/diag/crs/db1/crs_jiankong/metadata/ADR_CONTROL.ams
-rw-r----- 1 jiankong jiankong 65536 Aug 6 09:15 /u01/app/grid/diag/crs/db1/crs_jiankong/metadata/ADR_CONTROL.ams
[grid@db1-[+ASM1]-/home/grid]$ ls -l /u01/app/grid/diag/clients/user_root/host_51324114_110/metadata/ADR_CONTROL.ams
-rw-r----- 1 root root 65536 Aug 2 17:01 /u01/app/grid/diag/clients/user_root/host_51324114_110/metadata/ADR_CONTROL
监控用户创建的(或者修改了属主)
处置方法:
change ADR OS permissions to allow write access to the required users
For EM SWB support, is should be enough to add group write permissions to all ADR directories and files.
- OR -
run adrci from a user who has access to this ADR folder like Oracle (in case you cannot grant permissions to other users on the ADR)
忽略