oracle中出现ORA-15201错误怎么办

这篇文章主要介绍oracle中出现ORA-15201错误怎么办，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！系统环境：操作系统： AIX5300-08Oracle 软件： Oracle 10gR2错误现象：通过AIX系统下的LV建立，ASM磁盘出现故障查看ASM磁盘信息[oracle@aix211 ~]$kfod——————————————————————————–ORACLE_SID ORACLE_HOME ================================================================================ +ASM /u01/app/oracle/product/10.2.0/db_1 [oracle@aix211 ~]$kfod status=TRUE asm_diskstring=’/dev/rlv*’ disk=all——————————————————————————–Disk Size Header Path ================================================================================1: 4096 Mb FOREIGN /dev/rlv_asm1 //这个裸设备信息和其他lv不一致 2: 4096 MbCANDIDATE/dev/rlv_asm2 3: 4096 MbCANDIDATE/dev/rlv_asm3 4: 4096 MbCANDIDATE/dev/rlv_asm4——————————————————————————–ORACLE_SID ORACLE_HOME ================================================================================ +ASM /u01/app/oracle/product/10.2.0/db_1 6、建立ASM磁盘组 [oracle@aix211 ~]$export ORACLE_SID=+ASM[oracle@aix211 ~]$sqlplus ‘/as sysdba’SQL*Plus: Release 10.2.0.1.0 – Production on Tue May 27 16:36:03 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 dg1 2 normal redundancy 3 failgroup fg1 disk ‘/dev/rlv_asm1’ 4 failgroup fg2 disk ‘/dev/rlv_asm2’;create diskgroup dg1*ERROR at line 1:ORA-15018: diskgroup cannot be createdORA-15201: disk /dev/rlv_asm1 contains a valid RDBMS file报错信息：rlv_asm1被数据库实例占用解决方法：清除ASM磁盘头部信息：[oracle@aix211 ~]$dd if=/dev/zero of=/dev/rlv_asm1 bs=8192 count=25602560+0 records in2560+0 records out[oracle@aix211 ~]$kfod status=TRUE asm_diskstring=’/dev/rlv*’ disk=all——————————————————————————–Disk Size Header Path ================================================================================ 1: 4096 MbCANDIDATE/dev/rlv_asm1 //此时，rlv_asm1和其他lv保持一致 2: 4096 MbCANDIDATE/dev/rlv_asm2 3: 4096 MbCANDIDATE/dev/rlv_asm3 4: 4096 MbCANDIDATE/dev/rlv_asm4——————————————————————————–ORACLE_SID ORACLE_HOME ================================================================================ +ASM /u01/app/oracle/product/10.2.0/db_1 再建立磁盘组： [oracle@aix211 ~]$sqlplus ‘/as sysdba’SQL*Plus: Release 10.2.0.1.0 – Production on Tue May 27 16:44:16 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 dg1 2 normal redundancy 3 failgroup fg1 disk ‘/dev/rlv_asm1’ 4 failgroup fg2 disk ‘/dev/rlv_asm2’;Diskgroup created.SQL> create diskgroup rcy1 2 normal redundancy 3 failgroup fg1 disk ‘/dev/rlv_asm3’ 4 failgroup fg2 disk ‘/de免费主机域名v/rlv_asm4′;Diskgroup created.查看磁盘组信息SQL> select name,state from v$asm_diskgroup;NAME STATE—————————— ———–DG1 MOUNTEDRCY1 免费主机域名 MOUNTED@至此，问题解决，应该是在LV的字符设备的头部出现了ASM无法处理的信息，清除头部信息后，问题解决。以上是“oracle中出现ORA-15201错误怎么办”这篇文章的所有内容，感谢各位的阅读！希望分享的内容对大家有帮助，更多相关知识，欢迎关注云技术行业资讯频道！

相关推荐: PostgreSQL的set_base_rel_sizes函数分析

这篇文章主要讲解了“PostgreSQL的set_base_rel_sizes函数分析”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“PostgreSQL的set_base_rel_size免费主机域名s函数分析…