环境:虚拟机+Linux+oracle 11gR2+RAC
步骤:1、安装grid
2、安装database
3、ASMCA创建磁盘组
4、DBCA建库
问题:在用dbca建库时找不到磁盘组~~CRS和ASM都正常启动
请老大们帮忙分析一下原因,谢谢!
磁盘权限:
[root@rac01 /]# ls -lrt /dev/sd*
brw-rw---- 1 grid asmadmin 8, 1 Jan 4 13:59 /dev/sda1
brw-rw---- 1 grid asmadmin 8, 96 Jan 4 14:00 /dev/sdg
brw-rw---- 1 grid asmadmin 8, 16 Jan 4 14:00 /dev/sdb
brw-rw---- 1 grid asmadmin 8, 32 Jan 4 14:00 /dev/sdc
brw-rw---- 1 grid asmadmin 8, 48 Jan 4 14:00 /dev/sdd
brw-rw---- 1 grid asmadmin 8, 80 Jan 4 14:00 /dev/sdf
brw-rw---- 1 grid asmadmin 8, 64 Jan 4 14:00 /dev/sde
brw-rw---- 1 grid asmadmin 8, 128 Jan 4 14:00 /dev/sdi
brw-rw---- 1 grid asmadmin 8, 160 Jan 4 14:00 /dev/sdk
brw-rw---- 1 grid asmadmin 8, 112 Jan 4 14:00 /dev/sdh
brw-rw---- 1 grid asmadmin 8, 176 Jan 4 14:00 /dev/sdl
brw-rw---- 1 grid asmadmin 8, 144 Jan 4 14:00 /dev/sdj
brw-rw---- 1 grid asmadmin 8, 17 Jan 4 15:46 /dev/sdb1
brw-rw---- 1 grid asmadmin 8, 33 Jan 4 15:46 /dev/sdc1
brw-rw---- 1 grid asmadmin 8, 49 Jan 4 15:46 /dev/sdd1
brw-rw---- 1 grid asmadmin 8, 65 Jan 4 15:46 /dev/sde1
brw-rw---- 1 grid asmadmin 8, 81 Jan 4 15:46 /dev/sdf1
brw-rw---- 1 grid asmadmin 8, 97 Jan 4 15:46 /dev/sdg1
brw-rw---- 1 grid asmadmin 8, 113 Jan 4 15:46 /dev/sdh1
brw-rw---- 1 grid asmadmin 8, 129 Jan 4 15:46 /dev/sdi1
brw-rw---- 1 grid asmadmin 8, 145 Jan 4 15:46 /dev/sdj1
brw-rw---- 1 grid asmadmin 8, 161 Jan 4 15:46 /dev/sdk1
brw-rw---- 1 grid asmadmin 8, 177 Jan 4 15:46 /dev/sdl1
brw-rw---- 1 grid asmadmin 8, 2 Jan 4 2011 /dev/sda2
brw-rw---- 1 grid asmadmin 8, 0 Jan 4 2011 /dev/sda
ASM实例查看磁盘组:
[grid@rac01 ~]$ asmcmd
ASMCMD> ls
DG_ARCH/
DG_CRS/
DG_DATA/
DG_FLSH/
DG_REDO/
///
[grid@rac02 ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.DG_ARCH.dg ora....up.type 0/5 0/ ONLINE ONLINE rac01
ora.DG_CRS.dg ora....up.type 0/5 0/ ONLINE ONLINE rac01
ora.DG_DATA.dg ora....up.type 0/5 0/ ONLINE ONLINE rac01
ora.DG_FLSH.dg ora....up.type 0/5 0/ ONLINE ONLINE rac01
ora.DG_REDO.dg ora....up.type 0/5 0/ ONLINE ONLINE rac01
ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE rac01
ora....N1.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE rac01
ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE rac01
ora.eons ora.eons.type 0/3 0/ ONLINE ONLINE rac01
ora.gsd ora.gsd.type 0/5 0/ OFFLINE OFFLINE
ora....network ora....rk.type 0/5 0/ ONLINE ONLINE rac01
ora.oc4j ora.oc4j.type 0/5 0/0 OFFLINE OFFLINE
ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE rac01
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE rac01
ora....01.lsnr application 0/5 0/0 ONLINE ONLINE rac01
ora.rac01.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.rac01.ons application 0/3 0/0 ONLINE ONLINE rac01
ora.rac01.vip ora....t1.type 0/0 0/0 ONLINE ONLINE rac01
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE rac02
ora....02.lsnr application 0/5 0/0 ONLINE ONLINE rac02
ora.rac02.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.rac02.ons application 0/3 0/0 ONLINE ONLINE rac02
ora.rac02.vip ora....t1.type 0/0 0/0 ONLINE ONLINE rac02
ora....ry.acfs ora....fs.type 0/5 0/ ONLINE ONLINE rac01
ora.scan1.vip ora....ip.type 0/0 0/0 ONLINE ONLINE rac01
[grid@rac02 ~]$
//
检查集群节点
[grid@rac01 ~]$ olsnodes -n
rac01 1
rac02 2
检查两个节点上的 Oracle TNS 监听器进程
[grid@rac01 ~]$ ps -ef | grep lsnr | grep -v 'grep' | grep -v 'ocfs' | awk '{print $9}'
LISTENER
LISTENER_SCAN1
[grid@rac02 ~]$ ps -ef | grep lsnr | grep -v 'grep' | grep -v 'ocfs' | awk '{print $9}'
LISTENER
[grid@rac01 ~]$ srvctl status asm -a
ASM is running on rac01,rac02
ASM is enabled.
[grid@rac02 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2484
Available space (kbytes) : 259636
ID : 405655344
Device/File Name : +DG_CRS
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check bypassed due to non-privileged user
//
grid@rac02 ~]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 4f46fb035cec4f93bfd3abee9a78241e (ORCL:VD1) [DG_CRS]
2. ONLINE 41bab13316434fcabf7293779ebfe709 (ORCL:VD2) [DG_CRS]
3. ONLINE 87f830e4b6614fa8bf93455a8ceaf5c9 (ORCL:VD3) [DG_CRS]
Located 3 voting disk(s).