--- PROTOCOL VIOLATION DETECTED ---

From: Carlson, Todd <tcarlson_at_tripos.com>
Date: Thu, 22 Feb 2007 12:49:12 -0600
Message-ID: <4E6AB84EE260DE49B1BCCBCAC72CE1B30197F618@S01-VWFPS034VB.tripos.com>

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  

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 22 2007 - 12:49:12 CST