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.

3 comments

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

  2. Thank you.

Leave a Reply

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