Oracle ASM Error--ora-15031, ORA-15014

Oracle ASM Error--ora-15031, ORA-15014

System environment:

Operating system: AIX 5.3.8

Oracle:oracle 10GR2

Failure phenomena:

[[email protected] ~] $sqlplus  / as sysdbaSQL*Plus: Release 10.2.0.1.0  - production on thu jul 24 11:28:52 2014copyright  (c)  1982,  2005, oracle.  all rights reserved. connected to:oracle database 10g enterprise edition release 10.2.0.1.0  - 64bit productionwith the partitioning, olap and data mining  optionssql> 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:o ra-15018: diskgroup cannot be createdora-15031: disk specification  '/dev/ Rlv_data2 '  matches no disksORA-15014: location  '/dev/rlv_data2 '  is not in the discovery setORA-15031: disk  specification  '/dev/rlv_data1 '  matches no disksORA-15014: location  '/dev/rlv_ Data1 '  is not in the discovery set

View ASM Instance pfile Files:

[[email protected] 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 '

Cause of Error:

Asm_diskstring= '/dev/rasm* ', here with '/dev/rlv_data1 ', '/dev/rlv_data2 ' does not match

Change to:

Asm_diskstring= '/dev/r* ' after the problem solved!

This article is from the "Tianya blog," Please make sure to keep this source http://tiany.blog.51cto.com/513694/1529579