Shulou(Shulou.com)06/01 Report--

Oracle ASM errors-- ORA-15031, ORA-15014

System environment:

Operating system: AIX 5.3.8

Oracle: Oracle 10gR2

Failure phenomenon:

[oracle@aix213] $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:ORA-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 the ASM Instance pfile file:

[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'

Cause of error:

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

Change to:

After asm_diskstring='/dev/r*', problem solved!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.