2 Replies Latest reply on Oct 18, 2017 11:34 AM by gregga

    ORA-03137: : [kpoal8Check-5] [0] [0x000000000] [0x000000000] [0] [0] [2080] []

    Victor Endara

      Estoy migrando  de Oracle 10.2.0.3 a 12.2.0.1 en las pruebas con un aplicativo desarrollado en forms 6i se me esta generando este error:

       

      Error on sqlplus client forms 6i

       

      alert and tracer on database

      Alertlog

      2017-08-17T16:04:12.039890-05:00

      Errors in file D:\ORACLE\diag\rdbms\d7iprod\d7iprod\trace\d7iprod_ora_1748.trc  (incident=36387):

      ORA-03137: se ha rechazado el paquete de TTC con formato incorrecto del cliente: [kpoal8Check-5] [0] [0x000000000] [0x000000000] [0] [0] [2080] []

      Incident details in: D:\ORACLE\diag\rdbms\d7iprod\d7iprod\incident\incdir_36387\d7iprod_ora_1748_i36387.trc

      2017-08-17T16:04:13.880682-05:00

      Session (47,15454): Bad TTC Packet Detected: Inbound connection from client

      Session (47,15454): Bad TTC Packet Detected: DB Logon User: YANGULO, Remote Machine: CONSORCIO\PC-DSK-125, Program: ORACLE.EXE (SHAD), OS User: bjimenez

      Session (47,15454): Bad TTC Packet Detected: Client IP Address: 192.168.3.96

       

      Tracert

      Trace file D:\ORACLE\diag\rdbms\d7iprod\d7iprod\trace\d7iprod_ora_2256.trc
      Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production
      Build label:    RDBMS_12.2.0.1.0_WINDOWS.X64_170210.4
      Windows NT Version V6.2 
      ORACLE_HOME =  D:\oracle\product\12.2.0\dbhome_1
      Node name           : CSCSRV024
      CPU                 : 4 - type 8664, 4 Physical Cores
      Process Affinity    : 0x0x0000000000000000
      Memory (Avail/Total): Ph:3665M/15359M, Ph+PgF:5772
      VM name             : VMWare Version (6)
      Instance name: d7iprod
      Redo thread mounted by this instance: 1
      Oracle process number: 40
      Windows thread id: 2256, image: ORACLE.EXE (SHAD)


      *** 2017-08-18T12:40:28.214596-05:00
      *** SESSION ID:(14.17011) 2017-08-18T12:40:28.214596-05:00
      *** CLIENT ID:() 2017-08-18T12:40:28.214596-05:00
      *** SERVICE NAME:(D7IPROD) 2017-08-18T12:40:28.214596-05:00
      *** MODULE NAME:(ORACLE.EXE (SHAD)) 2017-08-18T12:40:28.214596-05:00
      *** ACTION NAME:() 2017-08-18T12:40:28.214596-05:00
      *** CLIENT DRIVER:() 2017-08-18T12:40:28.214596-05:00

      DDE: Problem Key 'ORA 3137 [kpoal8Check-5]' was flood controlled (0x2) (incident: 48336)
      ORA-03137: se ha rechazado el paquete de TTC con formato incorrecto del cliente: [kpoal8Check-5] [0] [0x000000000] [0x000000000] [0] [0] [2080] []

      *** 2017-08-18T12:40:31.288245-05:00
      DDE: Problem Key 'ORA 3137 [kpoal8Check-5]' was flood controlled (0x2) (incident: 48337)
      ORA-03137: se ha rechazado el paquete de TTC con formato incorrecto del cliente: [kpoal8Check-5] [0] [0x000000000] [0x000000000] [0] [0] [2080] []

       

      Information Of Database

      OS: WS2012 R2

      Database: 12C 12.2.0.1

      Parameters NLS

      PARAMETERVALUE
      NLS_RDBMS_VERSION12.2.0.1.0
      NLS_NCHAR_CONV_EXCPFALSE
      NLS_LENGTH_SEMANTICSBYTE
      NLS_COMPBINARY
      NLS_DUAL_CURRENCY$
      NLS_TIMESTAMP_TZ_FORMATDD-MON-RR HH.MI.SSXFF AM TZR
      NLS_TIME_TZ_FORMATHH.MI.SSXFF AM TZR
      NLS_TIMESTAMP_FORMATDD-MON-RR HH.MI.SSXFF AM
      NLS_TIME_FORMATHH.MI.SSXFF AM
      NLS_SORTBINARY
      NLS_DATE_LANGUAGEAMERICAN
      NLS_DATE_FORMATDD-MON-RR
      NLS_CALENDARGREGORIAN
      NLS_NUMERIC_CHARACTERS.,
      NLS_NCHAR_CHARACTERSETAL16UTF16
      NLS_CHARACTERSETWE8MSWIN1252
      NLS_ISO_CURRENCYAMERICA
      NLS_CURRENCY$
      NLS_TERRITORYAMERICA
      NLS_LANGUAGEAMERICAN

       

      En las demás aplicaciones no tengo problema solo en la desarrollada en forms

       

      Alguna idea que no sea actualizar el cliente de forms, ya que no tengo fuentes del programa en forms 6i?