ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-600(12333)错误

ORA-600(12333)错误

原创 Linux操作系统 作者:yangtingkun 时间:2012-01-31 23:58:14 0 删除 编辑

前不久才处理了一个ORA-600[12333]错误,不过那个问题是9i上的。

ORA-600(12333)错误和ORA-600(ttclxx1)错误:http://yangtingkun.itpub.net/post/468/526078

 

 

而这个错误是发生在10.2.0.3环境下:

Tue Jan 31 15:31:14 2012
Errors in file /oracle/admin/ORCL/udump/orcl_ora_40960504.trc:
ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []

详细TRACE文件如下:

Dump file /oracle/admin/ORCL/udump/orcl_ora_40960504.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /oracle/orcl/10.2.0
System name:  AIX
Node name:    porcl2
Release: 1
Version: 6
Machine: 00F67AD94C00
Instance name: ORCL
Redo thread mounted by this instance: 1
Oracle process number: 36
Unix process pid: 40960504, image: oracleORCL@porcl2

*** ACTION NAME:() 2012-01-31 15:31:14.454
*** MODULE NAME:(TOAD 10.5.1.3) 2012-01-31 15:31:14.454
*** SERVICE NAME:(SYS$USERS) 2012-01-31 15:31:14.454
*** SESSION ID:(5422.6391) 2012-01-31 15:31:14.454
--------------------
 PROTOCOL VIOLATION
--------------------
-----Page before-----
1108880E0 00 00 00                                         [...]            
-----Current Page-----
nsbfdbpt 1108880e0
ifccrcp = 1108880e3, ifccrcl = 1108888d5
buffer length = 2034
1108880E0          00 00 00 00 00 00 00 00 00 00 00 00 00     [.............]
1108880F0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]
110888100 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]
110888110 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]
110888120 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]
110888130 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]
110888140 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]
110888150 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]
110888160 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]
.
.
.
110888890 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]
1108888A0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]
1108888B0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]
1108888C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]
1108888D0 00 00 00 00 00                                   [.....]          
hstflg:  0x40002991
hstcflg: 0x00000000
hstpro:  5
hstccs:  (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.0.27)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)(CID=(PROGRAM=C:\Program Files\Quest Software\Toad for Oracle 10.5\Toad.exe)(HOST=HOST9)(USER=8000130559))))
--- dump of hsttti ---
1100C9E20 00 04 01 0C 0E 09 0B 0F 04 0A 03 03 01 00 00 0A  [................]
1100C9E30 00 00 00 00 00 00 00 01 01 05 05 01 05 05 05 05  [................]
1100C9E40 06 06 00 00 00 00 00 07 03 03 00 00 00 00 00 00  [................]
1100C9E50 00 00 00 00 00 00 00 00 00 00 13 00 00 00 00 00  [................]
1100C9E60 00 00 00 00 0C 00 00 00 00 00 14 00 00 00 00 00  [................]
1100C9E70 00 00 00 00 00 00 00 00 00 00 00 0D 00 00 11 11  [................]
1100C9E80 04 09 00 00 00 00 05 00 22 00 12 00 13 13 15 15  [........".......]
1100C9E90 17 17 17 17 21 03 00 00 03 13 13 13 00 00 00 00  [....!...........]
1100C9EA0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]
1100C9EB0 00 00 04 2E 00 00 00 00 0F 0F 0F 1F 20 00 00 00  [............ ...]
1100C9EC0 00 00 00 00 00 00 00 00 00 00 00 00 0F 00 00 00  [................]
1100C9ED0 00 00 00 00 00 00 00 00 2A 00 00 00 00 00 00 00  [........*.......]
1100C9EE0 00 00 00 23 23 23 00 00 00 00 00 00 00 00 00 00  [...###..........]
1100C9EF0 22 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  ["...............]
1100C9F00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]
1100C9F10 00 13 00 00 00 00 00 00 00 00 00 00 00 00 00 35  [...............5]
1100C9F20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]
1100C9F30 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]
1100C9F40 00 00 03 01 03 03 03 00 00 00 03 03 03 03 03 03  [................]
1100C9F50 03 03 03 03 03 03 03 03 03 03 00 03 03 03 03 03  [................]
1100C9F60 03 03 03 03 00 00 00 03 03 03 00 03 00 03 03 03  [................]
1100C9F70 03 03 03 03 03 03 03 01 00 03 03 00 03 03 00 00  [................]
1100C9F80 00 00 03 03 00 00 00 03 00 00 00 03 00 00 00 00  [................]
1100C9F90 00 00 00 00 00 00 00 00 00 00 00 00 03 03 03 03  [................]
1100C9FA0 03 03 03 03 03 03 03 03 00 03 03 03 03 03 03 03  [................]
1100C9FB0 03 03 00 00 03 03 03 03 00 00 00 00 00 03 03 03  [................]
1100C9FC0 03 03 03 03 03 03 03 03 03 03 03 03 00 03 03 03  [................]
1100C9FD0 03 03 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]
1100C9FE0 00 00 1C 00 00 00 00 00 00 00 24 25 26 27 28 1E  [..........$%&'(.]
1100C9FF0 00 00 00 2D 00 00 03 03 03 03 03 03 03 03 03 03  [...-............]
1100CA000 03 03 03 2C 00 00 00 00 00 00 00 00 00 00 00 00  [...,............]
1100CA010 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]
1100CA020 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  [................]
1100CA030 00 00 00 00 1A 00 00 00 00 00 00 00 00           [.............]  
ttclxlccst:     871
ttclxrccst:     871
ttclxlncst:     2000
ttclxrncst:     2000
ttclxccl2nr:    1
ttclxccn2lr:    1
ttclxncl2nr:    1
ttclxncn2lr:    1
ttclxrccminbpc: 1
ttclxrccmaxbpc: 3
ttclxrncminbpc: 2
ttclxrncmaxbpc: 2
ttclxflags:     0x23
prev funcode: 0x5e
*** 2012-01-31 15:31:14.470
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []
Current SQL statement for this session:
Select CREATED, LAST_DDL_TIME, OBJECT_ID, STATUS, TIMESTAMP
FROM SYS.ALL_OBJECTS
WHERE object_name = :nm
AND   object_type = :t
AND   owner = :o
----- Call Stack Trace -----
calling              call     entry                argument values in hex     
location             type     point                (? means dubious value)    
-------------------- -------- -------------------- ----------------------------
ksedst+001c          bl       ksedst1              900000000312A74 ? 000000000 ?
ksedmp+0290          bl       ksedst               1048E2120 ?
ksfdmp+0018          bl       03F34B6C            
kgeriv+0108          bl       _ptrgl              
kgesiv+0080          bl       kgeriv               000000013 ? 1100D1010 ?
                                                   000000000 ? 00000000A ?
                                                   1100C9B50 ?
ksesic3+0060         bl       kgesiv               104F4E830 ? 000000023 ?
                                                   11025E118 ?
                                                   800000000000F032 ?
                                                   3FFC000000000003 ?
opitsk+0ec0          bl       01FA62EC            
opiino+0990          bl       opitsk               000010860 ? 000000000 ?
opiodr+0adc          bl       _ptrgl              
opidrv+0474          bl       opiodr               3C1028E590 ? 4102909B0 ?
                                                   FFFFFFFFFFFF490 ? 0A0082608 ?
sou2o+0090           bl       opidrv               3C02AB579C ? 4A0071248 ?
                                                   FFFFFFFFFFFF490 ?
opimai_real+01bc     bl       01FA4A34            
main+0098            bl       opimai_real          000000000 ? 000000000 ?
__start+0070         bl       main                 000000000 ? 000000000 ?

--------------------- Binary Stack Dump ---------------------

这个600错误和其他的错误并不相同,上来不是错误信息和错误SQL,而是直接的页面DUMP信息,而且一开始就包含了协议冲突的错误信息。

经分析,问题的描述可以参考文档Bug 8625762  ORA-3137 [12333] due to bind data not read from wire。导致问题的原因在于网络连接中包含的绑定变量信息未被读取。

这个bug影响范围比较广,10.2.0.410.2.0.511.1.0.611.1.0.7都可能存在这个问题,而如果要解决这个问题,需要将版本升级到11.2.0.111.1.0.7.3,如果是10.2版本想要通过专门的补丁来修正这个问题,那么至少要先将数据库版本升级到10.2.0.4.3

除了打补丁和升级之外,还可以尝试通过设置隐含参数"_optim_peek_user_binds"false来避免这个bug

 

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

上一篇: ORA-610内部错误
下一篇: Oracle VM用户手册
请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-29

  • 博文量
    1955
  • 访问量
    10389361