放假前檢查一套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';
今日推薦
