Wednesday , July 6 2022

ORA-12805: parallel query server died unexpectedly error in 12c databases

In 12c databases, ORA-12805, ORA-07445 [qertqistart] or ORA-600 [15803] errors may occur depending on bug 25694206. User operation cannot be completed due to the closing of parallel processes.

The problem is corrected in version 12.2.0.2, and the following workraound can be applied to the problem.

To resolve the problem, the parameter “_px_wif_extend_distribution_keys” must be set to false.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

4 comments

  1. This solved an issue we were having on a RAC instance on an Oracle Data Appliance…
    Much appreciated.

  2. Thank you.

  3. This solution definitely resolved the issue. But I wanted to know as how this parameter is affecting the programs throwing ORA-12805. We were getting this error only from OEM and no error witnessed in alertlog file of the target database nor the em database. Only seen below events in em UI
    Wait Events reported at times are
    1. resmgr:cpu quantum. (Schedular waits 47.6 %)
    2. enq: TX – row lock contention. (causing application waits ~ 33%)

Leave a Reply

Your email address will not be published. Required fields are marked *