- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: What is the file#? Need help,Thanks.
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-14-2003 06:34 PM
тАО11-14-2003 06:34 PM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-14-2003 10:40 PM
тАО11-14-2003 10:40 PM
Solutionhow 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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-14-2003 10:45 PM
тАО11-14-2003 10:45 PM
Re: What is the file#? Need help,Thanks.
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-14-2003 11:04 PM
тАО11-14-2003 11:04 PM
Re: What is the file#? Need help,Thanks.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-14-2003 11:08 PM
тАО11-14-2003 11:08 PM
Re: What is the file#? Need help,Thanks.
if you have access to metalink, have a look at this.
Note:155933.1
greetings,
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-14-2003 11:47 PM
тАО11-14-2003 11:47 PM
Re: What is the file#? Need help,Thanks.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-14-2003 11:56 PM
тАО11-14-2003 11:56 PM
Re: What is the file#? Need help,Thanks.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-14-2003 11:57 PM
тАО11-14-2003 11:57 PM
Re: What is the file#? Need help,Thanks.
-Madhu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-15-2003 01:45 AM
тАО11-15-2003 01:45 AM
Re: What is the file#? Need help,Thanks.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-15-2003 02:59 AM
тАО11-15-2003 02:59 AM
Re: What is the file#? Need help,Thanks.
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