Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

What if there is an ORA-15201 error in oracle?

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.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report