Parallel Query Fails With ORA-12801 And ORA-942 Intermittently In RAC
Last updated on JANUARY 18, 2017
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 11.2]
Information in this document applies to any platform.
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
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
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.
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