ORA-600 [qerimrop2] Using Parallel Execution on RAC (Doc ID 1914119.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Alert log of a RAC instance reports errors like:

Errors in file /tpsys/app/oracle/db/diag/rdbms/tplhm/tplhm2/trace/tplhm2_p001_28049442.trc  (incident=81928):
ORA-00600: internal error code, arguments: [qerimrop2], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /tpsys/app/oracle/db/diag/rdbms/tplhm/tplhm2/incident/incdir_81928/tplhm2_p001_28049442_i81928.trc


The accompanying trace file shows a current sql and call stack like below:

*** 2014-07-22 08:45:26.982
*** SESSION ID:(491.1765) 2014-07-22 08:45:26.982
*** CLIENT ID:() 2014-07-22 08:45:26.982
*** SERVICE NAME:(tplhm) 2014-07-22 08:45:26.982
*** MODULE NAME:(PL/SQL Developer) 2014-07-22 08:45:26.982
*** ACTION NAME:(Command Window - New) 2014-07-22 08:45:26.982

Dump continued from file: /tpsys/app/oracle/db/diag/rdbms/tplhm/tplhm2/trace/tplhm2_p001_28049442.trc
ORA-00600: internal error code, arguments: [qerimrop2], [], [], [], [], [], [], [], [], [], [], []

========= Dump for incident 81928 (ORA 600 [qerimrop2]) ========

*** 2014-07-22 08:45:26.998
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=6b6h6845a12du) -----
DELETE /*+ parallel(4) */ FROM RM_CM_REPORT_FIRSTTURNRATE WHERE DUETIME>=TRUNC(:B1 -30,'dd') AND DUETIME < TRUNC(:B1 +1,'dd')

----- Call Stack Trace -----

... qerimrop qertqiFetch qerimfch qertqoFetch qerpxSlaveFetch qerpxFetch delexe opiexe kpoal8 opiodr kpoodr upirtrc kpurcsc kpuexec OCIStmtExecute kxfxsStmtExecute kxfxsExecute kxfxsp kxfxmai kxfprdp opirip opidrv ...


Explain plan in the trace file shows an operation "The PX SEND QC (RANDOM)" which indicates the aggregated values are being sent to the QC (Query Coordinator) in random order.

============
Plan Table
============
---------------------------------------------------------------+-----------------------------------+-------------------------+
| Id  | Operation                  | Name                      | Rows  | Bytes | Cost  | Time      |  TQ  |IN-OUT|PQ Distrib |
---------------------------------------------------------------+-----------------------------------+-------------------------+
| 0   | DELETE STATEMENT           |                           |       |       |  6568 |           |      |      |           |
| 1   |  PX COORDINATOR            |                           |       |       |       |           |      |      |           |
| 2   |   PX SEND QC (RANDOM)      | :TQ10001                  |  2171 |   32K |  6568 |  00:00:14 |:Q1001| P->S |QC (RANDOM)|
| 3   |    INDEX MAINTENANCE       | RM_CM_REPORT_FIRSTTURNRATE|       |       |       |           |:Q1001| PCWP |           |
| 4   |     PX RECEIVE             |                           |  2171 |   32K |  6568 |  00:00:14 |:Q1001| PCWP |           |
| 5   |      PX SEND RANGE         | :TQ10000                  |  2171 |   32K |  6568 |  00:00:14 |:Q1000| P->P |RANGE      |
| 6   |       DELETE               | RM_CM_REPORT_FIRSTTURNRATE|       |       |       |           |:Q1000| PCWP |           |
| 7   |        FILTER              |                           |       |       |       |           |:Q1000| PCWC |           |
| 8   |         PX BLOCK ITERATOR  |                           |  2171 |   32K |  6568 |  00:00:14 |:Q1000| PCWC |           |
| 9   |          TABLE ACCESS FULL | RM_CM_REPORT_FIRSTTURNRATE|  2171 |   32K |  6568 |  00:00:14 |:Q1000| PCWP |           |
---------------------------------------------------------------+-----------------------------------+-------------------------+

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms