问题描述
数据库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;
