使用 PL/SQL Developer 引发 ORA-600 [17113]
今天翔哥在 QQ 上发过来一张图，一看是在 PL/SQL Developer 上创建序列时发生 ORA-600 [17113] 错误。这种内部错误，大多比较头痛，Google 了一下，找了下面一段文字：
PURPOSE:
This article discusses the internal error "ORA-600 [17113]", what
it means and possible actions. The information here is only applicable
to the versions listed and is provided only for guidance.
ERROR:
ORA-600 [17113] [a]
VERSIONS:
versions 7.0 to 10.1
DESCRIPTION:
An error occurred when getting a new extent while adding to a heap.
The heap descriptor is uninitialized.
ARGUMENTS:
Arg [a] Always 0
FUNCTIONALITY:
HEAP MANAGER
IMPACT:
PROCESS FAILURE
MEMORY CORRUPTION
NON DATA CORRUPTIVE - No underlying data corruption.
SUGGESTIONS:
These errors can occur after the actual Oracle in-memory corruption
has taken place.
Hence the processes that report the error may not be the ones that
caused it.
Check for third party software being used to access the database.
This error can be reported when there are compatibility issues
between third party software and the database.
Check for other messages preceeding this message.
Check if the problem is reproducable.
Run memory diagnostics on all system hardware.
If the Known Issues section below does not help in terms of identifying
a solution, please submit the trace files and alert.log to Oracle
Support Services for further analysis.
Known Issues:
Bug# 3488371 See Note 3488371.8
OERI[17113] can occur during import of materialized views
Fixed: 10.1.0.4, 10.2
Bug# 3066549 See Note 3066549.8
OERI[17113] / memory corruption can occur selecting from a view
Fixed: 9.2.0.5, 10.1.0.2
Bug# 2298968 + See Note 2298968.8
Client side memory leak for 32<->;64 bit SELECTs
Fixed: 9.0.1.4, 9.2.0.1
Bug# 2248904 See Note 2248904.8
Memory corrupt possible during optimization of distributed query
Fixed: 8.1.7.4, 9.0.1.4, 9.2.0.1
Bug# 1964934 See Note 1964934.8
Memory corruption possible using INSERT /*+ APPEND */ over DBLINK
Fixed: 8.1.7.4, 9.0.1.3, 9.2.0.1
Bug# 1460657 See Note 1460657.8
OERI:17113 creating partitioned OBJECT MVIEW with LOB column
Fixed: 9.0.1.0
上文说到，该问题是第三方软件和 Oracle 之间的兼容性所引起的，再看了下 google 出来的结果大多和 PL/SQL Developer 有关。
解决方法：
1. 将 PL/SQL Developer 升级到新版本，一般发生该问题的都是 5.X，升级到新版本，该问题就解决了。
2. 将编译时错误提示关闭：Tools->Preferences->Debugger 将 Add debug information when compiling 前的钩去掉。
参考：
http://www.cnoug.org/viewthread.php?tid=8319
http://bbs.chinaunix.net/viewthread.php?tid=570429
http://keweixing.itpub.net/post/7901/48707
Posted by Sky at 03:57 PM | Permalink | comments(0) | Edit | Database