ORA-03137: TTC Protocol Internal Error : [12333] Using JDBC Driver
In this Document
Symptoms |
Cause |
Solution |
References |
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 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 .
Further information:
Suggestions For Troubleshooting ORA-3137 [12333] Errors Encountered When Using Oracle JDBC Driver (Document 1361107.1)
Join the 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
- 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
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/2317695/viewspace-2105018/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-03137: TTC protocol internal error: [12333]分析及處理ProtocolError
- ORA-03137: TTC protocol internal error : [12333] [7] [120] [115] [] [] [] []ProtocolError
- RA-03137:TTC protocol internal error:[12333]ProtocolError
- [wm-cjdbc33-0069][Oracle JDBC Driver]Internal error: Net8 protocol errorJDBCOracleErrorProtocol
- Troubleshooting ORA-3137 [12333] Errors When Using Oracle JDBC DriverErrorOracleJDBC
- ORA-03137: TTC 協議內部錯誤: [12333] [7] [0] [0] [] [] [] []協議
- ORA-03137: TTC 協議內部錯誤: [12333] [48] [9] [91] [] [] [] []協議
- ORA-00600: internal error code, arguments: [12333], [254], [64]Error
- kattle Driver class 'oracle.jdbc.driver.OracleDriver' could not be foundOracleJDBC
- java jdbc Protocol violation錯誤JavaJDBCProtocol
- JDBC Driver連線方法列表JDBC
- microsoft jdbc driver 與jtdsROSJDBC
- Internal Server Error..ServerError
- 11.2.0.1安裝grid報錯: [INS-20702] Unexpected internal driver errorError
- JDBC differences between the DB2 Universal JDBC Driver and other DB2 JDBC driversJDBCDB2
- Loading class `com.mysql.jdbc.DriverMySqlJDBC
- 轉載:Oracle jdbc thin driver三種格式OracleJDBC
- Fatal error: Uncaught PDOException: could not find driverErrorException
- 資料庫alert日誌報ORA-03137 TTC 協議內部錯誤故障分析處理資料庫協議
- 解決Mybatis連線Sql server 出現 Cannot load JDBC driver class 'com.mysql.jdbc.Driver '的問題MyBatisServerJDBCMySql
- ORA-600 [12333] "Fatal Two-Task Protocol Violation" [ID 35928.1]Protocol
- Internal error:1058 解決方法Error
- ORA-00600: internal error codeError
- 求助:weblogic8.1 : Error 500--Internal Server ErrorWebErrorServer
- db2 v9.7 jdbc driver downloadDB2JDBC
- Android 3.0 DELETE_FAILED_INTERNAL_ERRORAndroiddeleteAIError
- An internal error has occurred. Java heap spaceErrorJava
- ORA-00600internal error code argumentsError
- EXP-00006: internal inconsistency errorError
- HTTP 錯誤 500.19 - Internal Server ErrorHTTPServerError
- ORA-00610: Internal error codeError
- 無法找到註冊驅動Did not find registered driver with class com.mysql.jdbc.DriverMySqlJDBC
- java通過jdbc連線oracle報錯No suitable driverJavaJDBCOracleUI
- Oracle 9i, 10g jdbc driver 檔案OracleJDBC
- ORA-00600: internal error code, arguments: [kpnatdm】Error
- ORA-00600: internal error code, arguments: [525]Error
- 請問JDBC for SQL Server 7.0的driver在哪裡有得downJDBCSQLServer
- OCP(11g)------> SEC_PROTOCOL_ERROR_FURTHER_ACTIONProtocolError