My Oracle Support Banner

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 16, 2022

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

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
References


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