ORA-00600: internal error code, arguments: [12333], [6], [0], [68], [], [], [], []

One of the first ORA-600 errors I encounter as an Oracle DBA. I am both excited and nervous about it. I always had the perception that ORA-600 errors will crash the database and is not able to be troubleshoot by us. This is definitely not the case.

Output from Oracle alert log

Fri Aug 23 14:44:29 SGT 2013
Errors in file /u01/app/oracle/admin/orcl/udump/orcl_ora_18546844.trc:
ORA-00600: internal error code, arguments: [12333], [6], [0], [68], [], [], [], []
Fri Aug 23 14:44:31 SGT 2013
Errors in file /u01/app/oracle/admin/orcl/udump/orcl_ora_13107366.trc:
ORA-00600: internal error code, arguments: [12333], [16], [0], [76], [], [], [], []
Fri Aug 23 14:46:56 SGT 2013

Output from Oracle trace files.

Dump file /u01/app/oracle/admin/orcl/udump/orcl_ora_13107366.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/10.2.0
System name: AIX
Node name: hostname
Release: 1
Version: 6
Machine: <machine_id>
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 52
Unix process pid: 13107366, image: oracle@hostname
*** SERVICE NAME:(SYS$USERS) 2013-08-23 14:44:31.928
*** SESSION ID:(506.31556) 2013-08-23 14:44:31.928
--------------------
 PROTOCOL VIOLATION
--------------------
-----Page before-----
11049C6C0 03 52 02 01 00 00 00 00 00 00 00 01 00 01 00 01 [.R..............]
11049C6D0 00 02 08 00 01 00 01 00 00 00 00 00 01 00 01 10 [................]
11049C6E0 00 4C [.L]
-----Current Page-----
nsbfdbpt 11049c6c0
ifccrcp = 11049c6e2, ifccrcl = 11049c7aa
buffer length = 200
11049C6E0 00 42 00 4C 00 55 00 53 00 52 00 33 00 32 [.B.L.U.S.R.3.2]
11049C6F0 1E 00 53 00 47 00 41 00 2D 00 55 00 30 00 38 00 [..S.G.A.-.U.0.8.]
11049C700 30 00 30 00 33 00 32 00 4C 00 30 00 30 00 33 26 [0.0.3.2.L.0.0.3&]
11049C710 00 41 00 50 00 5C 00 53 00 47 00 41 00 2D 00 55 [.A.P.\.S.G.A.-.U]
11049C720 00 30 00 38 00 30 00 30 00 33 00 32 00 4C 00 30 [.0.8.0.0.3.2.L.0]
11049C730 00 30 00 33 00 00 0A 00 38 00 30 00 30 00 33 00 [.0.3....8.0.0.3.]
11049C740 32 12 00 35 00 34 00 39 00 32 00 3A 00 37 00 33 [2..5.4.9.2.:.7.3]
11049C750 00 38 00 38 FE 40 00 43 00 3A 00 5C 00 55 00 73 [.8.8.@.C.:.\.U.s]
11049C760 00 65 00 72 00 73 00 5C 00 38 00 30 00 30 00 33 [.e.r.s.\.8.0.0.3]
11049C770 00 32 00 5C 00 44 00 65 00 73 00 6B 00 74 00 6F [.2.\.D.e.s.k.t.o]
11049C780 00 70 00 5C 00 4C 00 61 00 62 00 65 00 6C 00 20 [.p.\.L.a.b.e.l. ]
11049C790 00 44 00 65 00 73 12 00 69 00 67 00 6E 00 65 00 [.D.e.s..i.g.n.e.]
11049C7A0 72 00 2E 00 6C 00 6E 00 6B 00 [r...l.n.k.]
hstflg: 0x40202991
hstcflg: 0x00000000
hstpro: 4
hstccs: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=hostname.domain.com)(Port=1521)))(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=DESIGN.EXE)(HOST=clientpc)(USER=client))))
--- dump of hsttti ---
1100D4140 00 04 01 0C 0E 09 0B 0F 04 0A 03 03 01 00 00 0A [................]
1100D4150 00 00 00 00 00 00 00 01 01 05 05 01 05 05 05 05 [................]
1100D4160 06 06 00 00 00 00 00 08 03 03 00 00 00 00 00 00 [................]
1100D4170 00 00 00 00 00 00 00 00 00 00 13 00 00 00 00 00 [................]
1100D4180 00 00 00 00 0C 00 00 00 00 00 14 00 00 00 00 00 [................]
1100D4190 00 00 00 00 00 00 00 00 00 00 00 0D 00 00 11 11 [................]
1100D41A0 04 09 00 00 00 00 05 00 22 00 12 00 13 00 15 00 [........".......]
1100D41B0 00 00 00 00 21 00 00 00 00 13 13 13 00 00 00 00 [....!...........]
1100D41C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
1100D41D0 00 00 00 00 00 00 00 00 0F 0F 0F 1F 20 00 00 00 [............ ...]
1100D41E0 00 00 00 00 00 00 00 00 00 00 00 00 0F 00 00 00 [................]
1100D41F0 00 00 00 00 00 00 00 00 2A 00 00 00 00 00 00 00 [........*.......]
1100D4200 00 00 00 23 23 23 00 00 00 00 00 00 00 00 00 00 [...###..........]
1100D4210 22 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ["...............]
1100D4220 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
1100D4230 00 13 00 00 00 00 00 00 00 00 00 00 00 00 00 35 [...............5]
1100D4240 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
1100D4250 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
1100D4260 00 00 03 01 03 03 03 00 00 00 03 03 03 03 03 03 [................]
1100D4270 03 03 03 03 03 03 03 03 03 03 00 03 03 03 03 03 [................]
1100D4280 03 03 03 03 00 00 00 03 03 03 00 03 00 03 03 03 [................]
1100D4290 03 03 03 03 03 03 03 01 00 03 03 00 03 03 00 00 [................]
1100D42A0 00 00 03 03 00 00 00 03 00 00 00 00 00 00 00 00 [................]
1100D42B0 00 00 00 00 00 00 00 00 00 00 00 00 16 00 00 00 [................]
1100D42C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
1100D42D0 00 00 00 00 1B 00 00 00 00 00 00 00 00 00 00 00 [................]
1100D42E0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
1100D42F0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
1100D4300 00 00 1C 00 00 00 00 00 00 00 00 00 00 00 00 1E [................]
1100D4310 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
1100D4320 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
1100D4330 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
1100D4340 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
1100D4350 00 00 00 00 1A 00 00 00 00 00 00 00 00 [.............]
ttclxlccst: 31
ttclxrccst: 799
ttclxlncst: 2000
ttclxrncst: 2000
ttclxccl2nr: 2
ttclxccn2lr: 1
ttclxncl2nr: 1
ttclxrncminbpc: 2
ttclxrncmaxbpc: 2
ttclxflags: 0x03
prev funcode: 0x52
*** 2013-08-23 14:44:31.929
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [12333], [16], [0], [76], [], [], [], []
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst+001c bl ksedst1 000000000 ? 000000000 ?
ksedmp+0290 bl ksedst 104C20D10 ?
ksfdmp+02d8 bl 03F35754
kgeriv+0108 bl _ptrgl
kgesiv+0080 bl kgeriv 000000013 ? 1100D8640 ?
 000000000 ? 00000000A ?
 1100D3E68 ?
ksesic3+0060 bl kgesiv 1053061F8 ? 000000003 ?
 110264C58 ?
 800000000000F032 ?
 3FFC000000000003 ?
opitsk+0efc bl 01FC4AD8
opiino+09d0 bl opitsk 0FFFFD6E0 ? 000000000 ?
opiodr+0b2c bl _ptrgl
opidrv+04a4 bl opiodr 3C1028EEB8 ? 404C73BD8 ?
 FFFFFFFFFFFF6A0 ? 01028EEB0 ?
sou2o+0090 bl opidrv 3C02A2901C ? 4A006E540 ?
 FFFFFFFFFFFF6A0 ?
opimai_real+01bc bl 01FC3894
main+0098 bl opimai_real 000000000 ? 000000000 ?
__start+0070 bl main 000000000 ? 000000000 ?

Root Cause:

Due to incompatible NLS client setting on the clientpc. [MOS 77442.1 ]

Advertisements
  1. #1 by Ed on October 31, 2013 - 18:08

    Thanks WeiShan… I was looking for the error “ORA-00600: internal error code, arguments: [12333], [16], [0],” and found your post and got my issue fixed. Thanks again!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: