OCI Application Errors with ORA-3115 (Doc ID 460498.1)

Last updated on OCTOBER 12, 2016

In this Document
  Symptoms
  Cause
  Solution
  References


Symptoms

Third party application using OCI, intermittently hangs. Application log reports ORA-3115 "Unsupported network datatype or representation". No dumps file are produced, nor are any error entries reported in the alert.log.

The application log shows the following :

09:12:40'045|2[0D0C] *** ORACLE error: code is 3115, op is 22 
09:12:40'061|5[0D0C] ORA-03115: unsupported network datatype or representation 
09:12:40'061|2[0D0C] *** DbBindExecute: odsc failed 

Oracle Net client trace shows

[10-SEP-2007 09:58:11:787] nsprecv: 01 01 00 00 00 00 3A 4F |......:O| 
[10-SEP-2007 09:58:11:787] nsprecv: 52 41 2D 30 33 31 31 35 |RA-03115| 
[10-SEP-2007 09:58:11:787] nsprecv: 3A 20 75 6E 73 75 70 70 |:.unsupp| 
[10-SEP-2007 09:58:11:787] nsprecv: 6F 72 74 65 64 20 6E 65 |orted.ne| 
[10-SEP-2007 09:58:11:787] nsprecv: 74 77 6F 72 6B 20 64 61 |twork.da| 
[10-SEP-2007 09:58:11:787] nsprecv: 74 61 74 79 70 65 20 6F |tatype.o| 
[10-SEP-2007 09:58:11:787] nsprecv: 72 20 72 65 70 72 65 73 |r.repres| 
[10-SEP-2007 09:58:11:787] nsprecv: 65 6E 74 61 74 69 6F 6E |entation| 

Flushing the shared pool is known to get rid of the problem for a short while :

SQL> alter system flush shared_pool;

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