Oracle Solaris上的一套11.2.0.1.0最近出现以下告警记录:
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
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] [] [] [] []
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
========= 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驱动解决了。