Skip to Main Content

Español

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Victor EndaraAug 18 2017 — edited Oct 18 2017

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:

pastedImage_6.png

Error on sqlplus client forms 6i

pastedImage_0.png

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

| PARAMETER | VALUE |
| NLS_RDBMS_VERSION | 12.2.0.1.0 |
| NLS_NCHAR_CONV_EXCP | FALSE |
| NLS_LENGTH_SEMANTICS | BYTE |
| NLS_COMP | BINARY |
| NLS_DUAL_CURRENCY | $ |
| NLS_TIMESTAMP_TZ_FORMAT | DD-MON-RR HH.MI.SSXFF AM TZR |
| NLS_TIME_TZ_FORMAT | HH.MI.SSXFF AM TZR |
| NLS_TIMESTAMP_FORMAT | DD-MON-RR HH.MI.SSXFF AM |
| NLS_TIME_FORMAT | HH.MI.SSXFF AM |
| NLS_SORT | BINARY |
| NLS_DATE_LANGUAGE | AMERICAN |
| NLS_DATE_FORMAT | DD-MON-RR |
| NLS_CALENDAR | GREGORIAN |
| NLS_NUMERIC_CHARACTERS | ., |
| NLS_NCHAR_CHARACTERSET | AL16UTF16 |
| NLS_CHARACTERSET | WE8MSWIN1252 |
| NLS_ISO_CURRENCY | AMERICA |
| NLS_CURRENCY | $ |
| NLS_TERRITORY | AMERICA |
| NLS_LANGUAGE | AMERICAN |

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?

Comments
Post Details
Added on Aug 18 2017
2 comments
12,378 views