ORA-03137: TTC Protocol Internal Error : [12333] Using JDBC Driver (文档 ID 752297.1)
来源:互联网 发布:php留言板视频教程 编辑:程序博客网 时间:2024/05/01 03:06
In this Document
APPLIES TO:
JDBC - Version 11.1.0.6 and laterInformation in this document applies to any platform.
***Checked for relevance on 26-Apr-2013***
SYMPTOMS
On 11.1.0.6 in Production, when attempting to run an application using the JDBC thin driver 11.1.0.6 against a database version 11.1.0.6, the following error occurs:
ORA-03137: TTC protocol internal error : [12333] [10] [83] [74] [] [] [] []
The stack trace in the database alert log is:
----- Current SQL Statement for this session (sql_id=c0czhbm4hcz98) -----
DELETE FROM PORTAL_CONCURRENT_USER_SCRATCH
WHERE LAST_LOGIN < :intervalStartDate
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
skdstdst()+002c bl 105e2771c
ksedst1()+0064 bl 101fad134
ksedst()+0028 bl ksedst1() 60000B8104C4A30 ?
600000002050032 ?
dbkedDefDump()+07fc bl 101fae954
ksedmp()+0048 bl 101fad130
opiierr()+0168 bl ksedmp() 000000000 ?
opitsk()+1344 bl 103ec9a5c
opiino()+09a0 bl opitsk() 110098B40 ? 000000000 ?
opiodr()+0b48 bl 103ec7a30
opidrv()+0440 bl opiodr() 3C61672F72 ? 41032E668 ?
FFFFFFFFFFFF7E0 ? 073702F74 ?
sou2o()+0090 bl opidrv() 3C05C04AEC ? 4A09A9924 ?
FFFFFFFFFFFF7E0 ?
opimai_real()+01b0 bl 101face8c
main()+0090 bl opimai_real() 000000000 ? 000000000 ?
__start()+0098 bl main() 000000000 ? 000000000 ?
This problem does not happen if the 10.2.0.3 driver is used.
CAUSE
According to Bug 7390077 ORA-3137: TTC PROTO INTERNAL ERROR: [12333] [8] [80] [65] reported for JDBC 11.0.6.0, this bug is an RDBMS bug and not JDBC.
SOLUTION
The solution is to upgrade the database to version 11.1.0.7 where the problem is fixed.
This has been reported in unpublished bug:8625762 ORA-3137 [12333] due to bind data not read from wire, in which case ORA-3137 [12333] can occur intermittently for SQL which uses user binds due to bind data being left unread on the Net connection. The bug suggests the workaround of setting "_optim_peek_user_binds"=false to avoid this problem (workaround to be used with caution as it can affect execution plans chosen by CBO), and also provides the fix by the application of Patch:8625762.
Further information:
Suggestions For Troubleshooting ORA-3137 [12333] Errors Encountered When Using Oracle JDBC Driver (Document 1361107.1)
Join the Java Development MOS Community forum for general discussions, questions, best practices, and other valuable information on: Oracle JDeveloper and ADF, Oracle WebLogic - JEE Programming (EJB, JMS etc), Oracle JDBC, Oracle Web Services (incl. DBWS Callout Utility), Oracle Web Services Manager (OWSM), Oracle Service Registry (OSR), Oracle Toplink (EclipseLink), Sun NetBeans IDE / Java Studio Creator & Java Studio Enterprise, OC4J, KODO.
REFERENCES
BUG:7445550 - ORA-03137: TTC PROTO INTERNAL ERROR : [12333] [21] [106] [110] [] [] [] []NOTE:1361107.1 - Troubleshooting ORA-3137 [12333] Errors Encountered When Using Oracle JDBC Driver
NOTE:8625762.8 - Bug 8625762 - ORA-3137 [12333] due to bind data not read from wire
- ORA-03137: TTC Protocol Internal Error : [12333] Using JDBC Driver (文档 ID 752297.1)
- ORA-03137: TTC Protocol Internal Error : [12333] Using JDBC Driver (文档 ID 752297.1)
- ORA-03137: TTC protocol internal error : [12333]错误一例
- Oracle ORA-03137: TTC protocol internal error : [12333] 故障分析
- ORA-03137: TTC protocol internal error : [12333] [7] [120] [116] [] [] [] []
- Troubleshooting ORA-3137 [12333] Errors Encountered When Using Oracle JDBC Driver (文档 ID 1361107.1)
- Troubleshooting ORA-3137 [12333] Errors Encountered When Using Oracle JDBC Driver (文档 ID 1361107.1)
- Troubleshooting ORA-3137 [12333] Errors Encountered When Using Oracle JDBC Driver (文档 ID 1361107.1)
- What is an ORA-600 Internal Error? (文档 ID 146580.1)
- ORA-03137: TTC …
- ORA-39006: internal error
- Excel Jdbc Driver 文档
- 测试库ORA-03137: TTC 协议内部错误: [12333] [8] [57] [53] [] [] [] [] 解决
- ORA-06576 error during Drop User (文档 ID 1498610.1)
- Ora-29913: Error In Executing Odciexttableopen Callout (文档 ID 353642.1)
- OERR: ORA-3137 "TTC protocol int…
- sybase连接问题:ct_connect(): network packet layer: internal net library error: Net-Lib protocol driver call to connect two endpoints
- ORA-600/ORA-7445/ORA-700 Error Look-up Tool (文档 ID 153788.1)
- 志愿者招募
- laravel视图blade模板使用集合
- ssh登录docker容器
- #object C runtime 简介
- bzoj4059【Cerc2012】Non-boring sequences
- ORA-03137: TTC Protocol Internal Error : [12333] Using JDBC Driver (文档 ID 752297.1)
- 浅谈差异化与同质化
- 敏捷软件开发第二部分(OCP:开放-封闭原则)
- 进程与线程的区别
- 【2016杭电女生赛1008】【数据结构 动态节点线段树】Claris Loves Painting
- PHP实习(三)
- NOIP2015解题报告
- BATCHSQL--GoldenGate Parameter
- 【java SE基础】Java线程详解