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: oracle@ut06db03 *** 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 <- ksedst <- dbkedDefDump <- ksedmp <- dbgexPhaseII <- dbgexProcessError <- dbgePostErrorKGE <- 1438 <- opiierr <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main <- start ---------------------------------------- SO: 0x5fb961a98, type: 4, owner: 0x5fff8fd60, flag: INIT/-/-/0x00 if: 0x3 c: 0x3 proc=0x5fff8fd60, name=session, file=ksu.h LINE:11467 ID:, pg=0 (session) sid: 1203 ser: 16390 trans: 0x0, creator: 0x5fff8fd60 flags: (0x41) USR/- flags_idl: (0x0) -/-/-/-/-/- flags2: (0x40008) -/- DID: , short-term DID: txn branch: 0x0 oct: 3, prv: 0, sql: 0x5b08829c0, psql: 0x5d799a460, user: 67/NBBS_MTS ksuxds FALSE at location: 0 service name: SYS$USERS client details: O/S info: user: , term: , ospid: 1234 machine: ut06nbbs01 program: Current Wait Stack: Not in wait; last wait ended 1.274194 sec ago以上Select语句在sqlplus或sql developer等工具远程登录后执行均没有出错,仅在使用jdbc驱动连接时出现ORA-03137: TTC protocol internal error : [12333] [11]错误;提交SR,MOS认为该应用使用的JDBC API version 2.1过旧,建议升级到最新版本。 这个case通过升级jdbc驱动解决了。
posted on 2010-09-05 20:43 Oracle和MySQL 阅读(428) 评论(0) 编辑 收藏 举报