Intermittently Error ORA-12155 Thrown Using JDBC Thin Driver Using Query Timeout (Doc ID 433190.1)

Last updated on MARCH 23, 2016

Applies to:

JDBC - Version 9.2.0.6 to 10.2.0.2 [Release 9.2 to 10.2]
Information in this document applies to any platform.

Symptoms

SQL executed via JDBC thin 10.2.0.2 driver very infrequently throws following error:

ORA-12155: TNS:received bad datatype in NSWMARKER packet error.

The SQL susceptible to the error is always the same. The SQL that throws the error may be executed successfully at the rate of 100 times (or more) per every time it errors out.
Issue doesn't reproduce in SQL*Plus environment. Connections are pooled in the production environment.

Issue also occurred with previous 9.2.0.6 and 10.2.0.1 JDBC drivers.

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