5 Replies Latest reply: Aug 31, 2013 3:23 AM by user810933 RSS

    ORA-03137: TTC protocol internal error : [12333] [4] [195] [2] [] [] [] []

    726962
      Hello everyone,

      We are receiving below errors intermittently in our Oracle 11g RAC (2 node) production database :

      Errors in file /opt/oracle/diag/rdbms/omnidb/OMNIDB2/trace/OMNIDB2_ora_26729.trc:
      ORA-03137: TTC protocol internal error : [12333] [4] [195] [2] [] [] [] []

      Trace file details :
      $ more /opt/oracle/diag/rdbms/omnidb/OMNIDB2/trace/OMNIDB2_ora_26729.trc
      Trace file /opt/oracle/diag/rdbms/omnidb/OMNIDB2/trace/OMNIDB2_ora_26729.trc
      Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
      With the Real Application Clusters option
      ORACLE_HOME = /opt/oracle/product/11.1.0/db_1
      System name: Linux
      Node name: atlprodora12.atlprod.corp
      Release: 2.6.18-164.6.1.el5
      Version: #1 SMP Tue Oct 27 11:28:30 EDT 2009
      Machine: x86_64
      Instance name: OMNIDB2
      Redo thread mounted by this instance: 2
      Oracle process number: 53
      Unix process pid: 26729, image: oracle@atlprodora12.atlprod.corp


      *** 2010-04-09 07:44:47.844
      *** SESSION ID:(104.34825) 2010-04-09 07:44:47.844
      *** CLIENT ID:() 2010-04-09 07:44:47.844
      *** SERVICE NAME:(OMNIDB.ATLPROD.CORP) 2010-04-09 07:44:47.844
      *** MODULE NAME:(w3wp.exe) 2010-04-09 07:44:47.844
      *** ACTION NAME:() 2010-04-09 07:44:47.844

      --- PROTOCOL VIOLATION DETECTED ---
      ----- Dump Cursor sql_id=aw1pkn2cym6c7 xsc=0x2b98be3de900 cur=0x2b98bd981bd8 -----
      Dump Parent Cursor sql_id=aw1pkn2cym6c7 phd=0x1008f8780 plk=0xb85deaf8
      sqltxt(0x1008f8780)=SELECT oc.company_id, oc.name, oc.domain_id
      FROM ompp_company oc INNER JOIN ompp_user_vs_company uc
      ON oc.company_id = uc.associated_company_id
      WHERE user_id = :user_id
      ORDER BY lower(oc.name)
      hash=3c612e13799e490cae06b2a099e99987
      parent=0xfd4dd100 maxchild=26 plk=0xb85deaf8 ppn=n
      cursor instantiation=0x2b98be3de900 used=1270813487 exec_id=33559153 exec=1
      child#25(0xc486e830) pcs=0xb4d5d7f8
      clk=0xb85de908 ci=0xb4d5d4c8 pn=0xb846d388 ctx=0xc7cb1840
      kgsccflg=0 llk[0x2b98be3de908,0x2b98be3de908] idx=0
      xscflg=c0110676 fl2=5d000008 fl3=42222008 fl4=180
      sharing failure(s)=800100000000
      ----- Bind Info (kkscoacd) -----
      Bind#0
      oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
      oacflg=03 fl2=1000000 frm=00 csi=00 siz=24 off=0
      kxsbbbfp=2b98be40e790 bln=22 avl=00 flg=05
      Frames pfr 0x2b98be3f7540 siz=7664 efr 0x2b98be3f7480 siz=7632
      kxscphp=0x2b98be3dfaf8 siz=984 inu=376 nps=328
      kxscbhp=0x2b98bd992118 siz=984 inu=168 nps=48
      kxscwhp=0x2b98bd991b78 siz=4056 inu=1552 nps=656
      Starting SQL statement dump
      SQL Information
      user_id=66 user_name=FPWEB module=w3wp.exe action=
      sql_id=aw1pkn2cym6c7 plan_hash_value=-527506260 problem_type=4
      ----- Current SQL Statement for this session (sql_id=aw1pkn2cym6c7) -----
      SELECT oc.company_id, oc.name, oc.domain_id
      FROM ompp_company oc INNER JOIN ompp_user_vs_company uc
      ON oc.company_id = uc.associated_company_id
      WHERE user_id = :user_id
      ORDER BY lower(oc.name)
      sql_text_length=236
      sql=SELECT oc.company_id, oc.name, oc.domain_id
      FROM ompp_company oc INNER JOIN ompp_user_vs_company uc
      ON oc.company_id = uc.associated_company_id
      WHERE user_id = :user_id
      ORDER BY lower(oc.name)
      ====================== END SQL Statement Dump ======================
      ttcdrvdmp: msg-4 ln-971 reporting 12333


      Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
      PL/SQL Release 11.1.0.6.0 - Production
      CORE 11.1.0.6.0 Production
      TNS for Linux: Version 11.1.0.6.0 - Production
      NLSRTL Version 11.1.0.6.0 - Production

      STANDARD EDITION -

      Server Details:
      uname -a
      Linux 2.6.18-164.6.1.el5 #1 SMP Tue Oct 27 11:28:30 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux

      I raised SR for the same - Unfortunately the Oracle Support have every poor response ( even after 4 days they have not responded my SR) so I'm approching the forum for my luck. If any one got such internal errors and able to find any fix please share.

      Thanks in advance .

      Pavan