AIX 上添加ASM磁盘组遇 ORA-15075 disk(s) are not visible cluster-wide 错误

今天下班前，准备给清分库AIX主机添加 ASM 磁盘组，因为手里没有任何操作文档，当时硬件厂商在系统层面
添加完共享磁盘后，就直接上了。


结果遇到如下错误：


alter diskgroup DATA add disk '/dev/rhdisk13,/dev/rhdisk13' rebalance power 5;
alter diskgroup DATA add disk '/dev/rhdisk13,/dev/rhdisk13' rebalance power 5;
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15075: disk(s) are not visible cluster-wide


metalink 上的解释如下：


OERR: ORA-15075 disk(s) are not visible cluster-wide [ID 288002.1] 转到底部
修改时间:2012-7-25类型:REFERENCE状态:PUBLISHED优先级:3
注释 (0)


Applies to:


Oracle Server - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.
Checked for relevance on 11 Jul 2012
Purpose


Provide OERR information for ORA-15075


Details


{ This note contains error information about an "Oracle Server" error number. It may contain additional support notes as described in Note:22080.1 }


Error: ORA-15075
Text: disk %s is not visible on instance number %s
---------------------------------------------------------------------------
Cause: An ALTER DISKGROUP ADD DISK command specified a disk that could not be discovered.
Action: Check operating system permissions for the device and the storage subsystem configuration on the specified node.


原因可能是因为磁盘设备的OS权限不适当，或者磁盘设备的配置不当导致节点无法发现共享设备。
于是马上回顾了一下我们的操作步骤：
在硬件存储厂商给我们配好磁盘后，我们的操作步骤只修改了/dev/rhdiskn 的权限设置，将其修改为和现有 ASM 磁盘组设备一样，然后便立即
执行了 alter diskgroup DATA add disk '/dev/rhdisk13,/dev/rhdisk13' rebalance 5; 操作，而在 AIX 平台上正确的ASM磁盘组添加步骤
中还需要修改一些磁盘的相关属性，赶紧查阅官方文档，在
《Oracle? Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide10g Release 2 (10.2) for AIX》中
针对 AIX 平台的 ASM 磁盘操作有了明确说明：


To enable simultaneous access to a disk device from multiple nodes, you must set the appropriate Object Data Manager (ODM) attribute listed in the following table to the value shown, depending on the disk type:


Disk Type Attribute Value
SSA, FAStT, or non-MPIO-capable disks reserve_lock no
ESS, EMC, HDS, CLARiiON, or MPIO-capable disks reserve_policy no_reserve
To determine whether the attribute has the correct value, enter a command similar to the following on all cluster nodes for each disk device that you want to use:


# /usr/sbin/lsattr -E -l hdiskn


If the required attribute is not set to the correct value on any node, then enter a command similar to one of the following on that node:


SSA and FAStT devices


# /usr/sbin/chdev -l hdiskn -a reserve_lock=no


ESS, EMC, HDS, CLARiiON, and MPIO-capable devices


# /usr/sbin/chdev -l hdiskn -a reserve_policy=no_reserve


Enter commands similar to the following on any node to clear the PVID from each disk device that you want to use:


# /usr/sbin/chdev -l hdiskn -a pv=clear


When you are installing Oracle Clusterware, you must enter the paths to the appropriate device files when prompted for the path of the OCR and Oracle Clusterware voting disk, for example:


/dev/rhdisk10




从上得知正是因为我们没有修改磁盘设备的 Object Data Manager (ODM) 属性，导致集群无法正常发现共享磁盘。

果断修改上述属性后，磁盘能够正确添加到 ASM 磁盘组中。

转载请注明作者出处及原文链接：

http://blog.csdn.net/xiangsir/article/details/8670967