Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12805 parallel query server died unexpectedly

Vsevolod AfanassievMay 20 2020 — edited May 22 2020

12.1.0.2.0 on AIX 7.1, standalone

I am getting this error for no apparent reason.

For example, today I was running an extract based on a simple query selecting from 2 tables, each with PARALLEL 2.

Expected it to return 4 million rows - did SELECT COUNT(*) before running the extract.

After 2 hours/3 million rows the extract failed with ORA-12805.

No other error, no error in alert.log, no pXXX process trace file was updated around the time of the failure, nothing in /var/adm/messages

Found MOS bug 25694206, however it is supposed to produce ORA-07445 or ORA-00600.

It is recommended to set "_px_wif_extend_distribution_keys"=false

Any comments, suggestions?

Comments
Post Details
Added on May 20 2020
2 comments
7,469 views