Oracle数据库经常报错:ORA-00600: 内部错误代码,参数: [17113], [0x0000000…

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:129

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.

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】