如何解决AIX 上添加ASM磁盘组遇 ORA-15075 disk(s) are not visible cluster-wide 错误_VMware, Unix及操作系统讨论区_Weblogic技术|Tuxedo技术|中间件技术|Oracle论坛|JAVA论坛|Linux/Unix技术|hadoop论坛

总帖数

每页帖数

1/1页

返回列表

发起投票

查看: 6394 | 回复: 0

主题： 如何解决AIX 上添加ASM磁盘组遇 ORA-15075 disk(s) are not visible cluster-wide 错误

本主题由 koei123 于 2015-6-1 15:09:19 移动

wzj

注册用户

等级：新兵
经验：67
发帖：64
精华：0
注册：2011-11-15
状态：离线
发送短消息息给wzj

加好友发送短消息息给wzj

发消息

发表于：

2015-3-31 17:25:01 | [全部帖] [楼主帖]

楼主

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 磁盘组中。

--转自