My Oracle Support Banner

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

Last updated on JANUARY 28, 2020

Applies to:

Oracle Net Services - Version 12.2.0.1 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution

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