topic Re: What is the file#? Need help,Thanks. in Operating System - HP-UX

What is the file#? Need help,Thanks.

violin_1 — Sat, 15 Nov 2003 02:34:09 GMT

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.

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

Thierry Poels_1 — Sat, 15 Nov 2003 06:40:49 GMT

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.

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

Madhu Sudhan_1 — Sat, 15 Nov 2003 06:45:21 GMT

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.

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

Michael Schulte zur Sur — Sat, 15 Nov 2003 07:04:18 GMT

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

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

Michael Schulte zur Sur — Sat, 15 Nov 2003 07:08:32 GMT

Hi,

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

greetings,

Michael

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

Madhu Sudhan_1 — Sat, 15 Nov 2003 07:47:27 GMT

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

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

Jeff Schussele — Sat, 15 Nov 2003 07:56:08 GMT

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

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

Madhu Sudhan_1 — Sat, 15 Nov 2003 07:57:59 GMT

Thanks Jeff for clarifying.

-Madhu

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

Jeff Schussele — Sat, 15 Nov 2003 09:45:58 GMT

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

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

Michael Schulte zur Sur — Sat, 15 Nov 2003 10:59:34 GMT

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

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

Madhu Sudhan_1 — Sat, 15 Nov 2003 11:05:24 GMT

My aplogies. I over reacted.

Thank you,
Madhu

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

Michael Schulte zur Sur — Mon, 17 Nov 2003 11:32:32 GMT

Hi Violin,

could you solve the problem?

greetings,

Michael

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

R. Allan Hicks — Mon, 17 Nov 2003 16:33:47 GMT

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

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

Michael Schulte zur Sur — Tue, 18 Nov 2003 05:43:53 GMT

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

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

Michael Schulte zur Sur — Tue, 18 Nov 2003 12:21:48 GMT

Hi Violin,

are you still with us?

greetings,

Michael

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

violin_1 — Wed, 19 Nov 2003 05:04:26 GMT

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