OracleASM錯(cuò)誤之--ORA-15031、ORA-15014

Oracle ASM錯(cuò)誤之--ORA-15031、ORA-15014

Oracle ASM錯(cuò)誤之--ORA-15031、ORA-15014

系統(tǒng)環(huán)境：

操作系統(tǒng)： AIX 5.3.8

Oracle： Oracle 10gR2

故障現(xiàn)象：

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

錯(cuò)誤原因：

asm_diskstring='/dev/rasm*'，此處與'/dev/rlv_data1','/dev/rlv_data2'不匹配

更改成：

asm_diskstring='/dev/r*’后，問(wèn)題解決！

在CentOS 6.4下安裝Oracle 11gR2(x64)

Oracle 11gR2 在VMWare虛擬機(jī)中安裝步驟

Debian 下 安裝 Oracle 11g XE R2

Oracle 11g從入門(mén)到精通 PDF+光盤(pán)源代碼

RHEL6 ASM方式安裝Oracle 11g R2

Oracle 10g 手工創(chuàng)建ASM數(shù)據(jù)庫(kù)

Oracle 10g R2創(chuàng)建ASM實(shí)例Step By Step

本文永久更新鏈接地址：

聲明：本網(wǎng)頁(yè)內(nèi)容旨在傳播知識(shí)，若有侵權(quán)等問(wèn)題請(qǐng)及時(shí)與本網(wǎng)聯(lián)系，我們將在第一時(shí)間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com