ORA-600 [12333] Through Application or ORA-911 Through SQLPLUS (Doc ID 743651.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.2 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.
***Checked for relevance on 31-Jan-2012***

Symptoms

The following error was received in the alert log for a SELECT statement:

ORA-600 [12333], [4], [48], [48],

The trace file shows a Protocol Violation has been detected:

--- PROTOCOL VIOLATION DETECTED --- 
sqltxt(700000093676890)=SELECT /*+ FIRST_ROWS (1) */ * FROM "TEST" WHERE 
"SYM_GRP" = :A0 AND "SYM_KEY" = :A1 AND "SYM_VAL" LIKE :A2 AND ROWNUM <= :A3 
hash=b3308df4c3fb75ef19ef377af51fe08e 
parent=7000000936764d8 maxchild=01 plk=7000000740d24d0 ppn=n 
cursor instantiation=110560dd0 used=1222833806 
child#0(700000093675960) pcs=7000000936760e8 
clk=700000096190210 ci=7000000936755a8 pn=70000007979aa58 ctx=700000093674cf8 
kgsccflg=0 llk[110560dd8,110560dd8] idx=0 
xscflg=c0110676 fl2=d240009 fl3=42222008 fl4=100 
kkscoacd 
Bind#0 
oacdty=96 mxl=32(30) mxlc=00 mal=00 scl=00 pre=00 
oacflg=03 fl2=1000010 frm=01 csi=871 siz=216 off=0 
kxsbbbfp=110686020 bln=32 avl=03 flg=05 
value="001" 
Bind#1 
oacdty=96 mxl=32(30) mxlc=00 mal=00 scl=00 pre=00 
oacflg=03 fl2=1000010 frm=01 csi=871 siz=0 off=32 
kxsbbbfp=110686040 bln=32 avl=10 flg=01 
value="B0851" 
Bind#2 
oacdty=96 mxl=128(42) mxlc=00 mal=00 scl=00 pre=00 
oacflg=03 fl2=1000010 frm=01 csi=871 siz=0 off=64 
kxsbbbfp=110686060 bln=128 avl=01 flg=01 
value=" " 
Bind#3 
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00 
oacflg=01 fl2=1000000 frm=00 csi=00 siz=0 off=192 
kxsbbbfp=1106860e0 bln=22 avl=02 flg=01 
value=###                                             <<<<<<<<<<<-------
An invalid number has been seen.Memory contents are : <<<<<<<<<<<-------  

Dump of memory from 0x00000001106860E0 to 0x00000001106860E2 
1106860E0 30310000 [01..] 
Frames pfr 11056c528 siz=3728 efr 11056c468 siz=3704 
kxscphp 11051ba18 siz=984 inu=728 nps=632 
kxscdfhp 1105ea3b8 siz=984 inu=88 nps=0 
kxscbhp 11052cd88 siz=992 inu=456 nps=240 
kxscefhp 1105ff6e8 siz=4056 inu=40 nps=40 
-------------------- 
PROTOCOL VIOLATION 
-------------------- 

In SQLPLUS, the correct error is displayed:

SQL> SELECT /*+ FIRST_ROWS (1) */ * FROM "TEST" WHERE "SYM_GRP" = '001' AND "SYM_KEY"
 ='B0851' AND "SYM_VAL" LIKE ' ' AND ROWNUM<=###; 
                                                                                 
                     
ERROR at line 1: 
ORA-00911: invalid character

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms