Operating System - HP-UX
1748011 Members
3875 Online
108757 Solutions
New Discussion юеВ

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

 
SOLVED
Go to solution
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