ORA-00600: 內部錯誤程式碼, 引數: [12333]

    最近又遇到一個ORA-600的錯誤，查詢了相關資料，記錄如下：

    一、現象
 Errors in file /oracle/admin/testdb/udump/testdb_ora_28976.trc:
ORA-00600: 內部錯誤程式碼, 引數: [12333], [7], [5], [196], [], [], [], []
Wed Apr 14 09:55:01 2010
Errors in file /oracle/admin/testdb/udump/testdb_ora_28457.trc:
ORA-00600: 內部錯誤程式碼, 引數: [12333], [8], [50], [48], [], [], [], []
Wed Apr 14 09:55:03 2010
Errors in file /oracle/admin/testdb/udump/testdb_ora_28960.trc:
ORA-00600: 內部錯誤程式碼, 引數: [12333], [8], [50], [48], [], [], [], []

   二、目的
    This article discusses the internal error "ORA-600 [12333]", what it means and possible actions.  The information here is only applicable to the versions listed and is provided only for guidance.

 三、描述
ERROR:             
  ORA-600 [12333] [a] [b] [c] [d]

VERSIONS:          
  Versions 6.0 to 10.2

DESCRIPTION:       

  There are three forms of the OERI(12333) error:

  i.   Usage with 4 additional values: ORA-600 [PTI] [b] [c] [d]
       Reported by Oracle release 8.0 onwards 
  
    DESC:This may be reported when parsing storage options on alter/create of various database objects.  The [b], [c], [d] arguments identify a specific statement type being parsed.
         This form. of the error indicates a problem in the sql parser.  As common functions are used to parse the storage options of different database objects, this error code is used as a semantic check that the parser has not passed options that are invalid for the statement being parsed. 

  ii.  Usage with 4 additional values: ORA-600 [a] [b] [c] [d]
       Reported by Oracle release 8.0 onwards 

    DESC:This represents a Two Task Protocol violation and is reported because an OCI call has been sent in the wrong order.

  iii. Usage with 3 additional values: ORA-600 [a] [b] [c]
       Reported by Oracle release 7 and earlier. 

    DESC:The ORA-600 [12333] is reported 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. The three additional values report the invalid request values received.


  四、Troubleshooting Details and 影響
  IMPACT:            
  PROCESS FAILURE
  NO DATA CORRUPTION
  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.
  1. Check the client software version. An incompatible client software can cause such internal error.
  2. An incompatible NLS Client setting can also trigger such internal errors.
  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 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. 
  5. 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.

 

參考文獻：
1. ORA-600 [12333] "Fatal Two-Task Protocol Violation" [ID 35928.1]
2. Understanding and diagnosing ORA-00600 [12333] errors [ID 389713.1]
3. http://www.itpub.net/threadqui.php?id=2&tid=890471