Oracle数据库经常报错:ORA-00600: 内部错误代码,参数: [17113], [0x0000000…
Oracle数据库经常会出现报错:ORA-00600: internal error code, arguments: [17113], [0x000000000], [], [], [], [], [], []
关于ORA-00600[17113]这个报错,可以检查报错对应的trace文件,发现日志如下:
SO: c0000008d5119f58, type: 8, owner: c0000008a4298fd0, flag: INIT/-/-/0x00
(FOB) flags=2 fib ptr=c529dd48 incno=0 pending i/o cnt=0
----------------------------------------
SO: c0000008a226dcd0, type: 4, owner: c0000008a4298fd0, flag: INIT/-/-/0x00
(session) trans: 0000000000000000, creator: c0000008a4298fd0, flag: (41) USR/- BSY/-/-/-/-/-
DID: 0001-00B8-00000866, short-term DID: 0000-0000-00000000
txn branch: 0000000000000000
oct: 47, prv: 0, sql: c000000085c17098, psql: c0000008ccadd740, user: 45/CX
O/S info: user: test, term: USERABC, ospid: 3388:3628, machine: WORKGROUP\USERABC
program: plsqldev.exe
application name: PL/SQL Developer, hash value=1290136663
action name: Main session, hash value=1273317990
last wait for 'latch free' blocking sess=0x0 seq=34 wait_time=258
address=c00000008d0b7670, number=9c, tries=0
这个一般都是由于客户端使用了旧版本的PL/SQL工具对数据库进行操作导致的,解决的办法就是使用新版本的PLSQL工具。
关于ORA-00600[17113]这个报错,oracle metalink的原文解释如下:
[size=15.5pt]Applies to:
[size=12.5pt]Oracle Database - Enterprise Edition - Version 9.2.0.6 and later
[size=12.5pt]Information in this document applies to any platform.
[size=12.5pt]***Checked for relevance on 18-Jul-2013***
[size=15.5pt]Symptoms
Getting the following ora-600 error repeatedly in the alertlog.
ORA-00600: internal error code, arguments: [17113], [0x000000000], [], [], [], [], [], []
[size=15.5pt]Cause
Using incompatible version of pl/sql developer causes memory corruption by not properly
initializing heap descriptor.
From the trace file the ora-600 error is caused due to pl/sql developer.
Using older or incompatible version of the pl/sql developer can cause ORA-600 [17113] error.
[size=15.5pt]Solution
Install latest version of pl/sql developer.