ASM Diskgroup Can Not Be Shown When Creating Database With DBCA

在安装oracle 11g R2 RAC的时候，有时候会遇到在用DBCA建立数据库时使用ASM作为文件存储，看不到相关的ASM diskgroup 组的问题。，用GRID用户，使用ASMCA建立相关的disk group，在resource组里也显示正常。这个问题遇到过几次。最近一次是由于grid 用户目录下oracle 执行文件没有设置成S。以前安装时都是oracle 自动设置，支持不知道为什么没有改变。可能是由于我原来安装的是11.2.0.1，支持改变成11.2.0.2.有什么地方没清除干净等原因。

解决问题一般有如下解决方法：

[@more@]

Cause

The root cause can be anyone of the following:

1. Incorrect permission setting for oracle user
2. ASM instance was not started or diskgroups are not mounted.
3. The diskgroup resources are not online.
4. The permission setting for the asm devices are incorrect.
5. The oracle executable under /bin has incorrect permission settings.

Solution

Make sure all the above factors are met:

1. Correct permission setting for oracle user
e.g:[root@db01 ~]# id oracle
uid=502(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),506(asmdba)<== the oracle user is a member of asmdba group

2. ASM instance has been started and diskgroups has been mounted.
e.g:SQL> select name,state,type from v$asm_diskgroup; <== the asm diskgroups have been mounted and the query on v$asm_diskgroup can return rows with grid user

NAME STATE TYPE
------------------------------ ----------- ------
OCR_VOTE MOUNTED NORMAL
ORADATA MOUNTED NORMAL
ORAFLASH MOUNTED NORMAL
......

3. The diskgroup resources are online.
e.g:[grid@db01 cfgtoollogs]$ crsctl stat resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
......
ora.OCR_VOTE.dg
ONLINE ONLINE db01
ONLINE ONLINE db02
ora.ORADATA.dg
ONLINE ONLINE db01
ONLINE ONLINE db02 <=== diskgroup resources are online.

4. The permission setting for the asm devices are correct.
[grid@db01 cfgtoollogs]$ ls -l /dev/oracleasm/disks
total 0
brw-rw---- 1 grid asmdba 8, 33 Nov 4 15:35 DATA
brw-rw---- 1 grid asmdba 8, 49 Nov 4 15:35 OCR_VOTE
brw-rw---- 1 grid asmdba 8, 17 Nov 4 15:35 RECO
......

5. Ownership and permission of the oracle executable under /bin are correct.
e.g: -rwsr-s--x 1 grid oinstall 152400480 Feb 3 2010 oracle

使用 chmod +s oracle 就可以改变。

ITPub博客

ASM Diskgroup Can Not Be Shown When Creating Database With DBCA

Cause

Solution

最新文章