Intermittent ORA-174012 Protocol Violation Messages Are Received When Reading Data With ojdbc6.jar And Java 1.6 32-bit On Solaris 64-bit Machine (Doc ID 1245755.1)

Last updated on JUNE 28, 2016

Applies to:

Oracle Data Integrator - Version 4.1.01.01 and later
Information in this document applies to any platform.
*** Checked for ODI 11g compliance on 12-SEP-2012 ***

Symptoms

Intermittent "Protocol violation" (ORA-17401) messages are signaled when using Oracle Data Integrator (ODI) -- or pure Java code -- to execute a SELECT statement that reads a large amount of data from an Oracle database using a JDBC Driver.

The ODI Agent / Java code is running on Oracle Solaris 64-bit operating system, and uses:

Changes

The issue only occurs when the executions are performed on Solaris 64-bit platform, with a 32-bit Java Machine 1.6, and the ojdbc6.jar Oracle JDBC driver.

Below is a brief description of tests that have been run:

In conclusion:
  1. The behavior is not Java version related. It has been tested with JVM 1.5, 1.6.0_18 and 1.6.0_21.
  2. The behavior only occurs on the Solaris 64-bit machine, when the ojdbc6.jar file of Oracle JDBC driver 11.1 0 7.0 and/or 11.2.0.1.0 is used.
  3. The change of the Oracle Listener settings to use port 1542 instead of 1521 do not resolve the issue.

 

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