ORA-00600: internal error code, arguments: [qerpfAllocateR], [], [], [], [], [], [], []

最新推荐文章于 2025-05-10 15:16:29 发布

原创最新推荐文章于 2025-05-10 15:16:29 发布 · 547 阅读

0 ·

CC 4.0 BY-SA版权

ORACLE troubleshooting 专栏收录该内容

107 篇文章

订阅专栏

本文介绍了如何解决Oracle数据库中出现的ORA-600[qerpfAllocateR]错误，该错误与使用带有ROWNUM谓词的并行查询有关。提供了两个解决方法：一是禁用并行查询；二是通过设置会话参数来禁用ROWNUM下推。此问题已在11g和10.2.0.4版本中修复。

开发人员遇到如题错误，数据库版本是10.2.0.2，在metalink查找到相关bug，Bug 5742801 : ORA-600 [QERPFALLOCATER]

相关文章如下：

Query fails with ora-600 as reported in alert.log.

ORA-00600: internal error code, arguments: [qerpfAllocateR], [], [], [], [], [], [], []

The error stack functions are:

ksedst ksedmp ksfdmp kgerinv kgeasnmierr qerpfAllocate qknRwsAllocateTree qknRwsAllocateTree qknRwsAllocateTree qknRwsAllocateTree qknRwsAllocateTree qknRwsAllocateTree qknRwsAllocateTree qknRwsAllocateTree qknRwsAllocateTree qknRwsAllocateTree  qknRwsAllocateTree qknRwsAllocateTree qknDoRwsAllocate qkaTraverseQkn qkadrv2Post qkadrv2 opitca kksFullTypeCheck rpiswu2 kksSetBindType kksfbc opiexe opipls opiodr rpidrus skgmstack rpidru rpiswu2 rpidrv psddr0 psdnal pevm_EXECC pfrinstr_EXECC pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real main libc_start_main start 



.

CHANGES

None. 
CAUSE

Bug 5742801 ORA600 ERROR --> INTERNAL ERROR CODE, ARGUMENTS: [QERPFALLOCATER]

Duplicate of

Bug 4407269 Wrong result with nested loop parallel query with ROWNUM pushdown
Fixed In Ver: 11.1.0.6 & 10.2.0.4
Details: 
Wrong results can occur when using a parallel query which includes a ROWNUM predicate with nested loops and table lookup row sources. 
Workaround: 
Disable rownum pushdown. 
or 
Execute the query serially.
SOLUTION

A).

Workarounds: 
 
1.alter session disable parallel query; 
-- Run the failing query.-- 

2.alter session set "_px_rownum_pd"=false; 
-- Run the failing query.--

B).

This is fixed in 11g and 10.2.0.4 patchset.

However, for some of the database versions and platforms a one off patch is available. To check and download:

1. Go to My Oracle Support
2. On top left hand side under Quick Find from the drop down list choose "Patch Number" and
provide the patch number as 4407269 in the box below it. Click go.
3. In the following page, choose your database version - 10.x.x.x  and your platform - xxxxx  and download the patch.

Please follow the readme.txt for instruction on how to apply the patch.

没有相关补丁，给了workaround，禁掉并发即可。