Oracle ORA-03137: TTC protocol internal error : [12333] 故障分析
程序通过JDBC 连接
数据库异常，报 ORA-03137[12333]的错误。
当前程序的JDBC 驱动版本：ojdbc16-11.2.0.1.0.jar
数据库版本： 11.2.0.3
一. Log 信息
1.1 alert log
TNS-12637: Packet receive failed
ns secondary err code: 12532
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid(28518) as a result of ORA-609
Fri Aug 09 15:41:20 2013
Errors in file /u01/app/oracle/diag/rdbms/tserpdb/tserpdb/trace/tserpdb_ora_28329.trc (incident=60746):
ORA-03137: TTC protocolinternal error : [12333] [19] [3] [14] [] [] [] []
Incident details in:/u01/app/oracle/diag/rdbms/tserpdb/tserpdb/incident/incdir_60746/tserpdb_ora_28329_i60746.trc
Fri Aug 09 15:41:21 2013
Sweep [inc][60746]: completed
Sweep [inc2][60746]: completed
Fri Aug 09 15:41:21 2013
Dumping diagnostic data indirectory=[cdmp_20130809154121], requested by (instance=1, osid=28329),summary=[incident=60746].
Fri Aug 09 15:59:42 2013
1.2 trace 文件
Dump file/u01/app/oracle/diag/rdbms/tserpdb/tserpdb/incident/incdir_60746/tserpdb_ora_28329_i60746.trc
Oracle Database 11g Enterprise EditionRelease 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic StorageManagement, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME =/u01/app/oracle/product/11.2.0/dbhome_1
System name: Linux
Node name: sh-tsiagent-003180
Release: 2.6.18-308.el5
Version: #1SMP Tue Feb 21 20:06:06 EST 2012
Machine: x86_64
Instance name: tserpdb
Redo thread mounted by this instance: 1
Oracle process number: 92
Unix process pid: 28329, image:oracle@sh-tsiagent-003180
*** 2013-08-09 15:41:20.138
*** SESSION ID:(1911.53519) 2013-08-0915:41:20.138
*** CLIENT ID:() 2013-08-09 15:41:20.138
*** SERVICE NAME:(tsdb3180.develop)2013-08-09 15:41:20.138
*** MODULE NAME:(JDBC Thin Client)2013-08-09 15:41:20.138
*** ACTION NAME:() 2013-08-09 15:41:20.138
Dump continued from file:/u01/app/oracle/diag/rdbms/tserpdb/tserpdb/trace/tserpdb_ora_28329.trc
ORA-03137: TTC protocol internal error :[12333] [19] [3] [14] [] [] [] []
========= Dump for incident 60746 (ORA 3137[12333]) ========
*** 2013-08-09 15:41:20.139
dbkedDefDump(): Starting incident defaultdumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for thissession (sql_id=35tr4jfq0x3jw) -----
select mpzone0_.ZONEID as ZONEID83_0_,mpzone0_.AREACODE as AREACODE83_0_, mpzone0_.CARDTYPE as CARDTYPE83_0_,mpzone0_.city as city83_0_, mpzone0_.province as province83_0_ fromIAGENT.MPZONE mpzone0_ where mpzone0_.ZONEID=:1
----- Call Stack Trace -----
calling call entry argument values in hex
location type point ( means dubious value)
-------------------- ---------------------------- ----------------------------
skdstdst()+36 call kgdsdst() 000000000 000000000
7FFF91403248 000000001
000000001 000000002
…
__libc_start_main() call main() 000000002 7FFF91414458
+244 000000001 000000000
009B910C0 000000000