My Oracle Support Banner

TNS-12599 and IO Error: Checksum fail When Using Encryption and Checksum with Data Integrity Types SHA256, SHA384 and SHA512 (Doc ID 2199844.1)

Last updated on AUGUST 01, 2019

Applies to:

JDBC - Version and later
Information in this document applies to any platform.


Target Database: (OracleDatabase version:
Database has been hardened with the following in the sqlnet.ora file:

and fails reporting the following exception:

[2016-08-24T12:19:28.250-04:00] [odi_server1] [WARNING] [] [oracle.odi.runtime.agent.execution.sql.SQLCommand] [tid: <TID>] [userId: <USERID>] [ecid: <ECID>] [APP: oraclediagent] [oracle.odi.runtime.MrepExtId: 1452272708996] [oracle.odi.runtime.AgentName: OracleDIAgent] [oracle.odi.runtime.ExecPhase: ExecuteTask] [oracle.odi.runtime.OdiUser: <USER>] [oracle.odi.runtime.WrepName: WORKREP] [oracle.odi.runtime.EntityGuid: <UID>] [oracle.odi.runtime.SessName: STAGE_TO_TARGET_Physical_SESS] [oracle.odi.runtime.SessId: 8502] [oracle.odi.runtime.SessStep: 10/Physical_STEP/1] [oracle.odi.runtime.SessTask: 10.30/Drop flow table,IKM Oracle Incremental Update,null] [oracle.odi.runtime.ExecHierarchy: 8502] SQLCommand execution failure: IO Error: Checksum fail[[
Failed query text:
drop table ...


Error seen in alert log:

NI cryptographic checksum mismatch error: 12599.

TNS for Linux: Version - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version - Production
TCP/IP NT Protocol Adapter for Linux: Version - Production
Time: 24-AUG-2016 12:19:28
Tracing not turned on.
Tns error struct:
ns main err code: 12599

TNS-12599: TNS:cryptographic checksum mismatch
ns secondary err code: 12656
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0




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

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