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 TISSUEGROUP set F_ALLOTRATIO=:b0 where 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
作業系統：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 TISSUEGROUP set F_ALLOTRATIO=:b0 where 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/29119536/viewspace-1353507/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 【故障處理】一次RAC故障處理過程
- MongoDB故障處理MongoDB
- 故障分析 | Greenplum Segment 故障處理
- GPON網路故障如何處理？GPON網路故障處理流程
- 【故障處理】ORA-600:[13013],[5001]故障處理
- 【故障處理】ORA- 2730*，status 12故障分析與處理
- linux故障處理Linux
- ora-故障處理
- 線上故障處理手冊
- MySQL show processlist故障處理MySql
- 微服務的故障處理微服務
- teams登入故障處理
- Oracle更新Opatch故障處理Oracle
- 如何快速處理線上故障
- Mysql故障處理2則MySql
- dataguard故障處理一則
- AIX系統故障處理AI
- 【Linux】 nfs 故障處理LinuxNFS
- 【故障處理】CRS-1153錯誤處理
- 【故障處理】ORA-19809錯誤處理
- undo表空間故障處理
- flash_recovery_area故障處理
- 一次dataguard故障處理
- 分散式事務故障處理分散式
- 【故障處理】ORA-12162 錯誤的處理
- Oracle 10g RAC故障處理Oracle 10g
- 如何處理HTTP 503故障問題？HTTP
- 【故障處理】ORA-01555
- ORA-600 [2662]故障處理
- 處理網路連結故障技巧
- otedisk OCR 檔案管理故障處理
- OGG 故障處理一例
- 一次TM ENQ故障處理ENQ
- Data guard archive GAP 故障處理案例Hive
- ora-04301故障處理
- goldengate故障處理一例Go
- HSG80故障處理過程
- GaussDB(分散式)例項故障處理分散式