After Upgrade Database to Release 12.2: ORA-3137 12569 Errors in Alert.log or Incident Traces (Doc ID 2540948.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

 Following an upgrade of the database, JDBC Thin client connection can throw the following errors in incident traces:


Alert log:

2019-04-30T12:01:39.077605-04:00
Errors in file /opt/oracle/diag/diag/rdbms/database/instance1/trace/instance1_ora_57369.trc  (incident=169482):
ORA-03137: malformed TTC packet from client rejected: [12569] [94] [] [] [] [] [] []
Incident details in: /opt/oracle/diag/diag/rdbms/database/instance1/incident/incdir_169482/instance1_ora_57369_i169482.trc
2019-04-30T12:01:40.395633-04:00
Session (811,13950): Bad TTC Packet Detected: Inbound connection from client
Session (811,13950): Bad TTC Packet Detected: DB Logon User: USERNAME, Remote Machine: remote_host, Program:your_app@remote machine (TNS V1-V3), OS User: OS_USER
Session (811,13950): Bad TTC Packet Detected: Client IP Address:  xxx.yyy.zzz.aa

*** 2019-04-30T12:01:39.079938-04:00
*** SESSION ID:(811.13950) 2019-04-30T12:01:39.079956-04:00
*** CLIENT ID:() 2019-04-30T12:01:39.079963-04:00
*** SERVICE NAME:(SERVICE_NAME) 2019-04-30T12:01:39.079970-04:00
*** MODULE NAME:(your_app@remote_host (TNS V1-V3)) 2019-04-30T12:01:39.079977-04:00
*** ACTION NAME:() 2019-04-30T12:01:39.079984-04:00
*** CLIENT DRIVER:() 2019-04-30T12:01:39.079990-04:00
 
[TOC00000]
Jump to table of contents
Dump continued from file: /opt/oracle/diag/diag/rdbms/database/instance1/trace/instance1_ora_57369.trc
[TOC00001]
ORA-03137: malformed TTC packet from client rejected: [12569] [94] [] [] [] [] [] []
ORA-3137
[TOC00001-END]
[TOC00002]

Error Stack:
 ORA-03137: malformed TTC packet from client rejected: [12569] [94] [] [] [] [] [] []
 
Stack:
ksedst <- dbkedDefDump <- ksedmp <- dbgexPhaseII <- dbgexProcessError
 <- dbgePostErrorKGE <- dbkePostKGE_kgsf <- kgeade <- kgerelv <- kgerev <- opiierr
  <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real
   <- ssthrdmain <- main

These parameters are present in the server side sqlnet.ora file.

SQLNET.ENCRYPTION_SERVER = (requested)
SQLNET.CRYPTO_CHECKSUM_CLIENT = (requested)

Changes

 The database has recently been upgraded to release 12.2

SQLNET.ENCRYPTION_SERVER = (requested)
SQLNET.CRYPTO_CHECKSUM_CLIENT = (requested)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.