ORA-00600: internal error code, arguments: [25027], [3], [0], [], [], [], [], []
- From: "Fuad Habash" <fmhabash@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 8 May 2008 14:17:10 -0400
Just wondering if any of the DBA have seen this issue before.
Oracle returning
ORA-00600: internal error code, arguments: [25027], [3], [0], [], [], [],
[], []
We narrowed it down to an insert statement in a message_store table which
looks like this
SQL> desc tracker02.message_store
Name Null? Type
----------------------------------------- --------
----------------------------
MESSAGE_ID NOT NULL VARCHAR2(100)
SENDER_MESSAGE_SIZE NUMBER
SENDER_SMALL_DOCUMENT VARCHAR2(4000)
SENDER_DOCUMENT_DATA BLOB
RECEIVER_MESSAGE_SIZE NUMBER
RECEIVER_SMALL_DOCUMENT VARCHAR2(4000)
RECEIVER_DOCUMENT_DATA BLOB
SENDER_DOCUMENT_DATA_ON_WIRE BLOB
RECEIVER_DOCUMENT_DATA_ON_WIRE BLOB
COMMON_MESSAGE_SIZE NUMBER
COMMON_DOCUMENT_DATA BLOB
COMMON_SMALL_DOCUMENT VARCHAR2(4000)
To be more specific, the error returns when inserting into a blob column.
These are the facts
----------------------------------
1) Oracle suggested "This looks like Bug 4899479 which causes memory
corruptions due to the use of in-memory_undo which is a default in 10.2.0.3".
- Per their suggestion, we disabled it and applied the one-off patch. It did
not work.
2) we bounced the instance afterwards, still did not work. Any insert into
this table will abort with above error.
3) The persistence of this error after the reboot and the patch, made us
suspect logical/physical corruption.
- dbv: returned no errors
- RMAN validate: no errors
- validate structure: returned ORA-01499: table/index cross reference
failure - see trace file
- the trace file returned row mismatch in index tsn: 5 rdba: 0x11c0098d
when we followed the rdba hint, we isolated it to a the PK index on the
table. When we rebuilt it, it errored out with duplicate value error.
Eventually, we did a disable/enable on the PK and dumped dups into
exceptions table. This process returned to rows with same message_id PK!!!
Once we deleted one of the rows, the index rebuilt successfully. However,
the 600 error persisted.
- As a last resort, we truncated the table which resolved the issue.
any comments or suggestions are welcome.
Thank you
Other related posts:
- » ORA-00600: internal error code, arguments: [25027], [3], [0], [], [], [], [], []
