ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-07445[dbgrmqmqpk_query_pick_key()]问题处理

ORA-07445[dbgrmqmqpk_query_pick_key()]问题处理

原创 Linux操作系统 作者:eric_zhyd 时间:2013-11-07 13:24:26 0 删除 编辑
故障描述:
- Alert日志报如下错误:
Wed Nov 06 00:14:33 2013
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x9155F46, dbgrmqmqpk_query_pick_key()+2014]
ERROR: Unable to normalize symbol name for the following short stack (at offset 199):
dbgexProcessError()+193<-dbgeExecuteForError()+65<-dbgePostErrorKGE()+1726<-dbkePostKGE_kgsf()+75<-kgeade()+560<-kgerev()+125<-kgerec5()+60<-sss_xcpt_EvalFilterEx()+1869<-sss_xcpt_EvalFilter()+174<-.1.4_5+59<-0000000076EE85C8<-0000000076EF9D2D<-0000000076EE91CF<-0000000076F21248<-dbgrmqmqpk_query_pick_key()+2014<-dbgrmqmfs_fetch_setup()+253<-dbgrmqmf_fetch_real()+372<-dbgrmqmf_fetch()+275<-dbgrip_fetch_record()+40<-dbgrip_relation_iterator()+477<-dbgripricm_rltniter_wcbf_mt()+757<-dbgripdrm_dmldrv_mt()+432<-dbghmm_delete_info_records()+100<-dbghmo_purge_hm_schema()+2099<-dbgrupipscb_hm_pgsvc_cbf()+66<-dbgruppm_purge_main()+1113<-dbkrapg_auto_purge()+187<-kewraps_auto_purge_slave()+1039<-kebm_slave_main()+856<-ksvrdp()+2506<-opirip()+965<-opidrv()+909<-sou2o()+98<-opimai_real()+299<-opimai()+191<-BackgroundThreadStart()+693<-0000000076DC652D<-0000000076EFC541
Errors in file c:\app\administrator\diag\rdbms\prones1\prones1\trace\prones1_m000_6420.trc  (incident=552282):
ORA-07445: 出现异常错误: 核心转储 [dbgrmqmqpk_query_pick_key()+2014] [ACCESS_VIOLATION] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x9155F46] [UNABLE_TO_READ] []
Incident details in: c:\app\administrator\diag\rdbms\prones1\prones1\incident\incdir_552282\prones1_m000_6420_i552282.trc

- Trace日志报如下错误:
Dump file c:\app\administrator\diag\rdbms\prones1\prones1\incident\incdir_552282\prones1_m000_6420_i552282.trc
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
Windows NT Version V6.1 Service Pack 1 
CPU                 : 2 - type 8664, 2 Physical Cores
Process Affinity    : 0x0x0000000000000000
Memory (Avail/Total): Ph:6678M/16383M, Ph+PgF:22920M/32765M 
VM name             : VMWare Version (6)
Instance name: prones1
Redo thread mounted by this instance: 1
Oracle process number: 35
Windows thread id: 6420, image: ORACLE.EXE (M000)


*** 2013-11-06 00:14:33.874
*** SESSION ID:(880.1788) 2013-11-06 00:14:33.874
*** CLIENT ID:() 2013-11-06 00:14:33.874
*** SERVICE NAME:(SYS$BACKGROUND) 2013-11-06 00:14:33.874
*** MODULE NAME:(MMON_SLAVE) 2013-11-06 00:14:33.874
*** ACTION NAME:(Auto-Purge Slave Action) 2013-11-06 00:14:33.874
 
Dump continued from file: c:\app\administrator\diag\rdbms\prones1\prones1\trace\prones1_m000_6420.trc
ORA-07445: 出现异常错误: 核心转储 [dbgrmqmqpk_query_pick_key()+2014] [ACCESS_VIOLATION] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x9155F46] [UNABLE_TO_READ] []

========= Dump for incident 552282 (ORA 7445 [dbgrmqmqpk_query_pick_key()+2014]) ========
----- Beginning of Customized Incident Dump(s) -----
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x9155F46, dbgrmqmqpk_query_pick_key()+2014]

Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
Process Id: 0x000006c8  Thread Id : 0x00001914    Time : Wed Nov 06 00:14:33 
Excp. Code: 0xc0000005  Excp. Type: ACCESS_VIO    Flags: 0x00000000

MOS针对此问题的信息:

Cause

This is due to Bug 9390347 fixed in 12.1 & 11.2.0.2, where a core dump can occur in module dbgrmqmqpk_query_pick_key() whilst purging HM contents from ADR.

Solution

- Either install our 11.2.0.2 patchset

- Or download and apply Patch 9390347 if available for your version/platform.

- On Windows, you can also install Bundle Patch 11.1.0.7.31 or above.

There is no workaround to this error, however the error is not serious and does not cause any harm to your database.
现在还没有办法解决这个错误,但是错误并不严重,并不会造成任何伤害到你的数据库






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

请登录后发表评论 登录
全部评论

注册时间:2013-03-13

  • 博文量
    21
  • 访问量
    519184