共计 3268 个字符,预计需要花费 9 分钟才能阅读完成。
这篇文章主要介绍 oracle 中出现 ORA-15201 错误怎么办,文中介绍的非常详细,具有一定的参考价值,感兴趣的小伙伴们一定要看完!
系统环境:
操作系统: AIX5300-08
Oracle 软件: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 Mb CANDIDATE /dev/rlv_asm2
3: 4096 Mb CANDIDATE /dev/rlv_asm3
4: 4096 Mb CANDIDATE /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 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 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 created
ORA-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=2560
2560+0 records in
2560+0 records out
[oracle@aix211 ~]$kfod status=TRUE asm_diskstring= /dev/rlv* disk=all
——————————————————————————–
Disk Size Header Path
================================================================================
1: 4096 Mb CANDIDATE /dev/rlv_asm1 // 此时,rlv_asm1 和其他 lv 保持一致
2: 4096 Mb CANDIDATE /dev/rlv_asm2
3: 4096 Mb CANDIDATE /dev/rlv_asm3
4: 4096 Mb CANDIDATE /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 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 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 /dev/rlv_asm4
Diskgroup created.
查看磁盘组信息
SQL select name,state from v$asm_diskgroup;
NAME STATE
—————————— ———–
DG1 MOUNTED
RCY1 MOUNTED
@至此,问题解决,应该是在 LV 的字符设备的头部出现了 ASM 无法处理的信息,清除头部信息后,问题解决。
以上是“oracle 中出现 ORA-15201 错误怎么办”这篇文章的所有内容,感谢各位的阅读!希望分享的内容对大家有帮助,更多相关知识,欢迎关注丸趣 TV 行业资讯频道!