ORA-3137 [12333]

问题归档 2019-05-20
20
0 0
摘要:ORA-03137: TTC 协议内部错误: [12333] [11] [119] [97] [] [] [] []

问题描述

数据库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=[





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

专家解答

可能是个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]


与变量窥探相关,麻烦确认一下隐含参数是否配置,如果没有配置的话,建议设置一下隐含参数来规避BUG,或者升级至11204或者更高版本。

alter system set "_optim_peek_user_binds"=false;

「喜欢文章,快来给作者赞赏墨值吧」

评论

0
0
Oracle
订阅
欢迎订阅Oracle频道,订阅之后可以获取最新资讯和更新通知。
墨值排行
今日本周综合
近期活动
全部
相关课程
全部