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
喜欢请赞赏一下啦^_^
微信赞赏
支付宝赞赏