--- PROTOCOL VIOLATION DETECTED ---
- From: "Carlson, Todd" <tcarlson@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 22 Feb 2007 12:49:12 -0600
Hey Guys,
We built an application using PL/SQL & RLS with 10g on W2K. We just
patched test database to 10.2.0.3 from 10.2.0.2 and the developers are
reporting periodic errors for a single user. The session created the
below trace file. There is nothing in the alert.log, there is nothing in
our internal PL/SQL log table and the user is returned the error
"protocol violation". Has anyone every seen this before? Metalink and
other sources have given me no information.
Dump file c:\oracle\admin\qabwnus\udump\qabwnus_ora_1936.trc
Thu Feb 22 10:45:36 2007
ORACLE V10.2.0.3.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Release 10.2.0.3.0 - Production
Windows 2000 Version V5.0 Service Pack 3
CPU : 2 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:463M/1535M, Ph+PgF:3499M/4577M, VA:1500M/2047M
Instance name: qabwnus
Redo thread mounted by this instance: 1
Oracle process number: 41
Windows thread id: 1936, image: ORACLE.EXE (SHAD)
*** 2007-02-22 10:45:36.054
*** SERVICE NAME:(qabwnus.tripos.com) 2007-02-22 10:45:36.007
*** SESSION ID:(29.11497) 2007-02-22 10:45:36.007
--- PROTOCOL VIOLATION DETECTED ---
sqltxt(14446B84)=BEGIN
NOTEBOOK.PKG_APPL_SECURITY_MGMNT_PUBLIC.load_user(:1,:2,:3,:4); END;
hash=f601a149f5958bb08a7e5b4e6a26e521
parent=1E942434 maxchild=01 plk=16C38690 ppn=n
cursor instantiation=0C5922A4 used=1172162733
child#0(17FE5114) pcs=1E942638
clk=16C61190 ci=1498567C pn=1F2BC544 ctx=19C3D384
kgsccflg=0 llk[0C5922A8,0C5922A8] idx=0
xscflg=c0110676 fl2=d000008 fl3=42222008 fl4=100
kkscoacd
Bind#0
oacdty=01 mxl=8192(4001) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000010 frm=01 csi=873 siz=8192 off=0
kxsbbbfp=0c771564 bln=8192 avl=10 flg=05
value="cgalbraith"
Bind#1
oacdty=102 mxl=64(64) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000000 frm=01 csi=873 siz=192 off=0
kxsbbbfp=0b1a34a8 bln=64 avl=04 flg=05
value=
Dump of memory from 0x0B1A34A8 to 0x0B1A34AC
B1A34A0 0000003B [;...]
Bind#2
oacdty=102 mxl=64(64) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000000 frm=01 csi=873 siz=0 off=64
kxsbbbfp=0b1a34e8 bln=64 avl=04 flg=01
value=
Dump of memory from 0x0B1A34E8 to 0x0B1A34EC
B1A34E0 0000003E [>...]
Bind#3
oacdty=102 mxl=64(64) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000000 frm=01 csi=873 siz=0 off=128
kxsbbbfp=0b1a3528 bln=64 avl=04 flg=01
value=
Dump of memory from 0x0B1A3528 to 0x0B1A352C
B1A3520 0000003F [?...]
Frames pfr 0C579094 siz=320 efr 0C579038 siz=312
kxscphp 0AC96124 siz=1000 inu=0 nps=288
kxscbhp 0B1526F4 siz=9204 inu=0 nps=8540
Thanks,
Todd Carlson
Manager, Database Technologies
Tripos, Inc.
(314) 951-3246
Other related posts:
- » --- PROTOCOL VIOLATION DETECTED ---
