Oracle12c R2注意事项：ORA-12805问题

一套Oracle 12.2.0.1  4-nodes RAC on Linux 环境, 又一个BUG会生成大量的日志信息如下， 之前分享过一个生成大量trace的笔记
Oracle12c R2注意事项： 因BUG生成大量的trace file 包含KRB: (rman module), 这里记录另一个bug.

# db alert log

2019-08-02T16:45:30.696722+08:00
Errors in file /u01/app/oracle/diag/rdbms/anbob/anbob1/trace/anbob1_cjq0_24035.trc:
ORA-12805: parallel query server died unexpectedly
2019-08-02T16:45:52.826713+08:00
Errors in file /u01/app/oracle/diag/rdbms/anbob/anbob1/trace/anbob1_cjq0_24035.trc:
ORA-12805: parallel query server died unexpectedly
2019-08-02T16:46:14.632368+08:00
Errors in file /u01/app/oracle/diag/rdbms/anbob/anbob1/trace/anbob1_cjq0_24035.trc:
ORA-12805: parallel query server died unexpectedly
2019-08-02T16:46:53.042486+08:00
Errors in file /u01/app/oracle/diag/rdbms/anbob/anbob1/trace/anbob1_cjq0_24035.trc:
ORA-12805: parallel query server died unexpectedly
2019-08-02T16:47:20.805880+08:00
Errors in file /u01/app/oracle/diag/rdbms/anbob/anbob1/trace/anbob1_cjq0_24035.trc:
ORA-12805: parallel query server died unexpectedly
2019-08-02T16:47:43.007194+08:00
Errors in file /u01/app/oracle/diag/rdbms/anbob/anbob1/trace/anbob1_cjq0_24035.trc:
ORA-12805: parallel query server died unexpectedly
2019-08-02T16:48:05.297383+08:00
Errors in file /u01/app/oracle/diag/rdbms/anbob/anbob1/trace/anbob1_cjq0_24035.trc:

Note:
大量的以上错误日志频繁提示与cjq进程相关，并且cjq trace文件非常大。

解决方案：
属于BUG 27579159，
1，临时解决方法可以直接清理文件。
2， 升级到19c（19.1），
3， 安装 one-off patch for
12.1.0.2
12.2.0.1 and 170718DBRU+
18.3DBUR, 18.5 DBRU+

问题二

另外在12c- 18c 之间有也是会也现ora-12805错误，当 ORA-12805, ORA-07445 [qertqistart] or ORA-600 [15803] 发生时，可能是因为bug 25694206. 下面的解决方法可以解决

SQL> alter system set "_px_wif_extend_distribution_keys"=false scope=both sid='*';

问题三

在12.2以后还可以出现下面的错误
# db alert log

opidcl aborting process unknown ospid (43364) as a result of ORA-12805
CLMN: delete dead process - succeeded

call stack:
ksesecl0 <- ksucin <- updrow <- qerusEvalUpdWhere <- qerusRop <- qerpxFetch <- qerusFetch <- updaul <- updThreePhaseExe <- upsexe

解决方法:
增长PQ运行的时间限制

SQL> alter system set max_idle_time=0 scope=both;
SQL> alter system set max_idle_time=60 scope=both;
引用：
Oracle12c R2注意事项：ORA-12805问题 | ANBOB