Last updated on NOVEMBER 28, 2016
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.2Information 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 characterCause
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