关于Oracle 11gR2 RAC无法识别ASM磁盘组解决方案
(2011-05-16 15:26:12)
标签:
磁盘组创建无法识别属性安装 |
分类: RAC |
1、更改了GRID_HOME的权限。在完成grid的安装后会执行root.sh脚本,执行之后GRID_HOME的属主变为root。特别是GRID_HOME/bin/oracle的属性,如果发生改变可能导致磁盘识别不到。
2、磁盘头信息。如果安装过一次,但是由于遇到某些错误导致安装失败。然后删掉数据库重新安装,突然DiskGroups识别不到。这个时候就要考虑Format磁盘头部信息。
3、磁盘资源组没有正常启动。在ASMCA创建完DiskGroups之后,由于某种原因导致资源组没有正常启动。可以通过CRS_STAT查看。
4、磁盘权限。利用ASMLIB创建ASM磁盘,磁盘的属性都是root:disk。可以尝试更改属性为:grid:asmadmin或者grid:oinstall。
补充:
如果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