暂无图片
12c rac其中一个节点告警日志每两三分钟出现ORA-12805
我来答
返回问答列表
分享
吾喾
2019-09-04
12c rac其中一个节点告警日志每两三分钟出现ORA-12805
oracle

2019-09-04T09:23:16.382470+08:00

Errors in file /u01/app/oracle/diag/rdbms/sibcyb1/SIBCYB112/trace/SIBCYB112_cjq0_54487.trc:

ORA-12805: parallel query server died unexpectedly

数据库正常，请问怎么处理？

我来答
添加附件
收藏
分享
问题补充
10条回答
默认
最新
Moone

描述太简单，需要上传alertlog及对应的trace日志。另外看看当时数据库是否正常，有没有负载过高，可以发个awr报告。

暂无图片 评论
暂无图片 有用 0
打赏 0
暂无图片
吾喾
上传附件：SIBCYB112_cjq0_54487.trc
暂无图片 评论
暂无图片 有用 0
打赏 0
吾喾
AWR分析结果: 1567646377986_awrrpt_2_16672_16696.html
暂无图片 评论
暂无图片 有用 0
打赏 0
吾喾

alert日志一直报错如下，SIBCYB112_cjq0_54487.trc文件会一直增大造成/u01目录使用率100%，目前定期清空这个trc文件，这个文件最上面的一些内容没有了。

SIBCYB112_cjq0_54487.trc文件比较大，十几个G，上传的最近的300行记录。AWR是9.4号上午10点到下午6点的，见附件。

注：没有业务在上面跑。有OGG进程。

2019-09-05T08:03:01.359282+08:00
Errors in file /u01/app/oracle/diag/rdbms/sibcyb1/SIBCYB112/trace/SIBCYB112_cjq0_54487.trc:
ORA-12805: parallel query server died unexpectedly
2019-09-05T08:06:37.025104+08:00
Errors in file /u01/app/oracle/diag/rdbms/sibcyb1/SIBCYB112/trace/SIBCYB112_cjq0_54487.trc:
ORA-12805: parallel query server died unexpectedly
2019-09-05T08:10:12.878230+08:00
Errors in file /u01/app/oracle/diag/rdbms/sibcyb1/SIBCYB112/trace/SIBCYB112_cjq0_54487.trc:
ORA-12805: parallel query server died unexpectedly
2019-09-05T08:13:48.547561+08:00
Errors in file /u01/app/oracle/diag/rdbms/sibcyb1/SIBCYB112/trace/SIBCYB112_cjq0_54487.trc:
ORA-12805: parallel query server died unexpectedly
2019-09-05T08:17:40.534735+08:00
Errors in file /u01/app/oracle/diag/rdbms/sibcyb1/SIBCYB112/trace/SIBCYB112_cjq0_54487.trc:
ORA-12805: parallel query server died unexpectedly
ORA-12805: parallel query server died unexpectedly
2019-09-05T08:21:16.046917+08:00
Errors in file /u01/app/oracle/diag/rdbms/sibcyb1/SIBCYB112/trace/SIBCYB112_cjq0_54487.trc:
ORA-12805: parallel query server died unexpectedly
2019-09-05T08:24:51.609901+08:00
Errors in file /u01/app/oracle/diag/rdbms/sibcyb1/SIBCYB112/trace/SIBCYB112_cjq0_54487.trc:
ORA-12805: parallel query server died unexpectedly
2019-09-05T08:28:27.176907+08:00
Errors in file /u01/app/oracle/diag/rdbms/sibcyb1/SIBCYB112/trace/SIBCYB112_cjq0_54487.trc:
ORA-12805: parallel query server died unexpectedly
2019-09-05T08:32:02.713122+08:00
Errors in file /u01/app/oracle/diag/rdbms/sibcyb1/SIBCYB112/trace/SIBCYB112_cjq0_54487.trc:
ORA-12805: parallel query server died unexpectedly
2019-09-05T08:35:38.319046+08:00
Errors in file /u01/app/oracle/diag/rdbms/sibcyb1/SIBCYB112/trace/SIBCYB112_cjq0_54487.trc:
ORA-12805: parallel query server died unexpectedly
2019-09-05T08:39:13.724881+08:00
Errors in file /u01/app/oracle/diag/rdbms/sibcyb1/SIBCYB112/trace/SIBCYB112_cjq0_54487.trc:
ORA-12805: parallel query server died unexpectedly
2019-09-05T08:42:49.365848+08:00
Errors in file /u01/app/oracle/diag/rdbms/sibcyb1/SIBCYB112/trace/SIBCYB112_cjq0_54487.trc:
ORA-12805: parallel query server died unexpectedly
2019-09-05T08:46:25.011663+08:00
Errors in file /u01/app/oracle/diag/rdbms/sibcyb1/SIBCYB112/trace/SIBCYB112_cjq0_54487.trc:
ORA-12805: parallel query server died unexpectedly
2019-09-05T08:50:00.264151+08:00
Errors in file /u01/app/oracle/diag/rdbms/sibcyb1/SIBCYB112/trace/SIBCYB112_cjq0_54487.trc:
ORA-12805: parallel query server died unexpectedly
2019-09-05T08:53:35.795814+08:00
Errors in file /u01/app/oracle/diag/rdbms/sibcyb1/SIBCYB112/trace/SIBCYB112_cjq0_54487.trc:
ORA-12805: parallel query server died unexpectedly
2019-09-05T08:57:11.404913+08:00
Errors in file /u01/app/oracle/diag/rdbms/sibcyb1/SIBCYB112/trace/SIBCYB112_cjq0_54487.trc:
ORA-12805: parallel query server died unexpectedly

暂无图片 评论
暂无图片 有用 0
打赏 0
cherish军

 没alert ，试试改下max_idle_time 有没有效果

暂无图片 评论
暂无图片 有用 0
打赏 0
吾喾

[root@hnsib-exa02 ~]# ps -ef |grep 54487
oracle    54487      1  3 Aug21 ?        13:42:57 ora_cjq0_SIBCYB112

还是报错，能否把54487 进程kill？


2019-09-05T16:45:18.253924+08:00

ALTER SYSTEM SET max_idle_time=120 SCOPE=BOTH;



2019-09-05T16:46:10.152927+08:00
KILL SESSION for sid=(8838, 26667):
  Reason = max_idle_time parameter
  Mode = KILL HARD SAFE -/-/-
  Requestor = PMON (orapid = 2, ospid = 50497, inst = 2)
  Owner = Process: USER (orapid = 169, ospid = 54770)
  Result = ORA-0
KILL SESSION for sid=(9081, 55052):
  Reason = max_idle_time parameter
  Mode = KILL HARD SAFE -/-/-
  Requestor = PMON (orapid = 2, ospid = 50497, inst = 2)
  Owner = Process: USER (orapid = 171, ospid = 54786)
  Result = ORA-0
2019-09-05T16:46:12.558834+08:00
Errors in file /u01/app/oracle/diag/rdbms/sibcyb1/SIBCYB112/trace/SIBCYB112_cjq0_54487.trc:
ORA-12805: parallel query server died unexpectedly

暂无图片 评论
暂无图片 有用 0
打赏 0
杨杰

看下/var/log/messages有没有报错，检查下数据库有没有开并行很高的SQL

暂无图片 评论
暂无图片 有用 0
打赏 0
吾喾

tail -50 /var/log/messages


Sep  7 10:23:40 hnsib-exa02 rsyslogd-2177: imuxsock lost 183 messages from pid 43367 due to rate-limiting
Sep  7 10:23:41 hnsib-exa02 rsyslogd-2177: imuxsock lost 123 messages from pid 43645 due to rate-limiting
Sep  7 10:26:22 hnsib-exa02 rsyslogd-2177: imuxsock begins to drop messages from pid 49908 due to rate-limiting
Sep  7 10:36:23 hnsib-exa02 rsyslogd-2177: imuxsock begins to drop messages from pid 77066 due to rate-limiting
Sep  7 10:40:01 hnsib-exa02 rsyslogd-2177: imuxsock lost 123 messages from pid 89107 due to rate-limiting
Sep  7 10:46:25 hnsib-exa02 rsyslogd-2177: imuxsock begins to drop messages from pid 105939 due to rate-limiting
Sep  7 10:46:27 hnsib-exa02 rsyslogd-2177: imuxsock lost 123 messages from pid 106027 due to rate-limiting
Sep  7 10:53:40 hnsib-exa02 rsyslogd-2177: imuxsock lost 121 messages from pid 124432 due to rate-limiting
Sep  7 10:53:43 hnsib-exa02 rsyslogd-2177: imuxsock lost 125 messages from pid 124980 due to rate-limiting
Sep  7 10:53:44 hnsib-exa02 rsyslogd-2177: imuxsock lost 123 messages from pid 124986 due to rate-limiting
Sep  7 10:56:25 hnsib-exa02 rsyslogd-2177: imuxsock begins to drop messages from pid 133040 due to rate-limiting
Sep  7 11:06:27 hnsib-exa02 rsyslogd-2177: imuxsock begins to drop messages from pid 159630 due to rate-limiting
Sep  7 11:16:29 hnsib-exa02 rsyslogd-2177: imuxsock begins to drop messages from pid 186290 due to rate-limiting
Sep  7 11:25:47 hnsib-exa02 rsyslogd-2177: imuxsock lost 183 messages from pid 210126 due to rate-limiting
Sep  7 11:26:28 hnsib-exa02 rsyslogd-2177: imuxsock begins to drop messages from pid 212878 due to rate-limiting
Sep  7 11:30:47 hnsib-exa02 rsyslogd-2177: imuxsock lost 57 messages from pid 224580 due to rate-limiting
Sep  7 11:36:30 hnsib-exa02 rsyslogd-2177: imuxsock begins to drop messages from pid 239361 due to rate-limiting
Sep  7 11:46:33 hnsib-exa02 rsyslogd-2177: imuxsock begins to drop messages from pid 268221 due to rate-limiting
Sep  7 11:56:35 hnsib-exa02 rsyslogd-2177: imuxsock begins to drop messages from pid 292377 due to rate-limiting
Sep  7 11:56:36 hnsib-exa02 rsyslogd-2177: imuxsock lost 27 messages from pid 292377 due to rate-limiting
Sep  7 12:00:01 hnsib-exa02 rsyslogd-2177: imuxsock lost 123 messages from pid 303114 due to rate-limiting
Sep  7 12:05:48 hnsib-exa02 rsyslogd-2177: imuxsock lost 123 messages from pid 318589 due to rate-limiting
Sep  7 12:06:37 hnsib-exa02 rsyslogd-2177: imuxsock begins to drop messages from pid 318899 due to rate-limiting
Sep  7 12:15:48 hnsib-exa02 rsyslogd-2177: imuxsock lost 155 messages from pid 345369 due to rate-limiting
Sep  7 12:16:37 hnsib-exa02 rsyslogd-2177: imuxsock begins to drop messages from pid 345735 due to rate-limiting
Sep  7 12:21:53 hnsib-exa02 rsyslogd-2177: imuxsock lost 61 messages from pid 360933 due to rate-limiting
Sep  7 12:26:16 hnsib-exa02 rsyslogd-2177: imuxsock lost 151 messages from pid 372160 due to rate-limiting
Sep  7 12:26:37 hnsib-exa02 rsyslogd-2177: imuxsock begins to drop messages from pid 372321 due to rate-limiting
Sep  7 12:29:03 hnsib-exa02 rsyslogd-2177: imuxsock lost 123 messages from pid 381343 due to rate-limiting
Sep  7 12:36:37 hnsib-exa02 rsyslogd-2177: imuxsock begins to drop messages from pid 398870 due to rate-limiting
Sep  7 12:46:41 hnsib-exa02 rsyslogd-2177: imuxsock begins to drop messages from pid 30346 due to rate-limiting
Sep  7 12:46:42 hnsib-exa02 rsyslogd-2177: imuxsock lost 41 messages from pid 30346 due to rate-limiting
Sep  7 12:47:58 hnsib-exa02 rsyslogd-2177: imuxsock lost 123 messages from pid 35625 due to rate-limiting
Sep  7 12:56:39 hnsib-exa02 rsyslogd-2177: imuxsock begins to drop messages from pid 58135 due to rate-limiting
Sep  7 13:06:41 hnsib-exa02 rsyslogd-2177: imuxsock begins to drop messages from pid 84777 due to rate-limiting
Sep  7 13:16:40 hnsib-exa02 rsyslogd-2177: imuxsock lost 739 messages from pid 111482 due to rate-limiting
Sep  7 13:16:42 hnsib-exa02 rsyslogd-2177: imuxsock begins to drop messages from pid 111482 due to rate-limiting
Sep  7 13:23:42 hnsib-exa02 rsyslogd-2177: imuxsock lost 151 messages from pid 131901 due to rate-limiting
Sep  7 13:26:44 hnsib-exa02 rsyslogd-2177: imuxsock begins to drop messages from pid 138304 due to rate-limiting
Sep  7 13:36:44 hnsib-exa02 rsyslogd-2177: imuxsock begins to drop messages from pid 164788 due to rate-limiting
Sep  7 13:38:47 hnsib-exa02 rsyslogd-2177: imuxsock lost 121 messages from pid 170922 due to rate-limiting
Sep  7 13:46:48 hnsib-exa02 rsyslogd-2177: imuxsock begins to drop messages from pid 193813 due to rate-limiting
Sep  7 13:55:09 hnsib-exa02 rsyslogd-2177: imuxsock lost 123 messages from pid 216453 due to rate-limiting
Sep  7 13:56:46 hnsib-exa02 rsyslogd-2177: imuxsock begins to drop messages from pid 220455 due to rate-limiting
Sep  7 14:06:48 hnsib-exa02 rsyslogd-2177: imuxsock begins to drop messages from pid 247081 due to rate-limiting
Sep  7 14:09:03 hnsib-exa02 rsyslogd-2177: imuxsock lost 122 messages from pid 253182 due to rate-limiting
Sep  7 14:16:13 hnsib-exa02 rsyslogd-2177: imuxsock lost 151 messages from pid 272969 due to rate-limiting
Sep  7 14:16:49 hnsib-exa02 rsyslogd-2177: imuxsock begins to drop messages from pid 273878 due to rate-limiting
Sep  7 14:23:44 hnsib-exa02 rsyslogd-2177: imuxsock lost 121 messages from pid 291941 due to rate-limiting



数据库没有开并行很高的SQL。

暂无图片 评论
暂无图片 有用 0
打赏 0
tnan1986

问题解决了吗？也遇到了类似的问题，好像是12c的BUG，清空shared_pool 也不起作用，必须重启实例才可以

暂无图片 评论
暂无图片 有用 1
打赏 0
tnan1986

有文章说当 ORA-12805, ORA-07445 [qertqistart] or ORA-600 [15803] 发生时，可能是因为bug 25694206. 下面的解决方法可以解决

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

可以试试。

暂无图片 评论
暂无图片 有用 1
打赏 0
回答交流
Markdown


请输入正文
提交
相关推荐
19c数据库不小心创建成的非容器数据库，有什么办法可以修改成容器数据库么？
回答 5
1、创建一个新的CDB;2、在新创建的CDB创建一个到noncdb的dblink；3、在新创建的CDB中执行CREATEPLUGGABLEDATABASEpdbnameFROMNON$CDB@dbli
Oracle的dbca建库失败怎么删除干净？
回答 4
已采纳
删库rmrf$ORACLEBASE/../rmrf/etc/oracle/rmf/etc/oraInstrmf/etc/oratab
oracle 11g rac集群 的 public 网络 改成子网划分后的网络比如，子网是255.255.255.192这样支持不？有大神在不
回答 4
支持，只要保证所有节点在一个子网就没问题！！
ogg抽取进程报错： ERROR OGG-00446
回答 8
你viewreport抽取进程所有报错截图看看呢
大家早上好，请教个问题，oracle产生的trc文件如何解读？
回答 3
你要上传整个文件，单看这个截图一无所知。
version_count超过100如何解决
回答 3
1、排查sql语句的书写差异，一般都是程序书写，先同研发沟通是否使用了动态sql，动态sql当然会导致versioncount问题。2、除了sql语句之外要注意观察sql中的变量类型和变量长度，这些同
Oracle 12c 有32位客户端安装包吗?
回答 3
请到官网下载
关于生成修改日志，临时表是怎样做的？
回答 1
已采纳
在OracleDatabase12c中，临时表的undo处理与之前的版本有着明显区别，所对针对这个问题分为两部分回答：12c之前与12c之后。1、12c之前：临时表的数据块不会生成redo，因此，对临
oracle数据导入opengauss用什么工具？
回答 2
已采纳
差点忘了，还有个好东西，MTKhttps://docs.mogdb.io/zh/mtk/v2.0/mtkoracletoopenGauss
linux怎么彻底卸载oracle
回答 2
已采纳
好办。先吧数据库实例和监听都停了。用命令停止。然后你就删除目录rmrf/u01/app/oracle类似这样的目录以及home目录下的oracle。
问题信息
请登录之后查看
附件列表
请登录之后查看
邀请回答
暂无人订阅该标签，敬请期待~~
暂无图片墨值悬赏
55M
ORACLE 11.2.0 触发器 获取 空间属性的wkt格式，使用 sde.st_astext 函数，数据错乱
25M
求Cylance杀毒软件安装包测试数据库安全
25M
PostgreSQL ERROR: found xmin 2146512304 from before relfrozenxid 2146512317
10M
clickhouse 查询视图需要给基表的权限，有什么办法能场查视图不能查表呢？
10M
oracle apex是否可以使用nfc功能，以及录像保存功能
10M
视图v$sql_cs_selectivity 同一个RANGE_ID之下出现了同一个微词的重复记录。
10M
一个update 语句行锁升级 触发bug导致死锁myql宕机？请大佬帮忙分析下更具体原因
10M
时区升级
10M
Goldengate源端PDB，被克隆替代后，重新配置麻烦，有无其它方便，高效方法，恢复Goldengate？
10M
OGG使用COLMAP部分字段不同步问题