ORA-03137 TTC协议内部错误

刘泽宇

查看数据库alert日志发现存在大量报错：
Wed Jun 15 07:28:04 2021
Errors in file e:\app\administrator\diag\rdbms\gqdb\gqdb\trace\gqdb_ora_28448.trc  (incident=16177):
ORA-03137: TTC 协议内部错误: [12333] [64] [0] [98] [] [] [] []
Incident details in: e:\app\administrator\diag\rdbms\gqdb\gqdb\incident\incdir_16177\gqdb_ora_28448_i16177.trc
Wed Jun 15 07:28:08 2021
Trace dumping is performing id=[cdmp_20180829072808]
Wed Jun 15 07:28:38 2021
Errors in file e:\app\administrator\diag\rdbms\gqdb\gqdb\trace\gqdb_ora_45000.trc  (incident=16089):
ORA-03137: TTC 协议内部错误: [12333] [64] [0] [98] [] [] [] []
Incident details in: e:\app\administrator\diag\rdbms\gqdb\gqdb\incident\incdir_16089\gqdb_ora_45000_i16089.trc
Wed Jun 15 07:28:41 2021
Trace dumping is performing id=[cdmp_20180829072841]
Wed Jun 15 07:33:10 2021
Errors in file e:\app\administrator\diag\rdbms\gqdb\gqdb\trace\gqdb_ora_36984.trc  (incident=16178):
ORA-03137: TTC 协议内部错误: [12333] [64] [0] [98] [] [] [] []
Incident details in: e:\app\administrator\diag\rdbms\gqdb\gqdb\incident\incdir_16178\gqdb_ora_36984_i16178.trc

根据报错代码，查阅MOS文档
Troubleshooting ORA-3137 [12333]
Errors Encountered When Using Oracle JDBC Driver (文档 ID 1361107.1)


此报错信息来源于11.2.0.1其中一个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.


解决方案
1、禁用Bind Peeking

SQL> alter system set "_optim_peek_user_binds"=false;
此参数为oracle的隐含参数

2、升级数据库版本
此bug已在11.2.0.3以上版本修复，可升级此版本或更高

SQL> col ksppinm for a20
SQL> col ksppinm for a30
SQL> col ksppstvl for a30
SQL> col ksppdesc for a30
SQL> SELECT   ksppinm, ksppstvl, ksppdesc
      FROM   x$ksppi x, x$ksppcv y
     WHERE   x.indx = y.indx AND  ksppinm = '_optim_peek_user_binds';

KSPPINM                        KSPPSTVL                       KSPPDESC
------------------------------ ------------------------------ ------------------------------
_optim_peek_user_binds         TRUE                           enable peeking of user binds
查看隐含参数，此参数为开启状态