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

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

由于一个并行的分页查询引发的
我的平台为：
RHEL4 U6 x86_64,db version :10.2.0.1,Rac 环境
ORA-00600: internal error code, arguments: [qerpfAllocateR], [], [], [], [], [],
[], []
trace file:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 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:      rac01.domain.com
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: oracledbrac1@rac01.domain.com
*** 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

 

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 next release 11g & next  patchset 10.2.0.4.  As of now ( Sep'07) 10.2.0.4 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 metalink.oracle.com
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
1.这个参数和上面的分页查询之间有什么关系？

2.这个参数是永久设置为false呢？还是每次都设置在memory范围？

3.这个问题在metalink上是怎样解释的，朋友你能否帮忙贴出来，如果方便的话能够聊下,我的msn： roland_wg@hotmail.com

 

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13165828/viewspace-605882/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13165828/viewspace-605882/