天天看点

ttc error oracle,ORA-03137: TTC protocol internal error : [12333]错误一例

Oracle Solaris上的一套11.2.0.1.0最近出现以下告警记录:

Dump file /cnbbs01/app/oracle/diag/rdbms/nbbsprd1/nbbsprd1/incident/incdir_373041/nbbsprd1_ora_24754_i373041.trc

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

ORACLE_HOME = /cnbbs01/app/oracle/product/11.2.0/db_1

System name: SunOS

Node name: ut06db03

Release: 5.10

Version: Generic_142901-12

Machine: i86pc

Instance name: nbbsprd1

Redo thread mounted by this instance: 1

Oracle process number: 130

Unix process pid: 24754, image: [email protected]

*** 2010-08-25 02:01:19.169

*** SESSION ID:(1203.16390) 2010-08-25 02:01:19.169

*** CLIENT ID:() 2010-08-25 02:01:19.169

*** SERVICE NAME:(SYS$USERS) 2010-08-25 02:01:19.169

*** MODULE NAME:() 2010-08-25 02:01:19.169

*** ACTION NAME:() 2010-08-25 02:01:19.169

Dump continued from file: /cnbbs01/app/oracle/diag/rdbms/nbbsprd1/nbbsprd1/trace/nbbsprd1_ora_24754.trc

ORA-03137: TTC protocol internal error : [12333] [11] [120] [110] [] [] [] []

========= Dump for incident 373041 (ORA 3137 [12333]) ========

*** 2010-08-25 02:01:19.170

dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)

----- Current SQL Statement for this session (sql_id=8ath6p5cx60q2) -----

SELECT eventtime, messageid, result, userid, username, userdomainid, objid, objname, objdomainid, data, data0, obj2id, server FROM eventlog a WHERE 1 = 1 AND EVENTTIME < :1 AND EVENTTIME > :2 AND messageid IN ('AdminUIAudit' , 'NBIAudit') ORDER BY EVENTTIME DESC

----- Call Stack Trace -----

ksedst1

以上Select语句在sqlplus或sql developer等工具远程登录后执行均没有出错,仅在使用jdbc驱动连接时出现ORA-03137: TTC protocol internal error : [12333] [11]错误;提交SR,MOS认为该应用使用的JDBC API version 2.1过旧,建议升级到最新版本。

这个case通过升级jdbc驱动解决了。