Oracle Solaris上的一套11.2.0.1.0最近出现以下告警记录:
以上Select语句在sqlplus或sql developer等工具远程登录后执行均没有出错，仅在使用jdbc驱动连接时出现ORA-03137: TTC protocol internal error : [12333] [11]错误；提交SR，MOS认为该应用使用的JDBC API version 2.1过旧，建议升级到最新版本。 这个case通过升级jdbc驱动解决了。
|
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.trcOracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
ORACLE_HOME = /cnbbs01/app/oracle/product/11.2.0/db_1System name: SunOS
Node name: ut06db03
Release: 5.10Version: Generic_142901-12Machine: i86pcInstance name: nbbsprd1
Redo thread mounted by this instance: 1
Oracle process number: 130Unix 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.170dbkedDefDump(): 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: 0x3proc=0x5fff8fd60, name=session, file=ksu.h LINE:11467 ID:, pg=0
(session) sid: 1203 ser: 16390 trans: 0x0, creator: 0x5fff8fd60flags: (0x41) USR/- flags_idl: (0x0) -/-/-/-/-/-flags2: (0x40008) -/-DID: , short-term DID:txn branch: 0x0oct: 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
|
本文转自maclean_007 51CTO博客，原文链接:http://blog.51cto.com/maclean/1277549