Oracle ASM错误之--ORA-15031、ORA-15014

2014-11-24 17:16:31 · 作者: · 浏览: 0

系统环境:


操作系统: 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*’后,问题解决!