首页 > Linux操作系统 > Linux操作系统 > ORA-00600: internal error code, arguments: [qerpfAllocateR]

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

原创 Linux操作系统 作者:fengjin821 时间:2009-06-11 13:08:15 0 删除 编辑
ORA-00600: internal error code, arguments: [qerpfAllocateR]

RHEL4 U6 x86_64,db version :,Rac 环境
ORA-00600: internal error code, arguments: [qerpfAllocateR], [], [], [], [], [],
[], []
trace file:
Oracle Database 10g Enterprise Edition Release - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORACLE_HOME = /u01/app/oracle/oracle/product/10.2.0/db_1
System name:    Linux
Node name:
Release:        2.6.9-67.ELsmp
Version:        #1 SMP Wed Nov 7 13:56:44 EST 2007
Machine:        x86_64
Instance name: dbrac1
Redo thread mounted by this instance: 1
Oracle process number: 130
Unix process pid: 8148, image:
*** SERVICE NAMEodbrac) 2009-06-10 15:54:58.693
*** SESSION IDo442.19189) 2009-06-10 15:54:58.693
*** 2009-06-10 15:54:58.693
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [qerpfAllocateR], [], [], [], [], [],[], []
Current SQL statement for this session:
select * from (select pageinfo.*, rownum as pagerow1
from (select od.userid,od.trackid,trunc(od.orderdate) orderdate,trunc(od.checkdate)checkdate,
trunc(od.deaddate) deaddate,od.months
FROM ordermgt od,productinfo di
where od.TRACKID = di.TRACKID
and  od.status =2
and  od.checkflag=1  
and od.checkdate>=to_date('2009-06-09 17','yyyy-mm-dd hh24')
and od.checkdate < to_date('2009-6-10 14','yyyy-mm-dd hh24')
order by od.checkdate) pageinfo where rownum < 102) where pagerow1 >= 1
----- Call Stack Trace -----
calling              call     entry                argument values in hex



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

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


This is fixed in next release 11g & next  patchset  As of now ( Sep'07) patchset is not yet released and its exact date of release is not known.

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

1. Go to
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.

Please note that these one-off patches are not regression tested and hence you are advised to apply the same on a test server before applying it on a production box.

按照A办法:disable parallel query; 这样在RAC环境中产生什么样的影响?

按照B办法:升级到10.2.0.4,需要升级CRS,ORACLE ,DATABASE 总共停机时间太长,一时不好做啊
alter system set  "_px_rownum_pd"=false sid='*' scope=memory; 之后确实解决了问题。

_px_rownum_pd :turn off/on parallel rownum pushdown optimization



来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录


  • 博文量
  • 访问量