今天下班前,准备给清分库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
分享到:
相关推荐
ASM 实例中遇到 ORA-4031 官方解决方案
当任何试图分配一个大的连续...这些错误同样可能发生在ASM的实例中。默认的共享池的大小基本能够满足大部分的环境,但是如果遇到ORA-04031错误的时候可能就需要增大。 当遇到这个错误的时候,往往会出现如下的消息显示
REDHAT安装ASM时必须安装的包。一共有三个,分别是 oracleasm-support-2.1.7-1.el5.i386.rpm oracleasm-2.6.18-164.el5-2.0.5-1.el5.i686.rpm oracleasmlib-2.0.4-1.el5.i386.rpm
标签:asm-commons-2.2.1-sources.jar.zip,asm,commons,2.2.1,sources,jar.zip包下载,依赖包
oracleasm-support-2.1.7-1.el5.x86_64.rpm
oracleasm-support-2.1.8-1.el6.x86_64.rpm
ASM磁盘组扩容方案,非常标准的方案,已经多次生产使用,请下载使用。
oracleasm-support-2.1.4-1.el5.x86_64.rpm 适用于内核为2.6.18-164.el5环境使用
oracleasm-support-2.1.8-1.SLE11.x86_64.rpm oracleasm-support-2.1.8-1.SLE11.x86_64.rpm
centos 7 oracleasm-support el7 rpm 安装包
kmod-oracleasm-2.0.8-15.el6_9.x86_64 oracleasm-support-2.1.8-1.el6.x86_64 oracleasmlib-2.0.4-1.el6.x86_64 安装顺序: rpm -ivh kmod-oracleasm-2.0.8-15.el6_9.x86_64.rpm rpm -ivh oracleasm-support-2.1.8...
赠送jar包:asm-all-5.0.2.jar; 赠送原API文档:asm-all-5.0.2-javadoc.jar; 赠送源代码:asm-all-5.0.2-sources.jar; 赠送Maven依赖信息文件:asm-all-5.0.2.pom; 包含翻译后的API文档:asm-all-5.0.2-javadoc-...
重建ASM磁盘组的,1: 保证使用ASM的数据库事先已经用RMAN做了备份 2: 关闭ASM实例 3: 使用dd命令清除ASM磁盘上的元数据 4: 重建ASM磁盘组 5: 恢复数据库
ORA-27303: additional information: MTU could not be verified. Did not receive valid message. These errors are caused by more aggressive checking introduced in 10.2.0.4. Likelihood of Occurrence ...
在Linux平台上配置ASM环境需安装的三个软件包之一。
赠送jar包:asm-all-5.0.2.jar; 赠送原API文档:asm-all-5.0.2-javadoc.jar; 赠送源代码:asm-all-5.0.2-sources.jar; 赠送Maven依赖信息文件:asm-all-5.0.2.pom; 包含翻译后的API文档:asm-all-5.0.2-javadoc-...
oracleasmlib-2.0.2-1.i386.rpm oracleasm-support-2.0.4-1.el5.i386.rpm
oracleasm-support-2.1.3-1.el5.x86_64.rpm
oracleasm-support-2.1.8-1.el5.i386 .rpm oracleasm 所需rpm
asm-1.3.3.jar, asm-1.3.4.jar, asm-1.3.5.jar, asm-1.4.1.jar, asm-1.4.2.jar, asm-1.4.3.jar, asm-1.4.jar, asm-1.5.1.jar, asm-1.5.2.jar, asm-1.5.3.jar, asm-2.0.jar, asm-2.1.jar, asm-2.2.1-sources.jar, asm...