某客戶資料庫日誌報ORA-03137: TTC protocol internal error : [12333] [7] [120] [115] [] [] [] []錯誤
1.環境介紹：
Oracle 11.2.0.1 64-bit
Microsoft Windows x86 64-bit
2.alert日誌檔案內容
Dump file c:\app\administrator\diag\rdbms\jzh\jzh\incident\incdir_360956\bpmes_ora_5344_i360956.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.1 Service Pack 1
CPU : 24 - type 8664, 12 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:55404M/81885M, Ph+PgF:136952M/163768M
Instance name: jzh
Redo thread mounted by this instance: 1
Oracle process number: 76
Windows thread id: 5344, image: ORACLE.EXE (SHAD)
*** 2015-04-10 02:03:45.036
*** SESSION ID:(382.46961) 2015-04-10 02:03:45.036
*** CLIENT ID:() 2015-04-10 02:03:45.036
*** SERVICE NAME:(jzh) 2015-04-10 02:03:45.036
*** MODULE NAME:(APService.exe) 2015-04-10 02:03:45.036
*** ACTION NAME:() 2015-04-10 02:03:45.036
Dump continued from file: c:\app\administrator\diag\rdbms\jzh\jzh\trace\bpmes_ora_5344.trc
ORA-03137: TTC protocol internal error : [12333] [13] [87] [76] [] [] [] []
========= Dump for incident 360956 (ORA 3137 [12333]) ========
*** 2015-04-10 02:03:45.036
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=4a6wq2fr966jw) -----
select count(*)
from (Select A.SERIAL_NUMBER "Cell ID",
D.Process_Name "Process Name",
Decode(A.CURRENT_STATUS, '1', 'NG', 'OK') "Status",
A.CONTAINER "Tray ID",
A.OUT_PROCESS_TIME "Out Process Time",
F.EMP_NAME "Employee"
From JZH.xxxxxxx A,
JZH.xxxxxxx B,
JZH.xxxxxxx C,
JZH.xxxxxxx D,
JZH.xxxxxxx F,
JZH.xxxxxxx E,
JZH.xxxxxxx G
Where 0 = 0
and B.WORK_ORDER = :Work_Order
and E.PART_NO = :Part_No
and D.PROCESS_NAME = :Process_Name
and TO_CHAR(OUT_PROCESS_TIME, 'YYYY/MM/DD') = :Date_
and A.PDLINE_ID = C.PDLINE_ID
and A.PROCESS_ID = D.PROCESS_ID
and A.EMP_ID = F.EMP_ID(+)
and A.PART_ID = E.PART_ID
and E.MODEL_ID = G.MODEL_ID(+)
and A.WORK_ORDER = B.WORK_ORDER
Order by A.OUT_PROCESS_TIME DESC) a
查詢MOS發現該錯誤是由於SQL語句使用繫結變數而引起的bug，Bug 10338725，參考文件：
Troubleshooting ORA-3137 [12333] Errors Encountered When Using Oracle JDBC Driver (文件 ID 1361107.1)
Bug 10338725 : ORA-03137: TTC PROTOCOL INTERNAL ERROR : [12333] [7] OCCURED
3.解決方法
關閉繫結變數窺視alter system set "_optim_peek_user_binds"=false;

升級資料庫至11.2.0.2版本。

應用補本9703463。

ORA-03137: TTC protocol internal error : [12333] [7] [120] [115] [] [] [] []

相關文章