Welcome 微信登录

首页 / 数据库 / MySQL / Oracle ASM错误之--ORA-15031、ORA-15014

Oracle ASM错误之--ORA-15031、ORA-15014系统环境:操作系统: AIX 5.3.8Oracle: Oracle 10gR2故障现象:[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
查看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*’后,问题解决!在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htmOracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htmDebian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htmOracle 11g从入门到精通 PDF+光盘源代码 http://www.linuxidc.com/Linux/2013-06/85670.htmRHEL6 ASM方式安装Oracle 11g R2 http://www.linuxidc.com/Linux/2013-06/86002.htmOracle 10g 手工创建ASM数据库 http://www.linuxidc.com/Linux/2013-01/78229.htmOracle 10g R2创建ASM实例Step By Step http://www.linuxidc.com/Linux/2014-05/101821.htm更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12本文永久更新链接地址