ORA-3137(12333)错误

又是一个内部错误，而这个错误在9i以前似乎并不常见。

在alert中错误信息如下：

Errors in file /db/oracle/app/oracle/diag/rdbms/ora00/ora001/trace/ora001_ora_4262.trc:
ORA-03137: TTC 协议内部错误: [12333] [5] [113] [105] [] [] [] []

而对应的trace文件中包含的信息为：

Trace file /db/oracle/app/oracle/diag/rdbms/ora00/ora001/trace/ora001_ora_4262.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /db/oracle/app/oracle/11.1.0
System name: SunOS
Node name: f232
Release: 5.10
Version: Generic_141414-07
Machine: sun4u
Instance name: ora001
Redo thread mounted by this instance: 1
Oracle process number: 266
Unix process pid: 4262, image: oracle@f232

*** 2010-12-01 17:14:11.542
*** SESSION ID:(567.54793) 2010-12-01 17:14:11.542
*** CLIENT ID:() 2010-12-01 17:14:11.542
*** SERVICE NAME:(ora00) 2010-12-01 17:14:11.542
*** MODULE NAME:(JDBC Thin Client) 2010-12-01 17:14:11.542
*** ACTION NAME:() 2010-12-01 17:14:11.542

--- PROTOCOL VIOLATION DETECTED ---
----- Dump Cursor sql_id=47uwpqb1dfj2k xsc=0xffffffff7d0570c0 cur=0xffffffff7d041b10 -----
Dump Parent Cursor sql_id=47uwpqb1dfj2k phd=0x44773c678 plk=0x445a4ca68
sqltxt(0x44773c678)=select A.dataObjectId,A.relation ObjectIdRelation,B.dataObjectName,B.deptId,B.relation DimensionRelation,B.typeId,B.systemId from t_DataObjectOfUserPermission A,t_DataObject B where A.userId=:1 and A.permissionId=:2 and A.dataObjectId=B.dataObjectId
hash=1161a686a228a7e243eb95b2c2d74452
parent=0x420b95408 maxchild=256 plk=0x445a4ca68 ppn=n
cursor instantiation=0xffffffff7d0570c0 used=1291194851 exec_id=16976012 exec=7
child#255(0x445130ec8) pcs=0x42128feb0
clk=0x445a4c8e0 ci=0x42128fb80 pn=0x445e990b8 ctx=0x4b3ad46f8
kgsccflg=1 llk[0xffffffff7d0570c8,0xffffffff7d0570c8] idx=53
xscflg=c0110676 fl2=5d000009 fl3=42222008 fl4=180
sharing failure(s)=100004000
----- Bind Info (kkscoacd) -----
Bind#0
acdty=01 mxl=32(10) mxlc=00 mal=00 scl=00 pre=00
acflg=03 fl2=1000010 frm=01 csi=852 siz=64 ff=0
kxsbbbfp=ffffffff7ddb1b90 bln=32 avl=00 flg=05
Bind#1
acdty=01 mxl=32(24) mxlc=00 mal=00 scl=00 pre=00
acflg=03 fl2=1000010 frm=01 csi=852 siz=0 ff=32
kxsbbbfp=ffffffff7ddb1bb0 bln=32 avl=00 flg=01
Frames pfr 0xffffffff7ddb1f78 siz=112928 efr 0xffffffff7ddb1e58 siz=112912
kxscphp=0xffffffff7d0507e8 siz=984 inu=488 nps=424
kxscbhp=0xffffffff7d050248 siz=984 inu=240 nps=88
kxscwhp=0xffffffff7d050338 siz=4056 inu=880 nps=72
Starting SQL statement dump
SQL Information
user_id=92 user_name=RBAC module=JDBC Thin Client action=
sql_id=47uwpqb1dfj2k plan_hash_value=-500536361 problem_type=4
----- Current SQL Statement for this session (sql_id=47uwpqb1dfj2k) -----
select A.dataObjectId,A.relation ObjectIdRelation,B.dataObjectName,B.deptId,B.relation DimensionRelation,B.typeId,B.systemId from t_DataObjectOfUserPermission A,t_DataObject B where A.userId=:1 and A.permissionId=:2 and A.dataObjectId=B.dataObjectId
sql_text_length=251
sql=select A.dataObjectId,A.relation ObjectIdRelation,B.dataObjectName,B.deptId,B.relation DimensionRelation,B.typeId,B.systemId from t_DataObjectOfUserPermission A,t_DataObject B where A.userId=:1 and A.permissionId=:2 and A.dataObjectId=B.dataObjectId
====================== END SQL Statement Dump ======================
ttcdrvdmp: msg-5 ln-971 reporting 12333

--------------------
PROTOCOL VIOLATION
--------------------
-----Page before-----
109B37180 11 69 00 01 01 01 01 03 03 5E 00 02 80 29 00 01 [.i.......^...)..]
109B37190 01 FA 01 01 0D 00 00 00 00 04 7F FF FF FF 01 01 [................]
109B371A0 02 00 00 00 00 00 00 00 FE 40 73 65 6C 65 63 74 [.........@select]
109B371B0 20 41 2E 64 61 74 61 4F 62 6A 65 63 74 49 64 2C [ A.dataObjectId,]
109B371C0 41 2E 72 65 6C 61 74 69 6F 6E 20 4F 62 6A 65 63 [A.relation Objec]
109B371D0 74 49 64 52 65 6C 61 74 69 6F 6E 2C 42 2E 64 61 [tIdRelation,B.da]
109B371E0 74 61 4F 62 6A 65 63 74 4E 61 40 6D 65 2C 42 2E [taObjectNa@me,B.]
109B371F0 64 65 70 74 49 64 2C 42 2E 72 65 6C 61 74 69 6F [deptId,B.relatio]
109B37200 6E 20 44 69 6D 65 6E 73 69 6F 6E 52 65 6C 61 74 [n DimensionRelat]
109B37210 69 6F 6E 2C 42 2E 74 79 70 65 49 64 2C 42 2E 73 [ion,B.typeId,B.s]
109B37220 79 73 74 65 6D 49 64 20 66 72 6F 40 6D 20 74 5F [ystemId fro@m t_]
109B37230 44 61 74 61 4F 62 6A 65 63 74 4F 66 55 73 65 72 [DataObjectOfUser]
109B37240 50 65 72 6D 69 73 73 69 6F 6E 20 41 2C 74 5F 44 [Permission A,t_D]
109B37250 61 74 61 4F 62 6A 65 63 74 20 42 20 77 68 65 72 [ataObject B wher]
109B37260 65 20 41 2E 75 73 65 72 49 64 3D 3A 3A 31 20 61 [e A.userId=::1 a]
109B37270 6E 64 20 41 2E 70 65 72 6D 69 73 73 69 6F 6E 49 [nd A.permissionI]
109B37280 64 3D 3A 32 20 61 6E 64 20 41 2E 64 61 74 61 4F [d=:2 and A.dataO]
109B37290 62 6A 65 63 74 49 64 3D 42 2E 64 61 74 61 4F 62 [bjectId=B.dataOb]
109B372A0 6A 65 63 74 49 64 20 00 01 01 00 00 00 00 00 00 [jectId .........]
109B372B0 01 01 00 00 00 00 00 01 03 00 00 01 0A 00 01 10 [................]
109B372C0 00 00 02 03 54 01 00 01 03 00 00 01 18 00 01 10 [....T...........]
109B372D0 00 00 02 03 54 01 00 07 05 71 69 [....T....qi]
-----Current Page-----
nsbfdbpt 0x109b37180
ifccrcp = 0x109b372db, ifccrcl = 0x109b372eb
buffer length = 16
109B372D0 61 6E 71 0C 31 [anq.1]
109B372E0 31 5F 30 30 30 35 5F 30 30 31 36 [1_0005_0016]
hstflg: 0x40002d91
hstcflg: 0x00000000
hstpro: 6
hstccs: (DESCRIPTION=(address=(protocol=tcp)(host=10.1.4.203)(port=1521))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(server=dedicated)(service_name=ora00)))
--- dump of hsttti ---
109936A60 00 04 01 0C 0E 09 0B 0F [........]
109936A70 04 0A 03 03 01 00 00 0A 00 00 00 00 00 00 00 01 [................]
109936A80 01 05 05 05 05 05 05 05 06 06 00 00 00 00 00 07 [................]
109936A90 03 03 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
109936AA0 00 00 13 00 00 00 00 00 00 00 00 00 0C 00 00 00 [................]
109936AB0 00 00 14 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
109936AC0 00 00 00 0D 00 00 11 11 04 09 00 00 01 01 05 00 [................]
109936AD0 22 00 12 00 13 13 15 15 17 17 17 17 21 03 00 00 ["...........!...]
109936AE0 03 13 13 13 00 00 00 00 00 00 00 00 00 00 00 00 [................]
109936AF0 00 00 00 00 00 00 00 00 00 00 04 00 00 00 00 00 [................]
109936B00 0F 0F 0F 1F 20 00 00 00 00 00 00 00 00 00 00 00 [.... ...........]
109936B10 00 00 00 00 0F 00 00 00 00 00 00 00 01 01 01 01 [................]
109936B20 2A 00 00 2A 2A 2B 2B 00 00 00 00 23 23 23 00 00 [*..**++....###..]
109936B30 00 00 00 00 00 00 00 00 22 00 00 00 00 00 00 00 [........".......]
109936B40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 35 [...............5]
109936B50 2A 05 00 00 00 00 00 00 00 13 00 00 00 00 00 00 [*...............]
109936B60 00 00 00 00 00 00 00 36 00 00 00 00 00 00 00 00 [.......6........]
109936B70 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
109936B80 00 00 00 00 00 00 00 00 00 00 03 01 03 03 03 00 [................]
109936B90 00 00 03 03 03 03 03 03 03 03 03 03 03 03 03 03 [................]
109936BA0 03 03 00 03 03 03 03 03 03 03 03 03 00 00 00 03 [................]
109936BB0 03 03 00 03 00 03 03 03 03 03 03 03 03 03 03 01 [................]
109936BC0 00 03 03 00 03 03 00 00 00 00 03 03 00 00 00 03 [................]
109936BD0 00 00 00 03 00 00 00 00 00 00 00 00 00 00 00 00 [................]
109936BE0 00 00 00 00 03 03 03 03 03 03 03 03 03 03 03 03 [................]
109936BF0 00 03 03 03 03 03 03 03 03 03 00 00 03 03 03 03 [................]
109936C00 00 00 00 00 00 03 03 03 03 03 03 03 03 03 03 03 [................]
109936C10 03 03 03 03 00 03 03 03 03 03 00 00 00 00 00 00 [................]
109936C20 00 00 00 00 00 00 00 00 00 00 03 00 00 00 00 00 [................]
109936C30 00 00 24 25 26 27 28 1E 00 00 00 03 00 00 00 00 [..$%&'(.........]
109936C40 00 00 00 00 00 00 00 00 00 00 00 2C 00 00 00 00 [...........,....]
109936C50 00 00 00 00 00 03 00 00 00 00 00 00 00 00 00 00 [................]
109936C60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
109936C70 00 00 00 00 00 00 00 00 00 00 00 00 1A 00 00 00 [................]
109936C80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
109936C90 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
109936CA0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
109936CB0 00 00 [..]
ttclxlccst: 852
ttclxrccst: 871
ttclxlncst: 2000
ttclxrncst: 2000
ttclxccl2nr: 3
ttclxccn2lr: 2
ttclxncl2nr: 1
ttclxncn2lr: 1
ttclxrccminbpc: 1
ttclxrccmaxbpc: 3
ttclxrncminbpc: 2
ttclxrncmaxbpc: 2
ttclxflags: 0x03
prev funcode: 0x5e

*** 2010-12-01 17:14:11.544
----- Error Stack Dump -----
ORA-03137: TTC 协议内部错误: [12333] [5] [113] [105] [] [] [] []
----- Current SQL Statement for this session (sql_id=47uwpqb1dfj2k) -----
select A.dataObjectId,A.relation ObjectIdRelation,B.dataObjectName,B.deptId,B.relation DimensionRelation,B.typeId,B.systemId from t_DataObjectOfUserPermission A,t_DataObject B where A.userId=:1 and A.permissionId=:2 and A.dataObjectId=B.dataObjectId

----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst1()+96 CALL skdstdst() FFFFFFFF7FFFA940 ?
000335800 ?
FFFFFFFF7FFD24C8 ?
000000000 ?
FFFFFFFF7FFD24C8 ?
1095E7FB0 ?
ksedst()+56 CALL ksedst1() 000000000 ? 000000001 ?
00010992B ? 000109800 ?
109923000 ? 000109923 ?
dbkedDefDump()+1388 CALL ksedst() 000000000 ? 000000000 ?
000000000 ? 000000000 ?
10992B000 ? 00010992B ?
opiierr()+316 CALL ksedmp() 00010887F ? 000109800 ?
10992B000 ? 10887F000 ?
000108800 ? 10993D000 ?
opitsk()+10440 CALL opiierr() 000000000 ? 000000001 ?
00010915B ? 000000001 ?
00000229C ? 000000005 ?
opiino()+992 CALL opitsk() 000000000 ? 00000005E ?
10858C89C ? 00000000A ?
109936718 ? 10915A1B0 ?
opiodr()+1344 PTR_CALL 0000000000000000 000380000 ? 109936788 ?
000000000 ? 000A54563 ?
00000009D ?
FFFFFFFF7FFFF158 ?
opidrv()+1060 CALL opiodr() 1085A8000 ? 000000004 ?
000000000 ? 000109800 ?
1085A7000 ? 109936000 ?
sou2o()+76 CALL opidrv() 000000000 ? 1099242E8 ?
00000003C ? 000109800 ?
000000000 ? 109924498 ?
main()+648 CALL sou2o() FFFFFFFF7FFFF130 ?
00000003C ? 000000004 ?
FFFFFFFF7FFFF158 ?
10928B000 ? 00010928B ?
_start()+380 CALL main() 000108E71 ?
FFFFFFFF7FFFF288 ?
000000000 ? 000000000 ?
FFFFFFFF7FFFF298 ?
000000002 ?

--------------------- Binary Stack Dump ---------------------

这是11.1.0.6上的一个bug：ID 752297.1，metalink文档ID 752297.1描述了这个，利用11.1.0.6的JDBC瘦客户端驱动访问11.1.0.6数据库可能导致这个错误。

解决这个问题需要将数据库版本升级到11.1.0.7，但是Oracle也提到，即使升级到11.1.0.7也不能完全避免这个错误，除非升级到11.2以上的版本，否则在错误日志中仍然可以偶尔发现这个错误信息。

                          ----引自 yangtingkun

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8362857/viewspace-712596/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8362857/viewspace-712596/