暂无图片
分享
朱贺
2019-04-25
ORA-3137

数据库alert日志:

Errors in file /oracle/diag/rdbms/db/db/trace/db_ora_23789686.trc  (incident=216944):

ORA-03137: TTC 协议内部错误: [12333] [4] [108] [105] [] [] [] []

Incident details in: /oracle/diag/rdbms/db/db/incident/incdir_216944/db_ora_23789686_i216944.trc

Mon Apr 22 12:35:53 2019

Trace dumping is performing id=[cdmp_20190422123553]

Mon Apr 22 12:35:56 2019

Sweep [inc][216944]: completed

Sweep [inc2][216944]: completed

Mon Apr 22 12:45:42 2019

Errors in file /oracle/diag/rdbms/db/db/trace/db_ora_32440410.trc  (incident=216872):

ORA-03137: TTC 协议内部错误: [12333] [4] [108] [105] [] [] [] []

Incident details in: /oracle/diag/rdbms/db/db/incident/incdir_216872/db_ora_32440410_i216872.trc

Mon Apr 22 12:45:44 2019

Trace dumping is performing id=[cdmp_20190422124544]

Mon Apr 22 12:45:47 2019

Sweep [inc][216872]: completed

Sweep [inc2][216872]: completed

Mon Apr 22 12:47:12 2019

Errors in file /oracle/diag/rdbms/db/db/trace/db_ora_34013288.trc  (incident=216920):

ORA-03137: TTC 协议内部错误: [12333] [11] [119] [97] [] [] [] []

Incident details in: /oracle/diag/rdbms/db/db/incident/incdir_216920/db_ora_34013288_i216920.trc

Mon Apr 22 12:47:15 2019

Trace dumping is performing id=[



请问问题产生原因和处理建议!感谢支持!

收藏
分享
7条回答
默认
最新
朱贺
上传附件:db_ora_34013288.trc
暂无图片 评论
暂无图片 有用 0
Moone

上传下/oracle/diag/rdbms/db/db/incident/incdir_216920/db_ora_34013288_i216920.trc,可能是个bug:

Unpublished Bug 9703463 - ORA-3137 [12333] or ORA-600 [kpobav-1] When Using Bind Peeking

This bug affects versions 11.1.0.6, 11.1.0.7, and 11.2.0.1 of the RDBMS.  It is fixed in version 11.2.0.2 of the database.

It can also occur intermittently; similarly to unpublished Bug:8625762, this is a bind peeking bug.

 

Unpublished Bug:9243912 - Additional diagnostics for ORA-3137 [12333] / OERI:12333

This bug affects versions of the RDBMS lower than version 11.2.0.2.  It is fixed in version 11.2.0.2 of the database.

This bug addresses scenarios in which the ORA-3137 [12333] error occur bind issues during the client/server communication process.  When this particular bug is fixed, the result may be the uncovering of an additional, more descriptive error:  ORA-600 [kpobav-1]

你数据库版本较低,建议升级到11.2.0.4的最新

暂无图片 评论
暂无图片 有用 0
朱贺
暂无图片 评论
暂无图片 有用 0
朱贺

相关trc已上传

暂无图片 评论
暂无图片 有用 0
我是DBA

这个问题可能与之前提到的两个BUG相关,可能与变量窥探相关,麻烦确认一下隐含参数是否配置,如果没有配置的话,建议设置一下隐含参数来规避BUG,或者升级至更高版本。

alter system set "_optim_peek_user_binds"=false;

暂无图片 评论
暂无图片 有用 0
朱贺

您好,该参数配置为TRUE。非常感谢两位专家解答

暂无图片 评论
暂无图片 有用 0
章芋文
问题已关闭: 问题已经得到解决
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
附件列表
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏