ORA-00600: internal error code, arguments: [12333], [204], [153], [183], [], [], [], []

数据库环境：oracle 9.2.0.5 rac

系统环境：aix 5.2

ORA-00600: internal error code, arguments: [12333], [204], [153], [183], [], [], [], []
报错语句:
insert into ch_patrol3lnetmap(DISTRICTID,MAPNUM,STREETCODE,IMAGE,PRINTDATE,PRINTSTATE) values(:V00001,:V00002,:V00003,:
V00004,:V00005,:V00006)

[@more@]

根据oracle support:
ORA-600 [12333] During Second Insert With OUT Bind Variables [ID 462650.1]
分析:
Call Stack Trace
ksedmp ksfdmp kgeriv kgesiv ksesic3 opitsk opiino opiodr opidrv sou2o main
oracle support 文档ID 462650.1 或ID 464321.1
原因如下:
image字段为blob大对象，insert or update 语句中，blob字段设定了绑定变量，导致触发ora-00600[12333]错误，触发bug5955927

oracle support提供的解决方案:
1. There are no workarounds to the problem.（没有其他的变通的方法）
2. Patch 5955927 is available for some platforms and versions from My Oracle Support on top of 9.2.0.8.（升级数据库）

结合我们的实际情况，询问了开发公司，该表在更新，或插入大对象以前不是通过使用绑定变量的方式，现在使用新的方式，即绑定变量的方式，导致错误，建议开发公司换一种方式插入或更新大对象。

附：metalink id文档:

1. ORA-600 [12333] During Second Insert With OUT Bind Variables [ID 462650.1]

In this Document

Symptoms
Cause
Solution
References

--------------------------------------------------------------------------------

Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.1 to 9.2.0.8 [Release 9.2]
Information in this document applies to any platform.
** Checked for relevance 04-May-2010
** Checked for relevance 28-Feb-2013

Symptoms
Running an insert statement with an OUT bind variable fails with the following error:

ORA-00600: internal error code, arguments: [12333], [32], [110], [101], [], [], [], []

Summary Stack shows
------------------------------------
opitsk opiino opiodr opidrv sou2o main start

Example:

INSERT INTO t_txc_sql_dump ( ...
VALUES (:ordfr_id,
:prcs_ymd,
:bz_prcs_hmsf, ...
:dump_regst_dat_lngth,
EMPTY_BLOB() )
RETURNING dump_regst_dat INTO :out_val

Cause
This is due to Bug.5955927 ORA-600[12333] OCCURRED WHILE INSERTING.
As explained in the bug, you will receive an ORA-600[12333] when running an INSERT for the second time with

out-bind variables.

Solution
There are no workarounds to the problem.

Patch 5955927 is available for some platforms and versions from My Oracle Support on top of 9.2.0.8.

Please note that, in 10.2, 11.1 and 11.2 the fix is available as Patch: 8643311. The bug is fixed in 11.2.0.2.

References
BUG:5955927 - ORA-600[12333] OCCURRED WHILE INSERTING.

2. ORA-00600 [12333] When Update On Two Clob Columns [ID 464321.1]

In this Document
Symptoms
Cause
Solution
References

--------------------------------------------------------------------------------

Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.3 - Release: 10.2 to 10.2
Information in this document applies to any platform.
Symptoms
o ORA-00600 [12333] is raised during update on two clob columns or insert of long datatype.

o Stack trace is similar to:

ksedst ksedmp ksfdmp kgeriv kgesiv ksesic3 opitsk opiino opiodr opidrv sou2o opimai_real main
Cause
This is Bug 5926074
Abstract: ORA-600 [12333] UPDATE CLOB

If you update on two clob columns and you get ora-600[12333], then you hit this bug.
Solution
There is no workaround.
This issue is fixed in Oracle server version 10.2.0.4.0, 11.1.0.6.0 and above.

One-off patches may be available depending on your current release and operating system.
To obtain a patch from MetaLink:
1) Click on Patches.
2) Click on Simple Search
3) Enter patch number: 5926074
4) Select your O/S
5) Click Go.
References
BUG:5926074 - ORA-600 [12333] UPDATE CLOBNOTE:35928.1 - ORA-600 [12333] "Fatal Two-Task Protocol

Violation"NOTE:389713.1 - Understanding and Diagnosing ORA-00600 [12333] / ORA-3137 [12333] ErrorsBUG:6694843 -

RECEIVING SPORADIC ORA-00600 [12333] ON INSERT OF LONG DATATYPE.

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

转载于:http://blog.itpub.net/28227905/viewspace-1060268/