Oracle ASM错误之--ORA-15031、ORA-15014
系统环境：
操作系统： AIX 5.3.8
Oracle： Oracle 10gR2
故障现象：
[oracle@aix213 ~]$sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jul 24 11:28:52 2014 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options SQL> create diskgroup datafile 2 normal redundancy 3 failgroup fg1 disk ‘/dev/rlv_data1‘ 4 failgroup fg2 disk ‘/dev/rlv_data2‘; create diskgroup datafile * ERROR at line 1: ORA-15018: diskgroup cannot be created ORA-15031: disk specification ‘/dev/rlv_data2‘ matches no disks ORA-15014: location ‘/dev/rlv_data2‘ is not in the discovery set ORA-15031: disk specification ‘/dev/rlv_data1‘ matches no disks ORA-15014: location ‘/dev/rlv_data1‘ is not in the discovery set
查看ASM Instance pfile文件：
[oracle@aix213 dbs]$cat init+ASM.ora
*.background_dump_dest=‘/u01/app/oracle/admin/+ASM/bdump‘
*.core_dump_dest=‘/u01/app/oracle/admin/+ASM/cdump‘
*.instance_type=‘asm‘
*.large_pool_size=12M
*.remote_login_passwordfile=‘SHARED‘
*.user_dump_dest=‘/u01/app/oracle/admin/+ASM/udump‘
asm_diskstring=‘/dev/rasm*‘
asm_diskgroups=‘DATAFILE‘,‘REDO‘,‘ARCH‘
错误原因：
asm_diskstring=‘/dev/rasm*‘，此处与‘/dev/rlv_data1‘,‘/dev/rlv_data2‘不匹配
更改成：
asm_diskstring=‘/dev/r*’后，问题解决！
本文出自 “天涯客的blog” 博客，请务必保留此出处http://tiany.blog.51cto.com/513694/1529579