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

环境说明：
IBM-AIX6服务器
oracle11g11.2.0.1.0数据库

出现错误症状：

Java代码  

1. Dump file /cnbbs01/app/oracle/diag/rdbms/nbbsprd1/nbbsprd1/incident/incdir_373041/nbbsprd1_ora_24754_i373041.trc  
2. Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production  
3. ORACLE_HOME = /cnbbs01/app/oracle/product/11.2.0/db_1  
4. System name: SunOS  
5. Node name: ut06db03  
6. Release: 5.10  
7. Version: Generic_142901-12  
8. Machine: i86pc  
9. Instance name: nbbsprd1  
10. Redo thread mounted by this instance: 1  
11. Oracle process number: 130  
12. Unix process pid: 24754, image: oracle@ut06db03  
13. *** 2010-08-25 02:01:19.169  
14. *** SESSION ID:(1203.16390) 2010-08-25 02:01:19.169  
15. *** CLIENT ID:() 2010-08-25 02:01:19.169  
16. *** SERVICE NAME:(SYS$USERS) 2010-08-25 02:01:19.169  
17. *** MODULE NAME:() 2010-08-25 02:01:19.169  
18. *** ACTION NAME:() 2010-08-25 02:01:19.169  
19.   
20. Dump continued from file: /cnbbs01/app/oracle/diag/rdbms/nbbsprd1/nbbsprd1/trace/nbbsprd1_ora_24754.trc  
21. ORA-03137: TTC protocol internal error : [12333] [11] [120] [110] [] [] [] []  

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] [] [] [] []

Java代码  

1. ========= Dump for incident 373041 (ORA 3137 [12333]) ========  
2.   
3. *** 2010-08-25 02:01:19.170  
4. dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)  
5. ----- Current SQL Statement for this session (sql_id=8ath6p5cx60q2) -----  
6. 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  
7.   
8. ----- Call Stack Trace -----  
9. ksedst1 <- ksedst <- dbkedDefDump <- ksedmp <- dbgexPhaseII  
10. <- dbgexProcessError <- dbgePostErrorKGE <- 1438 <- opiierr <- opitsk  
11. <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real  
12. <- ssthrdmain <- main <- start  
13. ----------------------------------------  
14. SO: 0x5fb961a98, type: 4, owner: 0x5fff8fd60, flag: INIT/-/-/0x00 if: 0x3 c: 0x3  
15. proc=0x5fff8fd60, name=session, file=ksu.h LINE:11467 ID:, pg=0  
16. (session) sid: 1203 ser: 16390 trans: 0x0, creator: 0x5fff8fd60  
17. flags: (0x41) USR/- flags_idl: (0x0) -/-/-/-/-/-  
18. flags2: (0x40008) -/-  
19. DID: , short-term DID:  
20. txn branch: 0x0  
21. oct: 3, prv: 0, sql: 0x5b08829c0, psql: 0x5d799a460, user: 67/NBBS_MTS  
22. ksuxds FALSE at location: 0  
23. service name: SYS$USERS  
24. client details:  
25. O/S info: user: , term: , ospid: 1234  
26. machine: ut06nbbs01 program:  
27. Current Wait Stack:  

========= 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:

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

这个case通过升级jdbc驱动解决了 。---以上的内容来源于互联网，不过没经过验证

 

此篇文章的问题是QQ群里的一位网友提出RAC问题。问题描述如下：

ORA-03137:  TTC  protocol  internal  error  :  [3120]  []  []  []  []  []  []  []
Incident  details  in:  /u01/db/11.2.0/app/diag/rdbms/orcl/orcl1/incident/incdir_833796/orcl1_ora_40108180_i833796.trc
Thu  Apr  25  06:22:18  2013
Dumping  diagnostic  data  in  directory=[cdmp_20130425062218],  requested  by  (instance=1,  osid=40108180),  summary=[incident=833796].
Thu  Apr  25  06:22:18  2013
Errors  in  file  /u01/db/11.2.0/app/diag/rdbms/orcl/orcl1/trace/orcl1_ora_35586178.trc    (incident=834316):

 

下边的TRACE文件：

Trace  file  /u01/db/11.2.0/app/diag/rdbms/orcl/orcl1/trace/orcl1_ora_35586178.trc
Oracle  Database  11g  Enterprise  Edition  Release  11.2.0.3.0  -  64bit  Production
With  the  Partitioning,  Real  Application  Clusters,  Automatic  Storage  Management,  OLAP,
Data  Mining  and  Real  Application  Testing  options
ORACLE_HOME  =  /u01/db/11.2.0/db
System  name:        AIX
Node  name:            oradb1
Release:                1
Version:                6
Machine:                00C55FF64C00
Instance  name:  orcl1
Redo  thread  mounted  by  this  instance:  1
Oracle  process  number:  206
Unix  process  pid:  35586178,  image:  oracle@oradb1


***  2013-04-25  06:22:18.580
***  CLIENT  ID:()  2013-04-25  06:22:18.580
***  SERVICE  NAME:()  2013-04-25  06:22:18.580
***  MODULE  NAME:()  2013-04-25  06:22:18.580
***  ACTION  NAME:()  2013-04-25  06:22:18.580
 
Incident  834316  created,  dump  file:  /u01/db/11.2.0/app/diag/rdbms/orcl/orcl1/incident/incdir_834316/orcl1_ora_35586178_i834316.trc
ORA-03137:  TTC  protocol  internal  error  :  [3120]  []  []  []  []  []  []  []

ttcdrvdmplocation:  msg-0  ln-252  reporting  3137
Dumping  'Buffer  dump  info:'  addr=0x110d5b960  size=5  bytes
Dump  of  memory  from  0x110d5b960  to  0x110d5b968
110D5B960  037602B0  2A960806                                        [.v..*...]               
Dumping  'Buffer  dump  info:'  addr=0x110d5b965  size=208  bytes
Dump  of  memory  from  0x110d5b964  to  0x110d5ba38
110D5B960                    2A960806  00000021  000000AC            [*......!....]
110D5B970  29B3BF05  00000054  26B3BF60  2CB3BF03    [)......T&..`,...]
110D5B980  7379731A  0000000D  41555448  5F544552    [sys.....AUTH_TER]
110D5B990  4D494E41  4C0C0000  00067074  732F3133    [MINAL.....pts/13]
110D5B9A0  00000000  1E000000  0F415554  485F5052    [.........AUTH_PR]
110D5B9B0  4F475241  4D5F4E4D  36000000  1B73716C    [OGRAM_NM6....sql]
110D5B9C0  706C7573  4068656E  69636573  2028544E    [plus@henices  (TN]
110D5B9D0  53205631  2D563329  00000000  18000000    [S  V1-V3)........]
110D5B9E0  0C415554  485F4D41  4348494E  450E0000    [.AUTH_MACHINE...]
110D5B9F0  00076865  6E696365  73000000  00100000    [..henices.......]
110D5BA00  00084155  54485F50  49440A00  00000531    [..AUTH_PID.....1]
110D5BA10  38323534  00000000  10000000  08415554    [8254.........AUT]
110D5BA20  485F5349  440E0000  00076865  6E696365    [H_SID.....henice]