This discussion is archived
5 Replies Latest reply: Jan 17, 2013 5:58 AM by Osama_Mustafa RSS

ORA 3137 TTC protocol internal error

985483 Newbie
Currently Being Moderated
Hi,

I have a new DB 11.2.0.1.

I sent in alert and trace directory but I didnt find any information.

I need help, could somebody send me?
  • 1. Re: ORA 3137 TTC protocol internal error
    Niket Kumar Pro
    Currently Being Moderated
    what info you are searching for?
  • 2. Re: ORA 3137 TTC protocol internal error
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Refer to
    OERR: ORA-3137 "TTC protocol internal error : [n] []" Master Note [ID 1388487.1]
  • 3. Re: ORA 3137 TTC protocol internal error
    985483 Newbie
    Currently Being Moderated
    Hi

    I would like to find a patch to resolve ths problem, becouse I dont have idea
  • 4. Re: ORA 3137 TTC protocol internal error
    985483 Newbie
    Currently Being Moderated
    The file ../alert/ is

    <msg time='2013-01-17T08:32:11.627+01:00' org_id='oracle' comp_id='rdbms'
    msg_id='2264250469' type='INCIDENT_ERROR' level='1'
    host_id='bender' host_addr='192.168.12.7' prob_key='ORA 3137 [12333]'
    upstream_comp='' downstream_comp='' ecid=''
    errid='640260' detail_path='/u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_28186.trc'>
    <txt>Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_28186.trc (incident=640260):
    ORA-03137: Error interno de protocolo TTC: [12333] [5] [196] [6] [] [] [] []



    The file ../trace/ is

    hstpro: 6
    hstccs: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.12.7)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL)(CID=(PROGRAM=F:\Calzados\bin\mic2000.exe)(HOST=PC-FELIX)(USER=OFICINA))))
    --- dump of hsttti ---
    00AA4B550 00 04 01 0C 0E 09 0B 0F 04 0A 03 03 01 00 00 0A [................]
    00AA4B560 00 00 00 00 00 2F 30 01 01 01 01 01 01 01 01 01 [...../0.........]
    00AA4B570 06 06 00 00 00 00 00 07 03 03 00 00 00 00 00 00 [................]
    00AA4B580 00 00 00 00 00 00 00 00 00 00 13 00 00 00 00 00 [................]
    00AA4B590 00 00 00 00 0C 00 00 00 00 00 14 00 00 00 00 00 [................]
    00AA4B5A0 00 00 00 00 00 00 00 00 00 00 00 0D 00 00 11 11 [................]
    00AA4B5B0 04 09 00 00 01 01 05 00 22 00 12 00 13 13 15 15 [........".......]
    00AA4B5C0 17 17 17 17 21 03 00 00 03 13 13 13 00 00 00 00 [....!...........]
    00AA4B5D0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
    00AA4B5E0 00 00 04 2E 00 00 00 00 0F 0F 0F 1F 20 00 00 00 [............ ...]
    00AA4B5F0 00 00 00 00 00 00 00 00 00 00 00 00 0F 00 00 00 [................]
    00AA4B600 00 00 01 01 01 01 01 01 2A 2A 2A 2A 2A 2B 2B 00 [........*****++.]
    00AA4B610 00 00 00 23 23 23 00 00 00 00 00 00 00 00 00 00 [...###..........]
    00AA4B620 22 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ["...............]
    00AA4B630 00 00 00 00 00 00 00 35 2A 05 00 00 00 00 00 00 [.......5*.......]
    00AA4B640 00 13 00 00 00 00 00 00 00 00 00 00 00 00 00 36 [...............6]
    00AA4B650 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
    00AA4B660 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
    00AA4B670 00 00 03 01 03 01 01 00 00 00 03 03 03 01 03 03 [................]
    00AA4B680 03 03 01 01 03 03 03 03 03 03 00 03 03 03 03 01 [................]
    00AA4B690 03 03 03 03 00 00 00 03 03 03 00 03 00 03 03 03 [................]
    00AA4B6A0 03 03 01 03 03 03 03 01 03 03 01 00 03 01 00 00 [................]
    00AA4B6B0 00 00 03 03 00 00 00 03 00 00 00 03 00 00 00 00 [................]
    00AA4B6C0 00 00 00 00 00 00 00 00 00 00 00 00 03 03 03 03 [................]
    00AA4B6D0 03 03 03 03 03 03 03 01 00 03 03 01 01 03 03 03 [................]
    00AA4B6E0 03 03 00 00 03 03 03 03 00 00 00 00 00 03 03 03 [................]
    00AA4B6F0 03 03 03 03 03 03 03 03 03 03 03 03 00 03 03 03 [................]
    00AA4B700 03 03 00 00 00 00 00 00 00 00 00 00 00 00 00 00 [................]
    00AA4B710 00 03 03 00 00 00 03 03 03 03 03 03 03 03 03 03 [................]
    00AA4B720 00 00 03 03 03 03 03 03 03 03 03 03 03 03 03 03 [................]

    *** 2013-01-17 08:32:12.081
    Incident 640260 created, dump file: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_640260/orcl_ora_28186_i640260.trc
    ORA-03137: Error interno de protocolo TTC: [12333] [5] [196] [6] [] [] [] []
    ....
    ttcdrvdmplocation: msg-0 ln-252 reporting 3137
    Dumping 'Buffer dump info:' addr=0xaafaf40 size=978 bytes
    Dump of memory from 0xaafaf40 to 0xaafb314
    00AAFAF40 01EE6911 00000002 00000003 00000006 [.i..............]
    00AAFAF50 69EF5E03 00000081 01000000 0000032F [.^.i......../...]
    00AAFAF60 00000D01 00010000 01000000 00000000 [................]
    00AAFAF70 01000000 00000001 00000000 00000101 [................]
    00AAFAF80 00000000 01000000 4553FFFE 5443454C [..........SELECT]
    00AAFAF90 41525420 53415053 4E2E534F 52544D55 [ TRASPASOS.NUMTR]
    00AAFAFA0 41505341 202C4F53 20200A0A 20202020 [ASPASO, ..      ]
    00AAFAFB0 41525420 53415053 462E534F 41484345 [ TRASPASOS.FECHA]


    and the _optim_peek_user_binds=TRUE
  • 5. Re: ORA 3137 TTC protocol internal error
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Open SR its better solution maybe its indicate as bug so you need Patch

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points