ora-3137故障处理

数据库版本：11.2.0.3
操作系统：aix 7.1
报错：
ORA-03137: TTC protocol internal error : [3149] [] [] [] [] [] [] []
ORA-03149: Invalid Oracle error code

要知道Oracle 11g中将很多以前版本中的ORA-0060换成了ORA-03137，甚至连第一个参数都输通用的，再看下错误信息TTC协议，所谓的TTC协议就是Oracle客户端和server端通信的协议。
报改错误首先想到了客户端和服务器端Oracle版本的问题，问了一下开发人员，客户端版本是9.2.0.7。这显然是问题的原因。
其中参数[3139]的含义一般是由于客户端视图绑定一个不可用的值，或者一个FLOAT值，当客户端报错ora-1424，server端就会报出ora-3137。

dump分析：通过分析，报错的时候出现以下信息代码
 [...=update TISSU EGROUP  set F_AL LOTRATIO=:b0 whe re C_FUNDCODE=:b]
从而验证了猜测。
*** 2013-12-10 22:07:55.142
*** SESSION ID:(937.3) 2013-12-10 22:07:55.142
*** CLIENT ID:() 2013-12-10 22:07:55.142
*** SERVICE NAME:(SYS$USERS) 2013-12-10 22:07:55.142
*** MODULE NAME:(hsmpas@TA4 (TNS V1-V3)) 2013-12-10 22:07:55.142
*** ACTION NAME:() 2013-12-10 22:07:55.142
 
Incident 108993 created, dump file: /oracle/diag/rdbms/tadb/tadb/incident/incdir_108993/tadb_ora_40108074_i108993.trc
ORA-03137: TTC protocol internal error : [3149] [] [] [] [] [] [] []
ORA-03149: Invalid Oracle error code


ttcdrvdmplocation: msg-0 ln-252 reporting 3137
Dumping 'Buffer dump info:' addr=0x110939ac0 size=395 bytes
Dump of memory from 0x110939ac0 to 0x110939c4c
110939AC0 035E5300 00802900 000000FF FFFFFFFF  [.^S...).........]
110939AD0 FFFFFE00 00003D00 000000FF FFFFFFFF  [......=.........]
110939AE0 FFFFFE00 00000D00 000000FF FFFFFFFF  [................]
110939AF0 FFFFFEFF FFFFFFFF FFFFFE00 00000000  [................]
110939B00 00000100 00000000 000000FF FFFFFFFF  [................]
110939B10 FFFFFE00 00000200 00000000 00000000  [................]
110939B20 000000FF FFFFFFFF FFFFFE00 00000000  [................]
110939B30 000000FF FFFFFFFF FFFFFEFF FFFFFFFF  [................]
110939B40 FFFFFE00 00000112 E15AB800 00000000  [.........Z......]
110939B50 000000FF FFFFFFFF FFFFFEFF FFFFFFFF  [................]
110939B60 FFFFFE00 00000000 00000000 00000000  [................]
110939B70 00000000 00000000 00000000 00000000  [................]
110939B80 0000003D 75706461 74652054 49535355  [...=update TISSU]
110939B90 4547524F 55502020 73657420 465F414C  [EGROUP  set F_AL]
110939BA0 4C4F5452 4154494F 3D3A6230 20776865  [LOTRATIO=:b0 whe]
110939BB0 72652043 5F46554E 44434F44 453D3A62  [re C_FUNDCODE=:b]
110939BC0 31000000 02000000 01000000 00000000  [1...............]
110939BD0 00000000 00000000 00000000 00000000  [................]
110939BE0 02000000 00000000 00000000 00000000  [................]
110939BF0 00000000 00010200 00000000 00160000  [................]
110939C00 00000000 00000000 00000000 00000000  [................]
110939C10 00000000 00000000 00000000 00000101  [................]
110939C20 00000000 00000600 00000000 00000000  [................]
110939C30 00000000 00000000 00000003 54010000  [............T...]
110939C40 00000000 00000007 FF059206           [............]    
Dumping 'Buffer dump info:' addr=0x110939c4b size=7 bytes
Dump of memory from 0x110939c48 to 0x110939c54
110939C40                   FF059206 34384130          [....48A0]
110939C50 38310102                             [81..]            
hstflg:  0x40202d89
hstcflg: 0x00000000
hstpro:  6
hstccs:  (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/tadb/oracle/icbccs/bin/oracle)(ARGV0=oracletadb)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=hsmpas@TA4)(HOST=TA4)(USER=ta4))))
--- dump of hsttti ---
11010CE00                         00 04 01 0C 0E 09 0B 0F          [........]
11010CE10 04 0A 01 01 01 00 00 0A 00 00 00 00 00 2F 30 01  [............./0.]
11010CE20 01 01 01 01 01 01 01 01 01 01 00 00 00 00 00 07  [................]
11010CE30 01 01 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]
11010CE40 00 00 13 00 00 00 00 00 00 00 00 00 0C 00 01 00  [................]
11010CE50 00 00 14 00 01 00 00 00 00 00 00 00 00 00 00 00  [................]
11010CE60 00 00 00 0D 00 00 11 11 04 09 00 00 01 01 01 00  [................]
11010CE70 22 01 01 00 13 13 15 15 17 17 17 17 21 03 00 01  ["...........!...]
11010CE80 03 13 13 13 00 00 00 00 00 00 00 00 00 00 00 00  [................]
11010CE90 01 00 00 00 00 00 00 00 00 00 04 01 00 00 00 00  [................]
11010CEA0 0F 0F 0F 1F 20 00 00 00 00 00 00 00 00 00 00 00  [.... ...........]
11010CEB0 00 00 00 00 0F 00 00 00 00 00 01 01 01 01 01 01  [................]
11010CEC0 2A 2A 2A 2A 2A 2B 2B 00 00 00 00 23 23 23 00 00  [*****++....###..]
11010CED0 00 00 00 00 00 00 00 00 22 01 00 00 00 00 00 00  [........".......]
11010CEE0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 35  [...............5]
11010CEF0 2A 01 00 00 00 00 00 00 00 13 00 00 00 00 00 00  [*...............]
11010CF00 00 00 00 00 00 00 00 36 00 00 00 00 00 00 00 00  [.......6........]
11010CF10 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]
11010CF20 00 00 00 00 00 00 00 00 00 00 01 01 01 01 01 00  [................]
11010CF30 00 00 01 01 01 01 01 01 01 01 01 01 01 01 01 01  [................]
11010CF40 01 01 00 01 01 01 01 01 01 01 03 01 00 00 00 01  [................]
11010CF50 01 01 00 01 00 01 01 01 01 01 01 01 01 01 01 01  [................]
11010CF60 03 01 01 00 01 01 00 00 00 00 01 01 00 00 00 01  [................]
11010CF70 00 00 00 01 00 00 00 00 00 00 00 00 00 00 00 00  [................]
11010CF80 00 00 00 00 03 01 01 01 01 01 01 01 01 03 01 01  [................]
11010CF90 00 03 03 01 01 03 01 01 01 01 00 00 01 03 01 03  [................]
11010CFA0 00 00 00 00 00 01 03 03 03 03 03 03 03 03 03 03  [................]
11010CFB0 03 03 03 01 00 03 03 03 01 03 00 00 00 00 00 00  [................]
11010CFC0 00 00 00 00 00 00 00 00 00 03 19 00 00 00 01 03  [................]
11010CFD0 03 03 03 03 03 03 03 1D 00 00 03 01 01 03 01 03  [................]
11010CFE0 03 03 03 03 03 03 03 03 03 03 03 01 01 01 01 00  [................]
11010CFF0 00 00 01 01 01 01 01 03 03 00 01 01 01 01 01 00  [................]
11010D000 00 00 00 00 00 01 01 00 00 01 03 31 03 03 03 03  [...........1....]
11010D010 03 03 03 03 03 03 03 03 03 03 03 03 18 01 01 01  [................]
11010D020 01 03 03 03 01 01 01 01 03 03 01 03 03 03 01 01  [................]
11010D030 03 03 03 03 03 03 03 03 03 01 03 01 01 03 01 03  [................]
11010D040 03 01 01 03 01 03 01 01 01 03 01 03 01 03 01 01  [................]
11010D050 03 01                                            [..]              
ttclxlccst:     852
ttclxrccst:     852
ttclxlncst:     2000
ttclxrncst:     2000
ttclxccl2nr:    1
ttclxccn2lr:    1
ttclxncl2nr:    1
ttclxncn2lr:    1
ttclxrccminbpc: 1
ttclxrccmaxbpc: 2
ttclxrncminbpc: 2
ttclxrncmaxbpc: 2
ttclxflags:     0xa3


*** 2013-12-10 22:08:53.937
Incident 108994 created, dump file: /tadbdata/oracle/diag/rdbms/tadb/tadb/incident/incdir_108994/tadb_ora_40108074_i108994.trc
ORA-03137: TTC protocol internal error : [3149] [] [] [] [] [] [] []
ORA-03149: Invalid Oracle error code


ttcdrvdmplocation: msg-0 ln-252 reporting 3137
Dumping 'Buffer dump info:' addr=0x110939ac0 size=395 bytes
Dump of memory from 0x110939ac0 to 0x110939c4c
110939AC0 035E5D00 00802900 000000FF FFFFFFFF  [.^]...).........]
110939AD0 FFFFFE00 00003D00 000000FF FFFFFFFF  [......=.........]
110939AE0 FFFFFE00 00000D00 000000FF FFFFFFFF  [................]
110939AF0 FFFFFEFF FFFFFFFF FFFFFE00 00000000  [................]
110939B00 00000100 00000000 000000FF FFFFFFFF  [................]
110939B10 FFFFFE00 00000200 00000000 00000000  [................]
110939B20 000000FF FFFFFFFF FFFFFE00 00000000  [................]
110939B30 000000FF FFFFFFFF FFFFFEFF FFFFFFFF  [................]
110939B40 FFFFFE00 00000112 AFA38000 00000000  [................]
110939B50 000000FF FFFFFFFF FFFFFEFF FFFFFFFF  [................]
110939B60 FFFFFE00 00000000 00000000 00000000  [................]
110939B70 00000000 00000000 00000000 00000000  [................]
110939B80 0000003D 75706461 74652054 49535355  [...=update TISSU]
110939B90 4547524F 55502020 73657420 465F414C  [EGROUP  set F_AL]
110939BA0 4C4F5452 4154494F 3D3A6230 20776865  [LOTRATIO=:b0 whe]
110939BB0 72652043 5F46554E 44434F44 453D3A62  [re C_FUNDCODE=:b]
110939BC0 31000000 02000000 01000000 00000000  [1...............]
110939BD0 00000000 00000000 00000000 00000000  [................]
110939BE0 02000000 00000000 00000000 00000000  [................]
110939BF0 00000000 00010200 00000000 00160000  [................]
110939C00 00000000 00000000 00000000 00000000  [................]
110939C10 00000000 00000000 00000000 00000101  [................]
110939C20 00000000 00000600 00000000 00000000  [................]
110939C30 00000000 00000000 00000003 54010000  [............T...]
110939C40 00000000 00000007 FF059206           [............]    




详细情况参考：
oracle support

文档 14489591.8

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

转载于:http://blog.itpub.net/16969562/viewspace-1063595/