5 Replies Latest reply: Jan 17, 2013 7:58 AM by Osama_Mustafa RSS

    ORA 3137 TTC protocol internal error

    985483
      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
          what info you are searching for?
          • 2. Re: ORA 3137 TTC protocol internal error
            Osama_Mustafa
            Refer to
            OERR: ORA-3137 "TTC protocol internal error : [n] []" Master Note [ID 1388487.1]
            • 3. Re: ORA 3137 TTC protocol internal error
              985483
              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
                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
                  Open SR its better solution maybe its indicate as bug so you need Patch