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

故障描述：
- 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 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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12974804/viewspace-775978/