Oracle ASM错误之--ORA-15031、ORA-15014
Oracle ASM错误之--ORA-15031、ORA-15014
系统环境:
操作系统: AIX 5.3.8
Oracle: Oracle 10gR2
故障现象:
[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'
错误原因:
asm_diskstring='/dev/rasm*',此处与'/dev/rlv_data1','/dev/rlv_data2'不匹配
更改成:
asm_diskstring='/dev/r*’后,问题解决!
免责声明:
① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的,并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据,供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。
② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341