In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-02-26 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)05/31 Report--
This article mainly introduces how to do ORA-15201 errors in oracle. It is very detailed and has certain reference value. Friends who are interested must finish reading it.
System environment:
Operating system: AIX5300-08
Oracle software: Oracle 10gR2
Error phenomenon:
Through the establishment of LV under the AIX system, the ASM disk failed
View ASM disk information
[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 / / this bare device information is inconsistent with other 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. Establish an ASM disk group
[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
Error message: rlv_asm1 is occupied by database instance
Solution:
Clear the ASM disk header information:
[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 / / at this point, rlv_asm1 is consistent with other 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
Then create a disk group:
[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.
View disk group information
SQL > select name,state from v$asm_diskgroup
NAME STATE
DG1 MOUNTED
RCY1 MOUNTED
@ so far, the problem should be solved when a message that cannot be processed by ASM appears in the header of the LV character device. After the header information is cleared, the problem is solved.
The above is all the contents of the article "what to do if there is an ORA-15201 error in oracle". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 245
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.