ORA-03137: TTC 協議內部錯誤: [12333] [7] [0] [0] [] [] [] []
Sat Jan 11 14:22:10 2014
Errors in file /u01/app/oracle/diag/rdbms/trace/_ora_26762.trc (incident=136238):
ORA-03137: TTC 協議內部錯誤: [12333] [7] [120] [114] [] [] [] []
Incident details in: /u01/app/oracle/diag/rdbms/incident/incdir_136238/_ora_26762_i136238.trc
Sat Jan 11 14:22:12 2014
Trace dumping is performing id=[cdmp_20140111142212]
Sat Jan 11 14:22:14 2014
Sweep [inc][136238]: completed
Sweep [inc2][136238]: completed
在MOS上檢視文件(Doc ID 1361107.1),確定在使用JDBC連線資料庫時,可能有多種原因引起的BUG,結合本系統資料庫版本,主要有以下2個原因:
a)、部分版本JDBC驅動引起;
b)、使用繫結變數時引起(trace檔案中顯示的確使用了繫結變數)。
解決方法有以下四種:
a)、禁用繫結變數窺視
SQL> alter system set "_optim_peek_user_binds"=false;
此方法不一定有效,需要觀察,如果不能解決問題,考慮下面的方法。
b)、打上Patch 1241938等補丁;
c)、升級到11.2.0.3,上面所有提到的BUG都被修復;
d)、嘗試更換不同版本的JDBC驅動來避免這個問題。
下面是mos中的資訊:
Known Database IssuesUnpublished Bug 8625762 - ORA-3137 [12333] due to bind data not read from wire
This bug affects RDBMS version lower than version 11.2. It is fixed in version 11.2 of the database.
It can occur intermittently, due to bind data being left unread database connection. This is a bind peeking bug.
This bug is also known for causing
ORA-3137: TTC protocol internal error : [1010] [] [] [] [] [] [] []
Unpublished Bug 9703463 - ORA-3137 [12333] or ORA-600 [kpobav-1] When Using Bind Peeking
This bug affects versions 11.1.0.6, 11.1.0.7, and 11.2.0.1 of the RDBMS. It is fixed in version 11.2.0.2 of the database.
It can also occur intermittently; similarly to unpublished Bug:8625762, this is a bind peeking bug.
Unpublished Bug:9243912 - Additional diagnostics for ORA-3137 [12333] / OERI:12333
This bug affects versions of the RDBMS lower than version 11.2.0.2. It is fixed in version 11.2.0.2 of the database.
This bug addresses scenarios in which the ORA-3137 [12333] error occur bind issues during the client/server communication process. When this particular bug is fixed, the result may be the uncovering of an additional, more descriptive error: ORA-600 [kpobav-1]
Bug 7390077 ORA-03137: TTC PROTO INTERNAL ERROR: [12333] [8] [80] [65]
This bug affects the RDBMS 11.1.0.6 and is resolved with RDBMS 11.1.0.7.
typical errors:
ORA-03137: TTC protocol internal error : [12333] [10] [83] [74] [] [] [] []
ORA-03137: TTC protocol internal error : [12333] [7] [120] [108] [] [] [] []
example stack:
ORA-03137: TTC protocol internal error : [12333] [7] [120] [108] [] [] [] []
----- Current SQL Statement for this session (sql_id=c0czhbm4hcz98) -----
DELETE FROM PORTAL_CONCURRENT_USER_SCRATCH
WHERE LAST_LOGIN
----- 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 ?
This problem does not happen if the JDBC 10.2.0.3 driver is used but is nevertheless considered a database bug.
The following bugs have been marked as potential duplicates of this case:
Bug 7573690 Bug 7607470 Bug 8490909
Unpublished Bug 9373370 - Data Base Returns Wrong CURSORID When There Is an ORA-1013
This bug affects the 10.2, 11.1, 11.2.0.1, and 11.2.0.2 databases. It is discussed in the following note:
Note 9373370.8 Bug 9373370 - The wrong cursor may be executed by JDBC thin following a query timeout / ORA-3137 [12333]
While the bug primarily manifests in ORA-1006 or ORA-1008 errors, the problem may also result in ORA-600 [12333] or ORA-3137 [12333] errors appearing on the server side.
Known JDBC IssuesBug 9445675 NO MORE DATA TO READ FROM SOCKET WHEN USING END-TO-END METRICS
This bug does affect the JDBC driver. This bug may be the cause when all of the following conditions are met:
1. You are using the 10.1.x.x or the 11.2.0.1 JDBC driver; the bug does not affect 10.2.x.x, or 11.1.x.x versions of the driver, nor versions 11.2.0.2 or above
2. You are using end-to-end metrics in your Java code
3. The server side ORA-3137 [12333] error is accompanied by the client side Java exception "No more data to read from socket"
This bug is fixed in the 11.2.0.2 version of the JDBC driver and above. It is discussed in the following notes:
Note 9445675.8 Bug 9445675 - "No more data" / ORA-3137 using end to end metrics with JDBC Thin
Note 1081275.1 "java.sql.SQLRecoverableException: No more data to read from socket" is Thrown When End-to-end Metrics is Used
Troubleshooting Approaches1. Disable Bind Peeking
A common thread through the database bugs listed above is that the problem does not occur if bind peeking is shut off. Temporarily disabling bind peeking allows you to confirm whether this is the case in your environment as well.
This can be done dynamically:
SQL> alter system set "_optim_peek_user_binds"=false;
If the ORA-3137 [12333] error no longer reproduces after disabling bind peeking, then in most cases, the problem is due to one of the database bugs listed above, or due to some variant of one of those bugs.
Note: disabling bind peeking can have an impact on the database. Specifically, it can alter the explain plan for some queries that use bind variables. This should be taken into account, particularly before considering the use of this option as a long-term workaround.
2. Apply Relevant Database Patches
Whenever possible, the recommended solution when running a database version 11.1.0.7 is to apply the most recent PSU patch.
PSU 11.1.0.7.8 Patch 12419384 includes Patch:9703463.
For 11.1.0.7, Patch 9243912 can be applied on top of 11.1.0.7.8 ( no conflict).
Patch:9703463 can also be applied individually but requires PSU 11.1.0.7.6
Patch:8625762 may also be applicable to databases version 11.1.0.7
If you have disabled bind peeking as a test, and the error no longer reproduces, then applying one of these patches would be the next step.
Alternatively, if you are unable to disable bind peeking for some reason, you may consider applying one of these patches as a diagnostic test in itself, to confirm whether the patch fixes the problem for you.
3. Upgrade the Database to Version 11.2.0.3
All of the above bugs are fixed in version 11.2.0.3 of the database.
4. Contact Support if the problem still persists
For JDBC connections that have resulted in the ORA-3137 error, the above database-centric approaches have resolved the issue almost all of the time. If disabling bind peeking has no effect and the ORA-3137 [12333] still occurs, please contact Support, as this is a relatively rare scenario in which further investigation is needed.
http://www.orasql.com/blog/archives/2014/06/12/ora_03137.htm
Errors in file /u01/app/oracle/diag/rdbms/trace/_ora_26762.trc (incident=136238):
ORA-03137: TTC 協議內部錯誤: [12333] [7] [120] [114] [] [] [] []
Incident details in: /u01/app/oracle/diag/rdbms/incident/incdir_136238/_ora_26762_i136238.trc
Sat Jan 11 14:22:12 2014
Trace dumping is performing id=[cdmp_20140111142212]
Sat Jan 11 14:22:14 2014
Sweep [inc][136238]: completed
Sweep [inc2][136238]: completed
在MOS上檢視文件(Doc ID 1361107.1),確定在使用JDBC連線資料庫時,可能有多種原因引起的BUG,結合本系統資料庫版本,主要有以下2個原因:
a)、部分版本JDBC驅動引起;
b)、使用繫結變數時引起(trace檔案中顯示的確使用了繫結變數)。
解決方法有以下四種:
a)、禁用繫結變數窺視
SQL> alter system set "_optim_peek_user_binds"=false;
此方法不一定有效,需要觀察,如果不能解決問題,考慮下面的方法。
b)、打上Patch 1241938等補丁;
c)、升級到11.2.0.3,上面所有提到的BUG都被修復;
d)、嘗試更換不同版本的JDBC驅動來避免這個問題。
下面是mos中的資訊:
Known Database IssuesUnpublished Bug 8625762 - ORA-3137 [12333] due to bind data not read from wire
This bug affects RDBMS version lower than version 11.2. It is fixed in version 11.2 of the database.
It can occur intermittently, due to bind data being left unread database connection. This is a bind peeking bug.
This bug is also known for causing
ORA-3137: TTC protocol internal error : [1010] [] [] [] [] [] [] []
Unpublished Bug 9703463 - ORA-3137 [12333] or ORA-600 [kpobav-1] When Using Bind Peeking
This bug affects versions 11.1.0.6, 11.1.0.7, and 11.2.0.1 of the RDBMS. It is fixed in version 11.2.0.2 of the database.
It can also occur intermittently; similarly to unpublished Bug:8625762, this is a bind peeking bug.
Unpublished Bug:9243912 - Additional diagnostics for ORA-3137 [12333] / OERI:12333
This bug affects versions of the RDBMS lower than version 11.2.0.2. It is fixed in version 11.2.0.2 of the database.
This bug addresses scenarios in which the ORA-3137 [12333] error occur bind issues during the client/server communication process. When this particular bug is fixed, the result may be the uncovering of an additional, more descriptive error: ORA-600 [kpobav-1]
Bug 7390077 ORA-03137: TTC PROTO INTERNAL ERROR: [12333] [8] [80] [65]
This bug affects the RDBMS 11.1.0.6 and is resolved with RDBMS 11.1.0.7.
typical errors:
ORA-03137: TTC protocol internal error : [12333] [10] [83] [74] [] [] [] []
ORA-03137: TTC protocol internal error : [12333] [7] [120] [108] [] [] [] []
example stack:
ORA-03137: TTC protocol internal error : [12333] [7] [120] [108] [] [] [] []
----- Current SQL Statement for this session (sql_id=c0czhbm4hcz98) -----
DELETE FROM PORTAL_CONCURRENT_USER_SCRATCH
WHERE LAST_LOGIN
----- 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 ?
This problem does not happen if the JDBC 10.2.0.3 driver is used but is nevertheless considered a database bug.
The following bugs have been marked as potential duplicates of this case:
Bug 7573690 Bug 7607470 Bug 8490909
Unpublished Bug 9373370 - Data Base Returns Wrong CURSORID When There Is an ORA-1013
This bug affects the 10.2, 11.1, 11.2.0.1, and 11.2.0.2 databases. It is discussed in the following note:
Note 9373370.8 Bug 9373370 - The wrong cursor may be executed by JDBC thin following a query timeout / ORA-3137 [12333]
While the bug primarily manifests in ORA-1006 or ORA-1008 errors, the problem may also result in ORA-600 [12333] or ORA-3137 [12333] errors appearing on the server side.
Known JDBC IssuesBug 9445675 NO MORE DATA TO READ FROM SOCKET WHEN USING END-TO-END METRICS
This bug does affect the JDBC driver. This bug may be the cause when all of the following conditions are met:
1. You are using the 10.1.x.x or the 11.2.0.1 JDBC driver; the bug does not affect 10.2.x.x, or 11.1.x.x versions of the driver, nor versions 11.2.0.2 or above
2. You are using end-to-end metrics in your Java code
3. The server side ORA-3137 [12333] error is accompanied by the client side Java exception "No more data to read from socket"
This bug is fixed in the 11.2.0.2 version of the JDBC driver and above. It is discussed in the following notes:
Note 9445675.8 Bug 9445675 - "No more data" / ORA-3137 using end to end metrics with JDBC Thin
Note 1081275.1 "java.sql.SQLRecoverableException: No more data to read from socket" is Thrown When End-to-end Metrics is Used
Troubleshooting Approaches1. Disable Bind Peeking
A common thread through the database bugs listed above is that the problem does not occur if bind peeking is shut off. Temporarily disabling bind peeking allows you to confirm whether this is the case in your environment as well.
This can be done dynamically:
SQL> alter system set "_optim_peek_user_binds"=false;
If the ORA-3137 [12333] error no longer reproduces after disabling bind peeking, then in most cases, the problem is due to one of the database bugs listed above, or due to some variant of one of those bugs.
Note: disabling bind peeking can have an impact on the database. Specifically, it can alter the explain plan for some queries that use bind variables. This should be taken into account, particularly before considering the use of this option as a long-term workaround.
2. Apply Relevant Database Patches
Whenever possible, the recommended solution when running a database version 11.1.0.7 is to apply the most recent PSU patch.
PSU 11.1.0.7.8 Patch 12419384 includes Patch:9703463.
For 11.1.0.7, Patch 9243912 can be applied on top of 11.1.0.7.8 ( no conflict).
Patch:9703463 can also be applied individually but requires PSU 11.1.0.7.6
Patch:8625762 may also be applicable to databases version 11.1.0.7
If you have disabled bind peeking as a test, and the error no longer reproduces, then applying one of these patches would be the next step.
Alternatively, if you are unable to disable bind peeking for some reason, you may consider applying one of these patches as a diagnostic test in itself, to confirm whether the patch fixes the problem for you.
3. Upgrade the Database to Version 11.2.0.3
All of the above bugs are fixed in version 11.2.0.3 of the database.
4. Contact Support if the problem still persists
For JDBC connections that have resulted in the ORA-3137 error, the above database-centric approaches have resolved the issue almost all of the time. If disabling bind peeking has no effect and the ORA-3137 [12333] still occurs, please contact Support, as this is a relatively rare scenario in which further investigation is needed.
http://www.orasql.com/blog/archives/2014/06/12/ora_03137.htm
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28258625/viewspace-1454682/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-03137: TTC 協議內部錯誤: [12333] [48] [9] [91] [] [] [] []協議
- 資料庫alert日誌報ORA-03137 TTC 協議內部錯誤故障分析處理資料庫協議
- ORA-03137: TTC protocol internal error : [12333] [7] [120] [115] [] [] [] []ProtocolError
- ORA-03137: TTC protocol internal error: [12333]分析及處理ProtocolError
- ORA-03137: TTC Protocol Internal Error : [12333] Using JDBC DriverProtocolErrorJDBC
- ORA-00600: 內部錯誤程式碼, 引數: [12333]
- Windows錯誤“ 0xc0000005”Windows
- networker備份錯誤:Server is disabled: Install base enabler (0:5:0)Server
- srvctl錯誤libpthread.so.0thread
- ORACLE ORA-03137錯誤處理Oracle
- RA-03137:TTC protocol internal error:[12333]ProtocolError
- 蓄意協議錯誤:蘭利法則協議
- onvif soap 協議的錯誤程式碼協議
- Http failure response 0 Unknown error 錯誤分析HTTPAIError
- ORACLE錯誤原因查詢表ORA-0Oracle
- ora-00600-ktagetg0-1錯誤
- 0 邊雲協同
- HTTP 錯誤 500.19 配置檔案錯誤 ( 0x8007000d,0x80070032)HTTP
- 錯誤程式碼 0x534。 [SQLSTATE 42000] (錯誤 15404)SQL
- PHP HTTP 500 - 內部伺服器錯誤PHPHTTP伺服器
- 伺服器內部錯誤500的原因伺服器
- ora-600內部錯誤的型別型別
- win10更新錯誤0xc0000428怎麼回事_win10更新錯誤程式碼0xc0000428如何修復Win10
- 關閉ubuntu討厭的內部錯誤提示Ubuntu
- zt_ora-600內部錯誤的型別型別
- 啟動IIS7出現0x8ffe2740錯誤的解決辦法
- vipca報錯 Error 0PCAError
- win10錯誤程式碼0xc000000f怎麼修復 win10 錯誤程式碼0*000000f解決方法Win10
- [提問交流]0onethink無法你同意安裝協議協議
- win10 mstsc出現內部錯誤怎麼修復_win10 mstsc出現內部錯誤解決方法Win10
- 駭客豪言:7日內破解iPhone 粉碎獨家協議iPhone協議
- Python 錯誤之函式takes 0 positional arguments but 1 was givenPython函式
- java.sql.SQLException: '@P0' 附近有語法錯誤JavaSQLException
- http協議內容HTTP協議
- 使用隨身碟時提示0x00000013錯誤怎麼辦?隨身碟提示0x00000013錯誤的解決方法
- win10商店提示錯誤程式碼0x801901f7如何修復Win10
- x64 環境下_findnext() 函式報錯——0xC0000005: 寫入位置 0xFFFFFFFFDF47C5A0 時發生訪問衝突_x64 錯誤: 0xc0000005函式
- ORA-12560:TNS:協議介面卡錯誤協議