Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
#general-database-discussions
2 comments
5,942 views