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 MARCH 28, 2017

Applies to:

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

Symptoms

Target Database: (OracleDatabase version: 12.1.0.2.0).
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: 140] [userId: <anonymous>] [ecid: 0000LQxHLGI1f_aPTM7EDc1NjSF^000002,0:2851:54:48] [APP: oraclediagent] [oracle.odi.runtime.MrepExtId: 1452272708996] [oracle.odi.runtime.AgentName: OracleDIAgent] [oracle.odi.runtime.ExecPhase: ExecuteTask] [oracle.odi.runtime.OdiUser: SUPERVISOR] [oracle.odi.runtime.WrepName: WORKREP] [oracle.odi.runtime.EntityGuid: 5156f522-8080-478f-902d-182a9cd1d975] [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 IDW_TARGET.I$_TEMP_TARGET
]]

 

Error seen in alert log:

NI cryptographic checksum mismatch error: 12599.

VERSION INFORMATION:
TNS for Linux: Version 12.1.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 12.1.0.2.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 12.1.0.2.0 - 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



Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms