|
|
|
ORA-00600: internal error code
|
|||
|---|---|---|---|
|
#18+
Доброго времени суток, Господа. Встретился с такой проблемой: С неделю назад в alert log начала сыпаться такая ошибка: <msg time='2016-07-05T06:56:48.657+05:00' org_id='oracle' comp_id='rdbms' msg_id='3635264951' type='INCIDENT_ERROR' group='Generic Internal Error' level='1' host_id='L3SERV' host_addr='fe80::b9e7:dec5:a845:ec94%13' prob_key='ORA 600 [kdBlkCheckError]' upstream_comp='' downstream_comp='' ecid='' errid='17679' detail_path='c:\database\diag\rdbms\prokat\prokat\trace\prokat_ora_2260.trc'> <txt>Errors in file c:\database\diag\rdbms\prokat\prokat\trace\prokat_ora_2260.trc (incident=17679): ORA-00600: internal error code, arguments: [kdBlkCheckError], [4], [59777], [63066], [], [], [], [], [], [], [], [] </txt> </msg> Следом: <msg time='2016-07-05T06:56:48.657+05:00' org_id='oracle' comp_id='rdbms' msg_id='dbgexProcessError:1176:3370026720' type='TRACE' level='16' host_id='L3SERV' host_addr='fe80::b9e7:dec5:a845:ec94%13'> <txt>Incident details in: c:\database\diag\rdbms\prokat\prokat\incident\incdir_17679\prokat_ora_2260_i17679.trc </txt> </msg> Выливается это в периодические подвисания базы, коннект нормальный, запрос на выборку из таблиц проходит нормально, при попытке вставить/обновить строку транзакция наглухо зависает, помогает только грохнуть сессию. В prokat_ora_2260_i17679.trc: Dump continued from file: c:\database\diag\rdbms\prokat\prokat\trace\prokat_ora_2260.trc ORA-00600: internal error code, arguments: [kdBlkCheckError], [4], [59777], [63066], [], [], [], [], [], [], [], [] Dump: ========= Dump for incident 17673 (ORA 600 [kdBlkCheckError]) ======== dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0) ----- Current SQL Statement for this session (sql_id=6tbv3zzyhfzmp) ----- update TBLXML set ID = :ID, DESKRIPTION = :DESKRIPTION, FLAG = :FLAG where ID = :Original_ID ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- ksedst1()+129 CALL??? skdstdst() 008EC3DA2 000000000 000000000 000000000 ksedst()+69 CALL??? ksedst1() 000000002 000000000 006F605E0 000000000 dbkedDefDump()+4536 CALL??? ksedst() 000020D70 000000000 000000000 000000000 ksedmp()+43 CALL??? dbkedDefDump() 000000003 000000002 000000000 000468E71 ksfdmp()+87 CALL??? ksedmp() 000000000 000000000 000000000 000000000 dbgexPhaseII()+1819 CALL??? ksfdmp() 000000000 000000000 000000000 000000000 dbgexProcessError() CALL??? dbgexPhaseII() 01C440570 01C44D448 000004509 +2563 000000002 dbgeExecuteForError CALL??? dbgexProcessError() 01C440570 01C447540 000000001 ()+65 000000000 dbgePostErrorKGE()+ CALL??? dbgeExecuteForError 011DB0FE0 022D66D78 000000000 1726 () 000000000 dbkePostKGE_kgsf()+ CALL??? dbgePostErrorKGE() 011DB0FE0 022C60040 75 FFFFFFFF00000258 C2382EDFEF7B ... kdBlkCheckError()+5 CALL??? ksesin() C2382EEF5738 7FFC00000003 6 000000000 000000004 ... ========== FRAME [16] (kdBlkCheckError()+56 -> ksesin()) ========== defined by frame pointers 0x270d5ed0 and 0x270d5e80 CALL TYPE: CALL??? ERROR SIGNALED: yes COMPONENT: (null) Dump of memory from 0x00000000270D5E80 to 0x00000000270D5ED0 0270D5E80 69F00000 00000000 03935ACC 00000000 [...i.....Z......] 0270D5E90 2EEF5738 0000C238 00000003 00007FFC [8W..8...........] 0270D5EA0 00000000 00000000 00000004 00000000 [................] 0270D5EB0 00000000 00000000 0000E981 00000000 [................] 0270D5EC0 00000000 00000000 0000F65A 00000000 [........Z.......] ... В prokat_ora_2260.trc: Много-много-много раз rechecking block failed with error code 63066 Cleaning up copy latch 0 Copy latch cleanup completed Incident 17673 created, dump file: c:\database\diag\rdbms\prokat\prokat\incident\incdir_17673\prokat_ora_2260_i17673.trc ORA-00600: internal error code, arguments: [kdBlkCheckError], [4], [59777], [63066], [], [], [], [], [], [], [], [] Doing block recovery for file 3 block 924 Block header before block recovery: buffer tsn: 2 rdba: 0x00c0039c (3/924) scn: 0x0000.0185c8e0 seq: 0x03 flg: 0x04 tail: 0xc8e00203 frmt: 0x02 chkval: 0x3d97 type: 0x02=KTU UNDO BLOCK Resuming block recovery (PMON) for file 3 block 924 Block recovery from logseq 694, block 59516 to scn 25544952 В документации нашел ORA-00600 internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string] Cause: This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. Causes of this message include: timeouts file corruption failed data checks in memory hardware, memory, or I/O errors incorrectly restored files The first argument is the internal message number. Other arguments are various numbers, names, and character strings. The numbers may change meanings between different versions of Oracle. Action: Report this error to Oracle Support Services after gathering the following information: events that led up to the error the operations that were attempted that led to the error the conditions of the operating system and databases at the time of the error any unusual circumstances that occurred before receiving the ORA-00600 message contents of any trace files generated by the error the relevant portions of the Alter files Note: The cause of this message may manifest itself as different errors at different times. Be aware of the history of errors that occurred before this internal error. Отсюда http://alldba.ru/index.php/subd/oracle-database/oshibki/ora-600/kateg-oshibok-po-mnemonike следует, что kdbl kdc kdd ram/data Поддержка для операций прямой загрузки управление пространством кластера и удаление строк. Но более подробного описания, и методов лечения не нашел. Кто-нибудь сможет подсказать как это вылечить? Система OS: Windows Server 2012 R2 Stnd X64 CPU: 6 Physical Cores Memory (Avail/Total): Ph:13066M/16287M Oracle: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 05.07.2016, 07:23:20 |
|
||
|
ORA-00600: internal error code
|
|||
|---|---|---|---|
|
#18+
mozgen, Бєкап БД присутствует? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 05.07.2016, 07:38:16 |
|
||
|
ORA-00600: internal error code
|
|||
|---|---|---|---|
|
#18+
trace.2log, Да, конечно, но очень не хотелось бы, поскольку база постоянно в работе, и останавливать было-бы очень не желательно. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 05.07.2016, 07:48:51 |
|
||
|
ORA-00600: internal error code
|
|||
|---|---|---|---|
|
#18+
BUGFIXEDDESC1744707812.1.0.2 12.2.0.0Diagnostic enhancement for ORA-600 [kdBlkCheckError] .. [18007] errors1440011011.2.0.4 12.1.0.2 12.2.0.0Bad redo / ORA-600 [kdBlkCheckError] .. [6135] for opcode 19.1 redo1234931611.2.0.4 12.1.0.2 12.2.0.0DBMS_SPACE_ADMIN.TABLESPACE_FIX_BITMAPS fails with ORA-600 [kddummy_blkchk] / ORA-600 [kdBlkCheckError] / ORA-6071861991711.2.0.4.6 11.2.0.4.BP09 12.1.0.2Block corruption / ORA-600 [kdBlkCheckError]..[6110] on insert to OLTP compressed table1467496312.1.0.1ORA-600 [kdBlkCheckError][1] / corruption possible from OLTP compression1435156611.2.0.3.8 11.2.0.3.BP21 11.2.0.4 12.1.0.1ORA-600 [kclchkblk_4] ORA-600 [2662] when doing flash back2129071412.2.0.0ORA-600 [kdBlkCheckError] [6401] after migrating database from Windows to LINUX2036885012.2.0.0ORA-600 [kdxlin: sno out of range] ORA-600 [kdBlkCheckError] [6401] ORA-600 [6101]. Corrupt INDEX block during Consistent Read1835616611.2.0.4.5 11.2.0.4.BP14 12.1.0.2 12.2.0.0ORA-600:[kdblkcheckerror][x][x][18020] possible in ASSM1826820112.1.0.2 12.2.0.0ORA-600 [3020] ORA-10567 and ORA-10560: block type '0' / ORA-600 [kdBlkCheckError] ORA-600 [ktfbbset-2] after flashback which reversed a datafile extend - superseded1634790411.2.0.3.9 11.2.0.3.BP22 11.2.0.4 12.1.0.1.2 12.1.0.2 12.2.0.0Corrupt block with check code 6101 6110 or 6255 on compressed table with DML workload1888929511.2.0.4.BP12 12.1.0.2ORA-600 [4511] kdbchk: row locked by non-existent transaction on OLTP compressed table1692862312.1.0.2Corruption with various errors like ORA-600 [6856] ORA-7445 [kdr9ir2rst0] or lost changes for COMPRESS table during ROLLBACK - superseded19762646ORA-600 [kdBlkCheckError] / corruption during recovery for OLTP compressed block1455184411.2.0.4 12.1.0.1ORA-600 [kdblkcheckerror] [6126] / ORA-600 [17182] for DELETE / INSERT (QMD / QMI) in COMPRESS BASIC table due to negative avsp1380429411.2.0.3.4 11.2.0.3.BP07 11.2.0.4 12.1.0.1Internal errors corruptions using pipelined function whose rows raise exceptions1371593211.2.0.4 12.1.0.1CREATE TABLE fails with ORA-600 [kddummy_blkchk] with large datafile1360583911.2.0.3.8 11.2.0.3.BP21 11.2.0.4 12.1.0.1ORA-600 [ktbsdp1] ORA-600 [kghfrempty:ds]. Corruption in Rollback with Clusterwide Global Transactions in RAC1241736911.2.0.2.5 11.2.0.2.BP13 11.2.0.2.GIPSU05 11.2.0.3 12.1.0.1Block corruption from rollback on compressed table1020523011.2.0.1.6 11.2.0.1.BP09 11.2.0.2.2 11.2.0.2.BP04 11.2.0.3 12.1.0.1ORA-600 / corruption possible during shutdown in RAC1018012111.2.0.3 12.1.0.1ORA-600 [kdBlkCheckError] .. [6251] / block corruption during parallel DML972497011.2.0.1.BP08 11.2.0.2.2 11.2.0.2.BP02 11.2.0.3 12.1.0.1Block Corruption with PDML UPDATE. ORA_600 [4511] OERI[kdblkcheckerror] by block check971185910.2.0.5.1 11.1.0.7.6 11.2.0.2 12.1.0.1ORA-600 [ktsptrn_fix-extmap] / ORA-600 [kdblkcheckerror] during extent allocation caused by bug 8198906954148511.2.0.4 12.1.0.1Create materialized view on views based on CON$ fails with ORA-600 [kdBlkCheckError]940660711.2.0.1.3 11.2.0.1.BP06 11.2.0.2 12.1.0.1Corrupt blocks in 11.2 in table with unique key. OERI[kdBlkCheckError] by block check929521711.2.0.2 12.1.0.1ORA-600 [ktsk_dba_to_hwm-1] / corruption during SHRINK of HWM901911311.2.0.1.BP02 11.2.0.2 12.1.0.1ORA-600 [17182] ORA-7445 [memcpy] ORA-600 [kdBlkCheckError] for OLTP COMPRESS table in OLTP Compression REDO during RECOVERY872080210.2.0.5 11.2.0.1.BP07 11.2.0.2 12.1.0.1Add check for row piece pointing to itself (db_block_checking dbv rman analyze)833106311.2.0.3 12.1.0.1Corrupt Undo. ORA-600 [2015] during rollback in undo block for COMPRESS table with SUPPLEMENTAL LOGGING652303711.2.0.1.BP07 11.2.0.2.2 11.2.0.2.BP01 11.2.0.3 12.1.0.1Corruption / ORA-600 [kddummy_blkchk] [6110] on update ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 05.07.2016, 09:38:25 |
|
||
|
ORA-00600: internal error code
|
|||
|---|---|---|---|
|
#18+
Обновиться не получилось, переустановил оракл по новой, версия: Код: plaintext Код: plaintext Код: plaintext собственно сама таблица переставляет из себя 3 поля ID NUMBER(10.0) (PK) DESKRIPTION (XMLTYPE) FLAG NUMBER(1.0) Изменения в эту таблицу вносит Код: plaintext Думал косяк в JOBах, менял логику, пробовал вообще отключить триггер - ноль реакции, стабильная ошибка. Есть еще идеи? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 17.07.2016, 11:11:17 |
|
||
|
ORA-00600: internal error code
|
|||
|---|---|---|---|
|
#18+
Хмм.. проблема решилась пересозданием таблицы. Жалко, что раньше не попробовал, хоть время бы сэкономил. Хотя, лично мне такое решение не по душе, хотелось бы разобраться в корне возникновения. И да, данные из дропнутой таблицы не восстанавливаются - Код: plaintext Хреново. =( ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 17.07.2016, 15:01:47 |
|
||
|
|
start [/forum/topic.php?fid=52&msg=39275225&tid=1887873]: |
0ms |
get settings: |
11ms |
get forum list: |
16ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
191ms |
get topic data: |
9ms |
get forum data: |
3ms |
get page messages: |
48ms |
get tp. blocked users: |
2ms |
| others: | 222ms |
| total: | 510ms |
| 0 / 0 |
