共计 1134 个字符，预计需要花费 3 分钟才能阅读完成。
在为 ASM 添加磁盘组添加磁盘扩展空间时，遇到以下错误
SQL> alter diskgroup data add disk ‘/dev/rhdisk12’;
alter diskgroup data add disk ‘/dev/rhdisk12’
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15075: disk(s) are not visible cluster-wid
看一下 ORA-15032 和 ORA-15075 的错误解释
[Oracle@mhxy162 ~]$ oerr ora 15032
15032, 00000, “not all alterations performed”
// *Cause: At least one ALTER DISKGROUP action failed.
// *Action: Check the other messages issued along with this summary error.
//
[oracle@mhxy162 ~]$ oerr ora 15075
15075, 00000, “disk(s) are not visible cluster-wide”
// *Cause: An ALTER DISKGROUP ADD DISK command specified a disk that could
// not be discovered by one or more nodes in a RAC cluster
// configuration.
// *Action: Determine which disks are causing the problem from the
// GV$ASM_DISK fixed view. Check operating system permissions
// for the device and the storage sub-system configuration on
// each node in a RAC cluster that cannot identify the disk.
ORA-15075 提到 ’Check operating system permissions for the device’，可以通过 gv$asm_disk 查看。记得修改 /dev/rhdisk12 文件的属组为 grid:oinstall
ls -l /dev/rhdisk12
crw——- 1 grid oinstall 24, 12 8 月 23 15 时 06 /dev/rhdisk12
更多 Oracle 相关信息见 Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12
本文永久更新链接地址 ：http://www.linuxidc.com/Linux/2017-02/140650.htm
