jimmy 发表于 2013-5-9 16:22:34

ORA-03137，请指教

OS:AIX 6.1 64BIT
DB:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

在alert报错
ORA-03137: TTC 协议内部错误: [] [] [] []

日志在附件。请各位老师指点迷经，谢谢

Maclean Liu(刘相兵 发表于 2013-5-13 11:36:15

prev funcode: 0x5e
Incident 61226 created, dump file: /db/app/oracle/diag/rdbms/bdlms/bdlms/incident/incdir_61226/bdlms_ora_23396358_i61226.trc
ORA-03137: TTC 协议内部错误: [] [] [] []

ttcdrvdmplocation: msg-0 ln-252 reporting 3137
Dumping 'Buffer dump info:' addr=0x110caa000 size=223 bytes
Dump of memory from 0x110caa000 to 0x110caa0e0
110CAA000 11690001 01010104 035E0002 80290001  [.i.......^...)..]
110CAA010 018F0101 0D000000 00047FFF FFFF0101  [................]
110CAA020 01000000 00000000 FE407365 6C656374  [.........@select]
110CAA030 20636F75 6E74282A 29206173 2079305F  [ count(*) as y0_]
110CAA040 2066726F 6D20504F 53545F41 5554484F  [ from POST_AUTHO]
110CAA050 52495459 20746869 735F2069 6E6E6572  
110CAA060 206A6F69 6E204155 5448404F 52495459  [ join AUTH@ORITY]
110CAA070 20617574 686F7269 7479315F 206F6E20  [ authority1_ on ]
110CAA080 74686973 5F2E4155 545F4944 3D617574  
110CAA090 686F7269 7479315F 2E415554 5F494420  
110CAA0A0 77686572 65207468 69735F0F 2E504F53  
110CAA0B0 5F494420 696E2028 3A312900 01010000  
110CAA0C0 00000000 01010000 00000001 03000001  [................]
110CAA0D0 40000110 00000203 54010007 20343032  [@.......T... 402]
Dumping 'Buffer dump info:' addr=0x110caa0df size=30 bytes
Dump of memory from 0x110caa0dc to 0x110caa100
110CAA0D0                            20343032              [ 402]
110CAA0E0 38383063 64326532 64323933 32303132  
110CAA0F0 65326432 61303766 30303030 325F4944  
Dumping 'Buffer dump info:' addr=0x110cd22c0 size=120 bytes
Dump of memory from 0x110cd22c0 to 0x110cd2338
110CD22C0 10178B93 03E31B1B 1E6D9FE3 A4CA0ACA  [.........m......]
110CD22D0 FE067871 05091034 2C011601 01510200  [..xq...4,....Q..]
110CD22E0 00000116 00000000 00000001 03010903  [................]
110CD22F0 59305F00 00000107 07787105 0910342C  
110CD2300 00021FE8 08010604 23528A57 00010200  [........#R.W....]
110CD2310 00000000 040202A0 00000000 0102011C  [................]
110CD2320 03000000 00000309 2C470109 00031231  [........,G.....1]
110CD2330 75000000 00000101                            
hstflg:  0x40202d91
hstcflg: 0x00000000
hstpro:  6
hstccs:  (DESCRIPTION=(CONNECT_DATA=(SID=bdlms)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=)))(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.18.10)(PORT=1521)))
--- dump of hsttti ---

Maclean Liu(刘相兵 发表于 2013-5-13 11:36:32

上传/db/app/oracle/diag/rdbms/bdlms/bdlms/incident/incdir_61226/bdlms_ora_23396358_i61226.trc


确定jdbc使用的是什么版本

jimmy 发表于 2013-5-13 14:47:26

Maclean Liu(刘相兵 发表于 2013-5-13 11:36 static/image/common/back.gif
上传/db/app/oracle/diag/rdbms/bdlms/bdlms/incident/incdir_61226/bdlms_ora_23396358_i61226.trc




附件。刘大能大概说下思路吗？

Maclean Liu(刘相兵 发表于 2013-5-14 21:00:48

*** 2013-05-09 15:51:43.922
*** SESSION ID:(114.29911) 2013-05-09 15:51:43.922
*** CLIENT ID:() 2013-05-09 15:51:43.922
*** SERVICE NAME:(SYS$USERS) 2013-05-09 15:51:43.922
*** MODULE NAME:(JDBC Thin Client) 2013-05-09 15:51:43.922
*** ACTION NAME:() 2013-05-09 15:51:43.922

Dump continued from file: /db/app/oracle/diag/rdbms/bdlms/bdlms/trace/bdlms_ora_23396358.trc
ORA-03137: TTC 协议内部错误: [] [] [] []

========= Dump for incident 61226 (ORA 3137 ) ========

*** 2013-05-09 15:51:43.923
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=9zsx4t85cpzh6) -----
select count(*) as y0_ from POST_AUTHORITY this_ inner join AUTHORITY authority1_ on this_.AUT_ID=authority1_.AUT_ID where this_.POS_ID in (:1)



11.2.0.1 +JDBC +  3137 12333

opiodr=>opiino=>opitsk=>报错

Maclean Liu(刘相兵 发表于 2013-5-14 21:04:03

      SO: 0x70000009e82aa28, type: 74, owner: 0x7000000c731ed10, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
       proc=0x7000000c81f3ba8, name=LIBRARY OBJECT LOCK, file=kgl.h LINE:8349 ID:, pg=0

      LibraryObjectLock:  Address=9e82aa28 Handle=c9d4a040 Mode=N CanBeBrokenCount=1 Incarnation=1 ExecutionCount=1         
        
        User=c731ed10 Session=c731ed10 ReferenceCount=1 Flags=CNB/ SavepointNum=518b558f
      LibraryHandle:  Address=c9d4a040 Hash=acafe06 LockMode=N PinMode=0 LoadLockMode=0 Status=VALD
        ObjectName:  Name=        select count(*) as y0_ from POST_AUTHORITY this_ inner join AUTHORITY authority1_ on this_.AUT_ID=authority1_.AUT_ID where this_.POS_ID in (:1)

          FullHashValue=8b9303e31b1b1e6d9fe3a4ca0acafe06 Namespace=SQL AREA(00) Type=CURSOR(00) Identifier=181075462 OwnerIdn=136
        Statistics:  InvalidationCount=61 ExecutionCount=5612 LoadCount=191 ActiveLocks=1 TotalLockCount=4524 TotalPinCount=1
        Counters:  BrokenCount=1 RevocablePointer=1 KeepDependency=6 KeepHandle=6 BucketInUse=4504 HandleInUse=4504
        Concurrency:  DependencyMutex=c9d4a0f0(0, 0, 0, 0) Mutex=c9d4a168(0, 54738, 0, 0)
        Flags=RON/PIN/TIM/PN0/DBN/
        WaitersLists:  
          Lock=c9d4a0d0
          Pin=c9d4a0e0
        Timestamp:  Current=11-14-2012 17:20:15
        LibraryObject:  Address=c1b5e720 HeapMask=0000-0001-0001 Flags=EXS Flags2= PublicFlags=
          ChildTable:  size='16'
            Child:  id='0' Table=c1b5f5d0 Reference=c1b5f070 Handle=c9d49e40
            Child:  id='1' Table=c1b5f5d0 Reference=c1b5f3b0 Handle=9eaa94a0
            Child:  id='2' Table=c1b5f5d0 Reference=859562d8 Handle=9edd4bc8
            Child:  id='3' Table=c1b5f5d0 Reference=859565d8 Handle=c97c3388
            Child:  id='4' Table=c1b5f5d0 Reference=859568d8 Handle=9ef16628
            Child:  id='5' Table=c1b5f5d0 Reference=85956c30 Handle=c9738278
            Child:  id='6' Table=c1b5f5d0 Reference=953909a8 Handle=9e69ee88
            Child:  id='7' Table=c1b5f5d0 Reference=95390ca8 Handle=9e704088
            Child:  id='8' Table=c1b5f5d0 Reference=8586c2d8 Handle=82ba0e50
            Child:  id='9' Table=c1b5f5d0 Reference=c16d57e8 Handle=c95f04d8
            Child:  id='10' Table=c1b5f5d0 Reference=901a58d0 Handle=9e6a4b58
        NamespaceDump:  
          Parent Cursor:  sql_id=9zsx4t85cpzh6 parent=7000000c1b5e808 maxchild=11 plk=y ppn=n
            Current Cursor Sharing Diagnostics Nodes:  
              Child Node: 3  ID=40 reason=Bind mismatch(33) size=2x4
                init ranges in first pass: 1
                selectivity: 0
              Child Node: 6  ID=40 reason=Bind mismatch(33) size=2x4

Maclean Liu(刘相兵 发表于 2013-5-14 21:05:14


1、 换jDBC版本

2、 问题发生时 alter system flush shared_pool;

jimmy 发表于 2013-5-15 09:34:08

Maclean Liu(刘相兵 发表于 2013-5-14 21:05 static/image/common/back.gif
1、 换jDBC版本

2、 问题发生时 alter system flush shared_pool;

确实是jdbc版本问题。前段时间搞整pentaho的时候替换过。

jimmy 发表于 2013-5-15 09:34:35

Maclean Liu(刘相兵 发表于 2013-5-14 21:05 static/image/common/back.gif
1、 换jDBC版本

2、 问题发生时 alter system flush shared_pool;

问题已解决   THX

diyindo 发表于 2013-12-12 15:33:11

升级JDBC-driver ，是直接在官网下载jar包 copy到ORACLE_HOME/JDBC/LIB 下吗

Liu Maclean(刘相兵 发表于 2013-12-15 19:18:54

diyindo 发表于 2013-12-12 15:33 static/image/common/back.gif
升级JDBC-driver ，是直接在官网下载jar包 copy到ORACLE_HOME/JDBC/LIB 下吗

不是

diyindo 发表于 2013-12-16 11:13:39

Liu Maclean(刘相兵 发表于 2013-12-15 19:18 static/image/common/back.gif
不是

那是我理解错误，那该如何升级JDBC-Driver？请老师指点
页: [1]
查看完整版本: ORA-03137，请指教