Operating System - HP-UX
1748239 Members
3731 Online
108759 Solutions
New Discussion юеВ

Re: What is the file#? Need help,Thanks.

 
SOLVED
Go to solution
violin_1
Advisor

What is the file#? Need help,Thanks.

Hi,

Our ERP database occured on ORA-600:
ORA-00600: internal error code, arguments: [12700], [45351], [1321209169], [2], [], [], [], []
Current SQL statement for this session:
SELECT * FROM RCV_TRANSACTIONS_INTERFACE WHERE GROUP_ID = :b1 AND TRANSACTION_STATUS_CODE IN ( 'EXPRESS','CONFIRM' )ORDER BY INTERFACE_TRANSACTION_ID

In Metalink , I found a note about this issue, note id:1034886.6,

And some information logged in alert and trace files.

row#0[7785] flag: -----, lock: 0, data:(6): 21 80 12 7e 00 00
col 0; len 3; (3): c2 02 2d
col 1; len 2; (2): 55 53
row#1[7770] flag: -----, lock: 0, data:(6): 21 80 12 7e 00 01
col 0; len 3; (3): c2 02 2e
col 1; len 2; (2): 55 53
row#2[7755] flag: -----, lock: 0, data:(6): 21 80 12 7e 00 02
col 0; len 3; (3): c2 02 2f
col 1; len 2; (2): 55 53

and these rows:
row#0[7786] flag: -----, lock: 0, data:(6): 4e c0 0d 51 00 02
col 0; len 5; (5): c4 02 0f 1a 36
row#1[7772] flag: -----, lock: 0, data:(6): 4e c0 0d 71 00 01
col 0; len 5; (5): c4 02 16 3b 2f

In meta doc, it says how to recognize the file#, block# , row#:
row#0[1897] flag: --, lock: 2, data:(6): 14 00 00 26 00 00
^^^^^^^^^^^^^^^^^
These hex values represent the rowid of the corresponding row in the table.

14 00 00 26 00 00
^^ ^^^^^^^^ ^^^^^
File# Block# Row #

This row points to file 5, block 38, row# 0 on a SUN SOLARIS platform.
COL 0 represents the data for the column.
This is the DEPTNO column from the DEPT table for the user SCOTT.
ROWID conversion is different for each platform.
and compare for your intended platform.

BUT.... I still do not know what is the exact file# , block# , row# in my trace file.

Need helps &
Thanks very much!

Violin.




15 REPLIES 15
Thierry Poels_1
Honored Contributor
Solution

Re: What is the file#? Need help,Thanks.

Hi,

how about metalink note 155933.1 "Resolving an ORA-600 [12700] error".

If this is critical just log a call at Oracle. This might be the safiest/best solution.

good luck,
Thierry.
All unix flavours are exactly the same . . . . . . . . . . for end users anyway.
Madhu Sudhan_1
Respected Contributor

Re: What is the file#? Need help,Thanks.

File# is unique number with which Oracle recognizes a data file.

ORA-600 [12700] is either index or data corruption. The impact is high. I last week fixed the issue in one of our production instance. Luckily it was with index.

Looks like it is your test instance. :)

This is the DEPTNO column from the DEPT table for the user SCOTT.
ROWID conversion is different for each platform.
and compare for your intended platform.
Think Positive
Michael Schulte zur Sur
Honored Contributor

Re: What is the file#? Need help,Thanks.

Hi,

I think I know, where you are coming from. I found the text you are referring to. It is a problem with a mismatch between keys in an index and value stored in the table. So dont get confused. As you pointed out, the first byte is file# in hex, the next three bytes are block# and the last two row#. Convert each value in your tracefile from hex to dec and you have, what you are looking for.

I hope, I could help

Michael
Michael Schulte zur Sur
Honored Contributor

Re: What is the file#? Need help,Thanks.

Hi,

if you have access to metalink, have a look at this.
Note:155933.1

greetings,

Michael
Madhu Sudhan_1
Respected Contributor

Re: What is the file#? Need help,Thanks.

Micahel,
Since the right note was already mentioned, I just added my 2 cents there.

I honestly didn't like your statment "I think I know, where you are coming from". It doesn't really matter where Iam from.

Don't get personal out here.

Thanks,
Madhu
Think Positive
Jeff Schussele
Honored Contributor

Re: What is the file#? Need help,Thanks.

Hi Madhu,

I think you misunderstood Michael.
That phrase is an English slang term meaning "I understand what you said." It has no *personal* meaning in that context.

Best Rgds,
Jeff
PERSEVERANCE -- Remember, whatever does not kill you only makes you stronger!
Madhu Sudhan_1
Respected Contributor

Re: What is the file#? Need help,Thanks.

Thanks Jeff for clarifying.

-Madhu
Think Positive
Jeff Schussele
Honored Contributor

Re: What is the file#? Need help,Thanks.

Hi (again) Madhu,

You're welcome my friend.

I'm sure this is one of the most frustrating things for those of you that speak English as a second language.
But I certainly respect the fact that you folks do learn our language.

Again, I appreciate your thanks & I'm glad I could help in this fashion because I'm a very good SA, but I'm DB illiterate. I do follow this forum to try to learn. But we have a dedicated DBA team so I don't get any time to apply learned skills

Have a great weekend,
Jeff
PERSEVERANCE -- Remember, whatever does not kill you only makes you stronger!
Michael Schulte zur Sur
Honored Contributor

Re: What is the file#? Need help,Thanks.

Hi Jeff,

thanks for clarifying it for me. :-)

Hi Madhu,

my mistake, I was not refering to you, I was adressing Violin. And it doesnt matter where you live. Just participate, learn and give good advice. ;-)

greetings,

Michael