Oracle ASM错误之--ORA-15031、ORA-15014
来源:互联网 发布:丹尼格兰杰数据 编辑:程序博客网 时间:2024/06/04 19:45
Oracle ASM错误之--ORA-15031、ORA-15014
系统环境:
操作系统: AIX 5.3.8
Oracle: 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*’后,问题解决!
本文出自 “天涯客的blog” 博客,请务必保留此出处http://tiany.blog.51cto.com/513694/1529579
0 0
- Oracle ASM错误之--ORA-15031、ORA-15014
- Oracle ASM错误之--ORA-15033
- Oracle 10g手工建立ASM磁盘组错误之--ORA-15201
- Oracle 10g手工建立ASM磁盘组错误之--ORA-15106
- Oracle 10g手工建立ASM磁盘组错误之--ORA-15201
- dbca asm ora 01017错误
- 常见Oracle错误之ORA-01102错误
- Oracle错误:ORA-01033
- oracle ora - 日期错误
- oracle ORA-03113 错误
- Oracle ORA-22922 错误
- Oracle: ORA-错误
- oracle ORA 1555错误
- [Oracle] ORA-01502 错误
- oracle ora-1555错误
- Oracle ORA-22922错误
- Oracle ORA错误
- Oracle 错误 ”ORA-02292“
- AIX系统小错误之--Crontab故障
- Solaris 10下有趣的FTP错误--ROOT不能访问FTP
- 爬山为什么要穿登山鞋
- Unix系统性能监控工具之--SAR
- Oracle 学习之--Buffer Cache深入解析
- Oracle ASM错误之--ORA-15031、ORA-15014
- Oracle ASM错误之--ORA-15033
- Oracle Study之--Oracle等待事件(1)
- Oracle非归档模式Media Recovery错误之--ORA-26040
- Oracle Study之--Oracle等待事件(2)
- Oracle Study之--Oracle等待事件(3)
- Oracle Study之--Oracle等待事件(4)
- Oracle Study之--Oracle等待事件(5)
- AIX HACMP系统错误--NODE同步配置错误