ORA-3115 Reported after Database Migration to 10.2.0.3 (Doc ID 471920.1)

Last updated on FEBRUARY 19, 2010

Applies to:

Oracle Net Services - Version: 10.1.0.3.0
Information in this document applies to any platform.
Connections to the database

Symptoms

Connections that were working, start to fail with error "ORA-03115: unsupported network datatype or representation". This can happen when the database is under heavy load or a few hours after the database has been re-started.  Setting database parameters SHARED_CURSORS=EXACT and SESSION_CACHED_CURSORS = 0, does not help. Flushing the shared pool does resolve the problem for a short while.

Oracle Net Client trace show the error inside a data packet :

nsprecv: 00 66 00 00 06 00 00 00  |.f......|
nsprecv: 00 00 04 01 01 00 02 0C  |........|
nsprecv: 2B 00 00 01 07 00 03 00  |+.......|
nsprecv: 00 00 00 00 00 00 00 00  |........|
nsprecv: 00 00 00 20 00 01 01 00  |........|
nsprecv: 00 00 00 3A 4F 52 41 2D  |...:ORA-|
nsprecv: 30 33 31 31 35 3A 20 75  |03115:.u|
nsprecv: 6E 73 75 70 70 6F 72 74  |nsupport|
nsprecv: 65 64 20 6E 65 74 77 6F  |ed.netwo|
nsprecv: 72 6B 20 64 61 74 61 74  |rk.datat|
nsprecv: 79 70 65 20 6F 72 20 72  |ype.or.r|
nsprecv: 65 70 72 65 73 65 6E 74  |epresent|
nsprecv: 61 74 69 6F 6E 0A        |ation.  |

Before this, a data packet can bee seen from the client, where the SQL used is using shared cursors. Something similar to following :

nspsend: 00 69 00 00 06 00 00 00  |.i......| 
nspsend: 00 00 03 47 9D 02 80 09  |...G....| 
nspsend: 01 14 01 01 30 00 00 01  |....0...| 
nspsend: 01 07 01 01 02 00 00 00  |........| 
nspsend: 01 01 01 30 53 45 4C 45  |...0SELE| 
nspsend: 43 54 20 75 73 65 72 6E  |CT.usern| 
nspsend: 61 6D 65 20 46 52 4F 4D  |ame.FROM| 
nspsend: 20 75 73 75 61 72 69 6F  |.bigtabl| 
nspsend: 73 20 57 48 45 52 45 20  |e.WHERE.| 
nspsend: 75 73 65 72 5F 69 64 20  |user_id.| 
nspsend: 3D 3A 31 20 01 01 00 00  |=:1.....| 
nspsend: 00 00 00 00 02 01 00 00  |........| 
nspsend: 01 16 00 00 00 00 00 00  |........| 
nspsend: 00                       |.       |

Changes

Oracle home upgraded to 10.2.0.3

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