OCP Blog
Super DBA
ORA-600 [qertbfetchbyrowid]
by Vazha Mantua Saturday, October 15, 2011 10:43 PM

Good Evening All,

 

We have updated on of our database from 10.2.0.2 to 10.2.0.4, after upgrading in 2 days in alert log we got internal error ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], [], [], [], [], [], [] .

 

Cause of this error is index corruption

How can we resolve this problem?

Solution

1. Find appropriate trace file in udump for discover which SQL Statement is cause of problem.

2.In SQL statement find table which is cause of problem

3. with SQL plan of statement you can find appropriate index which is corrupted

4.Recreate index(not rebuild)!

 

After these 4 steps you problem will be resolved!

 

Good luck

Tags: ,

Comments (6) -

10/26/2011 5:56:20 PM #

Vakhtang Bobokhidze

We have solution, run this script : "alter BANK change DBA" Smile

Vakhtang Bobokhidze Georgia

10/28/2011 10:57:27 AM #

online casino

An man or women manufactured a quality tips there. Used to perform they're certified in the topic along with determined the majority will without doubt trust a person's site. Many thanks

online casino United States

12/8/2011 4:36:33 PM #

3g amplifier

A simple and easy solution. Thanks.

3g amplifier

1/7/2012 4:59:10 PM #

Orya Jan

How can we resolve this problem?

Orya Jan United States

1/12/2012 12:26:09 PM #

Boutique PR Agency

How can we resolve this problem?

Boutique PR Agency United States

2/23/2012 3:31:02 PM #

nordea online casino

Blog comments and also blog posting accomplished by you in your blog done proper way on net. Better thing is always that you write your topic proper way on net. Keep your issue as professional means on net.

nordea online casino United States

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Filter by APML

Calendar

<<  November 2017  >>
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
27282930123
45678910

View posts in large calendar

TextBox