ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-00600: 内部错误代码, 参数: [12333]

ORA-00600: 内部错误代码, 参数: [12333]

原创 Linux操作系统 作者:zhanglei_itput 时间:2010-04-19 10:15:40 0 删除 编辑

    最近又遇到一个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

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/9252210/viewspace-660125/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-02-10

  • 博文量
    400
  • 访问量
    1224643