ITPub博客

首页 > 数据库 > Oracle > 数据库alert日志报ORA-03137 TTC 协议内部错误故障分析处理

数据库alert日志报ORA-03137 TTC 协议内部错误故障分析处理

Oracle 作者:yuntui 时间:2016-11-03 20:19:48 0 删除 编辑
环境:AIX 7100
数据库版本:11.2.0.4
是否RAC:是




1、最近巡检发现某数据库DB alert日志报错,其日志详细如下:
Fri Oct 10 15:41:28 2014 
Errors in file /oraclelog/diag/rdbms/dbrac/dbrac1/trace/dbrac1_ora_21430388.trc (incident=120497): 
ORA-03137: TTC 协议内部错误: [12333] [19] [3] [94] [] [] [] [] 
Incident details in: /oraclelog/diag/rdbms/dbrac/dbrac1/incident/incdir_120497/dbrac1_ora_21430388_i120497.trc 




2、查看trace日志如下:
dbrac1_ora_21430388_i120497.trc:
Error Code 
--------------- 
*** 2014-10-10 15:41:28.018 
*** SESSION ID:(1944.5995) 2014-10-10 15:41:28.018 
*** CLIENT ID:() 2014-10-10 15:41:28.018 
*** SERVICE NAME:(dbrac) 2014-10-10 15:41:28.018 
*** MODULE NAME:() 2014-10-10 15:41:28.018 
*** ACTION NAME:() 2014-10-10 15:41:28.018 


Dump continued from file: /oraclelog/diag/rdbms/dbrac/dbrac1/trace/dbrac1_ora_21430388.trc 
ORA-03137: TTC 协议内部错误: [12333] [19] [3] [94] [] [] [] [] 


File Version 
------------------ 
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production 
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, 
Data Mining and Real Application Testing options 
ORACLE_HOME = /oracle/app/oracle/product/11.2.0/db 
System name: AIX 
Node name: dbracdb1 
Release: 1 
Version: 7 
Machine: 00C011C54C00 
Instance name: dbrac1 
Redo thread mounted by this instance: 1 
Oracle process number: 62 
Unix process pid: 21430388, image: oracle@dbracdb1 


Current SQL 
------------------- 
----- Current SQL Statement for this session (sql_id=7f9ykbk0wg05r) ----- 
insert into tt_user(user_id,time,endtime,month,entry_time,VARCHAR_0) values(:1,:2,:3,:4,:5,:6) 


Process State 
-------------------- 
SO: 0x700010711bdf258, type: 4, owner: 0x7000107091e2920, flag: INIT/-/-/0x00 if: 0x3 c: 0x3 
proc=0x7000107091e2920, name=session, file=ksu.h LINE:12729 ID:, pg=0 
(session) sid: 1944 ser: 5995 trans: 0x0, creator: 0x7000107091e2920 
flags: (0x41) USR/- flags_idl: (0x0) -/-/-/-/-/- 
flags2: (0x40009) -/-/INC 
DID: , short-term DID: 
txn branch: 0x0 
edition#: 100 oct: 2, prv: 0, sql: 0x70001071699f990, psql: 0x70001071699f990, user: 50/UCR_dbrac 
ksuxds FALSE at location: 0 
service name: dbrac 
client details: 
O/S info: user: , term: , ospid: 1234 
machine: T330 program: 




3、分析了下该错误自上次启动以来只触发了3次,触发后sql运行不成功,没其他影响,
参考Understanding and Diagnosing ORA-00600 [12333] / ORA-3137 [12333] Errors ( Doc ID 389713.1 ) 


4、综合文档得出该问题与JDBC有关: 
1)使用最新版本的 JDBC。 
2)监控和正确处理应用 timeout 的情况。 
3)确保 idle 或者 died 进程被正确清理掉。 
4)从JDBC端增大 queue sizes / buffers。 


5、将T330这台机器上的JDBC版本(10.2.0.1)换成11.1.0.7之后,该错误就没再重现,问题解决。



来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/30633755/viewspace-2127673/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2015-12-14

  • 博文量
    150
  • 访问量
    70813