ORA-03137: TTC 协议内部错误: [12333] [19] [3] [15] [] [] [] []

放假前检查一套11.2.0.4环境时，发现orcl实例有告警，如下

ORA-03137: TTC 协议内部错误: [12333] [19] [3] [15] [] [] [] []
Fri Apr 28 05:00:02 2023
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_172524.trc  (incident=50371):
ORA-03137: TTC 协议内部错误: [12333] [19] [3] [15] [] [] [] []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_50371/orcl1_ora_172524_i50371.trc
Fri Apr 07 05:00:05 2023
Dumping diagnostic data in directory=[cdmp_20230407050005], requested by (instance=1, osid=172524), summary=[incident=50371].
Fri Apr 28 05:00:07 2023
Sweep [inc][50371]: completed
Sweep [inc2][50371]: completed

查看trc文件

----- DDE Diagnostic Information Dump -----
Depth: 1
DDE flags: 0x0
Heap: 0x7f2c8a408988
Incident Context pointer in diag: 0x7ffc703cb970
Incident ID Cache: 0x8464f50a8
Invocation Context #: 0
----- Invocation Context Dump -----
Address: 0x7f2c8a40d898
Phase: 3
flags: 0x18E0000
Incident ID: 50371
Error Descriptor: ORA-3137 [12333] [19] [3] [15] [] [] [] [] [] [] [] []
Error class: 0
Problem Key # of args: 1
Number of actions: 9
----- Incident Context Dump -----
Address: 0x7ffc703cb970
Incident ID: 50371
Problem Key: ORA 3137 [12333]
Error: ORA-3137 [12333] [19] [3] [15] [] [] [] [] [] [] [] []
[00]: dbgexProcessError [diag_dde]
[01]: dbgeExecuteForError [diag_dde]
[02]: dbgePostErrorKGE [diag_dde]
[03]: dbkePostKGE_kgsf [rdbms_dde]

   ORA-03137: TTC 协议内部错误: [12333] [19] [3] [15] [] [] [] []
------------------- end   error stack dump with barriers
----- END DDE Action: 'dumpKGEState' (SUCCESS, 0 csec) -----
----- START DDE Action: 'kpuActionDefault' (Sync) -----

直接查看mos文档 

Troubleshooting ORA-3137 [12333] Errors Encountered When Using Oracle JDBC Driver (Doc ID 1361107.1)

处理办法

SQL> alter system set "_optim_peek_user_binds"=false;

查看配置是否生效

set pagesize 199 linesize 199;
col ksppinm for a30
col ksppstvl for a30
col ksppdesc for a30
SELECT ksppinm, ksppstvl,ksppdesc
FROM x$ksppi x, x$ksppcv y WHERE x.indx = y.indx AND ksppinm = '_optim_peek_user_binds';

20230615更新-还有一种情况是客户端的jdbc版本过低导致的，如下案例

有个11g处理其他问题时发现ORA-03137: malformed TTC packet from client rejected，直接通知业务部门，可能172.66.0.108上的jdbc版本太低，过一会反馈结果确是jdbc版本问题，

2023-04-03T09:52:15.964905+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_26739166.trc  (incident=84009):
ORA-03137: malformed TTC packet from client rejected: [3146] [15] [] [] [] [] [] []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl2/incident/incdir_84009/orcl2_ora_26739155_i84009.trc
2023-04-03T09:52:19.478957+08:00
Session (611,6706): Bad TTC Packet Detected: Inbound connection from DBID: jdbc_ttc_impl GLOBAL_DB_NAME: jdbc_668
Session (611,6706): Bad TTC Packet Detected: DB Logon User: USR_XG, Remote Machine: app1, Program: JDBC Thin Client, OS User: weblogic
Session (611,6706): Bad TTC Packet Detected: Client IP Address: 172.66.0.108
2023-04-03T12:58:28.269515+08:00

2023-04-03T09:52:15.964905+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_26739166.trc  (incident=84009):
ORA-03137: malformed TTC packet from client rejected: [3146] [15] [] [] [] [] [] []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl2/incident/incdir_84009/orcl2_ora_26739155_i84009.trc
2023-04-03T09:52:19.478957+08:00
Session (611,6706): Bad TTC Packet Detected: Inbound connection from DBID: jdbc_ttc_impl GLOBAL_DB_NAME: jdbc_668
Session (611,6706): Bad TTC Packet Detected: DB Logon User: USR_XG, Remote Machine: app1, Program: JDBC Thin Client, OS User: weblogic
Session (611,6706): Bad TTC Packet Detected: Client IP Address: 172.66.0.108
2023-04-03T12:58:28.269515+08:00

2023-04-03T09:52:15.964905+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_26739166.trc  (incident=84009):
ORA-03137: malformed TTC packet from client rejected: [3146] [15] [] [] [] [] [] []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl2/incident/incdir_84009/orcl2_ora_26739155_i84009.trc
2023-04-03T09:52:19.478957+08:00
Session (611,6706): Bad TTC Packet Detected: Inbound connection from DBID: jdbc_ttc_impl GLOBAL_DB_NAME: jdbc_668
Session (611,6706): Bad TTC Packet Detected: DB Logon User: USR_XG, Remote Machine: app1, Program: JDBC Thin Client, OS User: weblogic
Session (611,6706): Bad TTC Packet Detected: Client IP Address: 172.66.0.108
2023-04-03T12:58:28.269515+08:00