放假前检查一套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';

技术
下载桌面版
GitHub
百度网盘(提取码:draw)
Gitee
云服务器优惠
阿里云优惠券
腾讯云优惠券
华为云优惠券
站点信息
问题反馈
邮箱:ixiaoyang8@qq.com
QQ群:766591547
关注微信