Oracle ASM errors-ORA-15031, ORA-15014

Oracle ASM errors-ORA-15031, ORA-15014

Oracle ASM errors-ORA-15031, ORA-15014

System Environment:

Operating System: AIX 5.3.8

Oracle: Oracle 10gR2

Fault symptom:

[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,200 5, Oracle. All rights reserved.

Connected:

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

View the pfile of the ASM Instance:

 

[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 = 12 M

*. Remote_login_passwordfile = 'shared'

*. User_dump_dest = '/u01/app/oracle/admin/+ ASM/udump'

Asm_diskstring = '/dev/rasm *'

Asm_diskgroups = 'datafile', 'redo ', 'arch'

Error cause:

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

Change:

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

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

Oracle 11g from entry to proficient in PDF + CD source code

Installing Oracle 11g R2 using RHEL6 ASM

Oracle 10g manual creation of the ASM Database

Oracle 10g R2 create ASM instance Step By Step