Oracle 11g RAC 创建实例DBCA无法发现ASM Diskgroup

安装Oracle 11gR2 RAC 的时候执行创建实例,DBCA老是找不到之前通过asmca工具创建好的ASM DiskGroup。
查了METALINK:
ASM is Unable to Detect ASMLIB Disks/Devices. [ID 457369.1] 

 修改时间 03-DEC-2009     类型 HOWTO     状态 PUBLISHED 

In this Document
  Goal
  Solution


Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.6
Linux x86
Linux x86-64

Goal

This documented can be used to detect ASMLIB devices/disks thru the ASM instance.

Solution

1) First of all, please scan the disks (on all the nodes if RAC):

dbaasm.us.oracle.com:+ASM:oracle:11g>/etc/init.d/oracleasm scandisks 
Scanning system for ASM disks: OK ] 

2) Second, make sure the disks can be listed :

dbaasm.us.oracle.com:+ASM:oracle:11g>/etc/init.d/oracleasm listdisks 
VOL1_10G 
VOL2_10G 

3) Query each disks: 

dbaasm.us.oracle.com:+ASM:oracle:11g>/etc/init.d/oracleasm querydisk VOL1_10G 
Disk "VOL1_10G" is a valid ASM disk on device [3, 18] 
dbaasm.us.oracle.com:+ASM:oracle:11g>/etc/init.d/oracleasm querydisk VOL2_10G 
Disk "VOL2_10G" is a valid ASM disk on device [3, 22] 

4) Check if they exist at OS level: 

dbaasm.us.oracle.com:+ASM:oracle:11g>ls -l /dev/oracleasm/disks/VOL1_10G 
brw-rw---- 1 oracle dba 3, 18 Aug 13 09:54 /dev/oracleasm/disks/VOL1_10G 
dbaasm.us.oracle.com:+ASM:oracle:11g>ls -l /dev/oracleasm/disks/VOL2_10G 
brw-rw---- 1 oracle dba 3, 22 Aug 13 09:55 /dev/oracleasm/disks/VOL2_10G 

5) Then, in the initialization parameter file set the discovery disks string parameter as follow: 

asm_diskstring =ORCL:* 

Note: Also, you can set it thru the DBCA (during the diskgroup(s) creation) by pressing the [Change Disk Discovery Path] button. 

6) If the problem persists then you can set the discovery disks string as follow: 

asm_diskstring = /dev/oracleasm/disks/* 

7) As workaround you can setasm_diskstring = /dev/oracleasm/disks/*, this is possible for Oracle 10g Release 2 and onwards since it can access block devices. Oracle uses O_DIRECT flag, which can be used for opening block devices to bypass the OS cache. 

8) If the problem persists, please open a new service request with Oracle support and then please provide us the next information (from all the nodes if RAC) : 

Upload the next files:

======================================= 
=)> /var/log/messages

=)> New /etc/sysconfig/oracleasm 

=)> alert+ASM#.log for each instance. 
================================ 

And the output of the next commands

================================


$> cat /etc/*release 
$> uname -a 
$> rpm -qa |grep oracleasm 
$> df -ha 
$> ls -l /dev/oracleasm/disks 
$> powermt display dev=emcpower# (On all the partitions if using PowerPath from EMC)

================================ 
$> /etc/init.d/oracleasm status 
$> usr/sbin/oracleasm-discover 
$> /usr/sbin/oracleasm-discover 'ORCL:*' 

================================ 
SQL> show parameter asm 
======================================= 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23135684/viewspace-676080/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/23135684/viewspace-676080/

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值