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 AttributeValue
SSA, FAStT, or non-MPIO-capable disks reserve_lockno
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