Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

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
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
Madhu Sudhan_1
Respected Contributor

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

My aplogies. I over reacted.

Thank you,
Madhu
Think Positive
Michael Schulte zur Sur
Honored Contributor

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

Hi Violin,

could you solve the problem?

greetings,

Michael
R. Allan Hicks
Trusted Contributor

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

I'm not sure if I totally follow, but the short answer to the question is to use the V$DATAFILE view.

Assuming that the instance is idle

sqlplus

/as sysdba

startup nomount;

select name from V$datafile where file#=5;

Will give you the name of file# 5. My experience with ORA-600 are that they are _usually_ os specific problems such as a corrupt file (as others have already pointed out).

Looking at the specific complaint, I would guess that it's whatever datafile associated with RCV_TRANSACTIONS_INTERFACE's tablespace.

Hope you have a good backup
Allan
"Only he who attempts the absurd is capable of achieving the impossible
Michael Schulte zur Sur
Honored Contributor

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

Hi Allan,

his question was, how to convert the rowids found in his trace file to file#, block#, row#. He found an example but the file# 14 can not be converted to 5, whatever base you take. This confused him.

greetings,

Michael
Michael Schulte zur Sur
Honored Contributor

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

Hi Violin,

are you still with us?

greetings,

Michael
violin_1
Advisor

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

Sorry for late reply.

I've saw all the kindly replies,
And all of you help me so much.

Thank you all.
You're really kind.

Violin