Understanding and Diagnosing ORA-00600 [12333] Errors [ID 389713.1]
Understanding and Diagnosing ORA-00600 [12333] Errors [ID 389713.1]
Modified 17-AUG-2010 Type TROUBLESHOOTING Status PUBLISHED
In this Document
Purpose
Last Review Date
Instructions for the Reader
Troubleshooting Details
References
Applies to:
Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 11.1.0.7 - Release: 8.1.7 to 11.1
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 8.1.7.4 to 11.1.0.7
Purpose
This article will discuss the common causes and troubleshooting tips for ORA-00600 [12333] error.
ORA-00600 [12333] can occur with three additional numeric values when a request is being received from a
network packet and the request code in the packet is not recognized.
Last Review Date
November 03, 2006
Instructions for the Reader
A Troubleshooting Guide is provided to assist in debugging a specific issue. When possible, diagnostic tools
are included in the document to assist in troubleshooting.
Troubleshooting Details
For any ONE-TIME occurrence we can safely ignore the error. This error does not relate to any potential data
corruption or any data loss. Check Note:35928.1 for known issues and two basic usages of OERI(12333):
* Usage with 3 additional numeric values
* Usage with 4 additional values ... new since 8.0.X
In case the errors are seen consistently and no known issues matches to your issue then do the following
Common Causes & Solutions:
1. Check the client software version. An incompatible client software can cause such internal error. The
following note explains the supported combinations of clients for a particular RDBMS Server release.
Note:207303.1 Client / Server / Interoperability Support Between Different Oracle Versions
2. An incompatible NLS Client setting can also trigger such internal errors. Check the NLS settings as
explained in the following note.
Note:77442.1 ORA_NLS (ORA_NLS32, ORA_NLS33, ORA_NLS10) Environment Variables explained
3. Try to reproduce the issue from a different client machine, preferably from server. This will rule out
the possibility of bad network. If the execution fails from a particular client then it could be due to the
bad network from that client to server.
4. If error still continues , then do the following to understand from where the error is generated.
* We need to understand which session/program/application that triggers this issue. This shall be found
from the trace files under the session state object '(session)'. Sometimes the ORA-00600 [12333] trace files
will not capture the session information. In such cases we can check with the end users about any issues
around the time-frame. of this internal error.
* There is a HIGH chance for application run-time exception to lead to this ORA-00600 [12333]. Due to
the unhandled exceptions there is a chance for incomplete information passed to the server hence the
internal errors are raised. In such cases, handling those exceptions (or) addressing those errors on the
application code will resolve the issue.
* In few cases, the problem application will work for a while before it terminates with the error. This
could be due to the TIMEOUT settings at the Application Server (or) Forms Server.,etc. To resolve this
either tune the failing application to complete within the TIMEOUT value (or) reset the TIMEOUT to an
optimal value.
* There could be more possibilities here; in simple words the approach should be from application side,
which would help us to understand the other issues that triggered this network interruption (ORA-00600
[12333]).
5. If you notice JDBC Client as the failing program under Session state object, please check and ensure that
you use latest compatible version of JDBC Drivers in your application side. You can refer to Note:430839.1
to verify the version of JDBC Drivers and for Installation steps.
6. In-case if all the above suggestions does not help to identify the cause, and the ORA-00600 [12333]
persists we may need to enable the networking tracings from the problem client and need to review the
network traces to understand where the problem occurs. See Note:219968.1 Title: SQL*Net, Net8, Oracle Net
Services - Tracing and Logging at a Glance
References
NOTE:207303.1 - Client / Server / Interoperability Support Between Different Oracle Versions
NOTE:219968.1 - SQL*Net & Oracle Net Services - Tracing and Logging at a Glance
NOTE:35928.1 - ORA-600 [12333] "Fatal Two-Task Protocol Violation"
NOTE:430839.1 - Providing a JDBC Testcase to Oracle Support
NOTE:77442.1 - ORA_NLS (ORA_NLS32, ORA_NLS33, ORA_NLS10) Environment Variables explained.
Show Related Information Related
Products
* Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
Keywords
NETWORK PACKETS; JDBC DRIVER
Errors
ORA-600[12333]; ORA-600[12333]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-684189/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Understanding and Diagnosing ORA-00600 [12333] / ORA-3137 [12333] ErrorsError
- Understanding and Diagnosing ORA-00600 [13011] Errors [ID 1392778.1]Error
- Understanding and Diagnosing ORA-600 [729] Space Leak Errors_403584.1Error
- DIAGNOSING ORA-3113 ERRORS [ID 1020463.6]Error
- Summary of Bugs containing ORA-00600[12333] Error [ID 428629.1]AIError
- While Solving ORA-00600 [4194]/[4193] Errors [ID 281429.1]WhileError
- ORA-00600: internal error code, arguments: [12333], [254], [64]Error
- ORA-00600: 內部錯誤程式碼, 引數: [12333]
- Troubleshooting ORA-3137 [12333] Errors When Using Oracle JDBC DriverErrorOracleJDBC
- Understanding SaltStack --Guided Book 官方文件GUIIDE
- ORA-00600 [4194]/[4193] Errors Without Using Unsupported parameter-281429.1Error
- ASM REACTING TO PARTITION ERRORS [ID 1062954.1]ASMReactError
- Understanding Service Types
- Understanding TCP socket states (Doc ID 1003531.1)TCP
- Understanding JSON SchemaJSON
- Understanding Delegated JavaScript EventsJavaScript
- Understanding Parallel Execution PlanParallel
- [翻譯] Understanding deletedelete
- Understanding RabbitMQ Exchange & QueueMQ
- Understanding Initialization Parameters (85)
- Metric Collection ErrorsError
- oracle之errorsOracleError
- oracle 之errorsOracleError
- ORA-600 [12333] "Fatal Two-Task Protocol Violation" [ID 35928.1]Protocol
- Understanding Linux CPU statsLinux
- Understanding React `setState` 翻譯React
- Understanding the CREATE DATABASE Statement (69)Database
- Understanding Buffer Overflow Bugs
- Database Capture and Replay: Common Errors and Reasons (文件 ID 463263.1)DatabaseAPTError
- ORA-00600 : internal error code, arguments: [qertbFetchByRowID]Error
- Go Errors 詳解GoError
- slave-skip-errorsError
- HIbernate errors...Error
- How to Create a BNE Log For Web Adi Issues and Errors? [ID 817023.1]WebError
- Understanding HBase and BigTable 譯文
- 【譯】Understanding NodeJS Event LoopNodeJSOOP
- Understanding Swing’s Model (轉)
- ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC_EVENTSError