Parallel Query Fails With ORA-12801 And ORA-942 Intermittently In RAC (Doc ID 1551018.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

1. The following error is reported in alert log and incident trace file.

Parallel job fails with ora-942.
All SQL objects exist.

INSERT /*+ APPEND*/ INTO <Table_name>
*
ORA-12801: error signaled in parallel query server P002, instance
krx3adb02.kr.oracle.com:krx3a2 (2)
ORA-00942: table or view does not exist

2.  The Callstack looks similar to

kgeade kgereml kxfpProcessError kxfpProcessMsg kxfpqidqr
 kxfpqdqr kxfxgs kxfxcp qerpxSendParse kxfpValidateSlaveGroup
  kxfpgsg kxfrAllocSlaves kxfrialo kxfralo qerpx_rowsrc_start
   qerpxStart insExecSubQueryIni insExecStmtExecIniEngine

 

Please note that a parallel query consists of  a query coordinator ( QC) and parallel execution processes.
If a parallel execution process fails and is unable to send a message back to the QC then the QC puts a ORA-12801 on top of the Oracle Error message.
In general, the ORA-942  message shows the real problem and should be investigated as the cause.

To eliminate parallel query as the issue you can always disable parallelism and see if the issue persists.

 

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