oracle 11.2.0.3 asm非rac双机,ORACLE 11.2.0.4 RAC无法识别ASM磁盘组

组 --->解决问题

这篇文章对dbca 无法发现asm磁盘组进行简单的分析。此外，作者还列出了一种情况，就是我在测试过程中遇到的情况：oracle 用户缺少 asmoper,asmdba用户组。

原文如下：

补充：

如果oracle的用户组缺失也会出现这类问题：

比如oracle没有加入oper，asmoper及asmdba组中，oracle是没有权限操作asm磁盘的。日志会报错如下：

[AWT-EventQueue-0] [ 2012-11-04 16:17:14.341 CST ] [SQLEngine.initialize:325]  Execing SQLPLUS/SVRMGR process...

[AWT-EventQueue-0] [ 2012-11-04 16:17:14.353 CST ] [SQLEngine.initialize:362]  m_bReaderStarted: false

[AWT-EventQueue-0] [ 2012-11-04 16:17:14.353 CST ] [SQLEngine.initialize:366]  Starting Reader Thread...

[AWT-EventQueue-0] [ 2012-11-04 16:17:14.389 CST ] [SQLEngine.done:2189]  Done called

[AWT-EventQueue-0] [ 2012-11-04 16:17:14.390 CST ] [SQLEngine.done:2189]  Done called

[AWT-EventQueue-0] [ 2012-11-04 16:17:14.390 CST ] [ASMUtils.loadDiskGroups:863]  ORA-01031: insufficient privileges

[AWT-EventQueue-0] [ 2012-11-04 16:28:57.804 CST ] [Host.cleanup:3663]  Dbca exit status is: -1

[AWT-EventQueue-0] [ 2012-11-04 16:28:57.804 CST ] [Host.cleanup:3666]  check point context null

[AWT-EventQueue-0] [ 2012-11-04 16:28:57.807 CST ] [InventoryUtil.getOUIInvSession:347]  setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS

[AWT-EventQueue-0] [ 2012-11-04 16:28:57.807 CST ] [InventoryUtil.getHomeName:111]  homeName = OraDb11g_home1

四、尝试方法1：

先进行重建。

配置asmlib时，由：

ORACLEASM_ENABLED=true

ORACLEASM_UID=grid

ORACLEASM_GID=asmdba

ORACLEASM_SCANBOOT=true

ORACLEASM_SCANORDER=""

ORACLEASM_SCANEXCLUDE=""

ORACLEASM_USE_LOGICAL_BLOCK_SIZE="false"

改变为->

ORACLEASM_ENABLED=true

ORACLEASM_UID=grid

ORACLEASM_GID=dba  --->11.2.0.3 可用

ORACLEASM_SCANBOOT=true

ORACLEASM_SCANORDER=""

ORACLEASM_SCANEXCLUDE=""

ORACLEASM_USE_LOGICAL_BLOCK_SIZE="false"

按照此种方式重建后：

----问题仍然存在