Pro*C Application Hangs Waiting For 'SQL*NET MORE DATA FROM CLIENT'

(Doc ID 2323046.1)

Last updated on NOVEMBER 14, 2017

Applies to:

Oracle Net Services - Version 12.1.0.2 and later
Precompilers - Version 12.1.0.2 and later
Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Pro*C application hangs with "SQL*Net more data from client". 

Intermittently the application sessions appear to be hanged

callstack trace:

skdstdst <- ksedst <- dbkedDefDump <- ksedmp <- ksdxdmp
<- ksdxfdmp <- ksdxcb <- sspuser <- sighandler <- read
<- snttread <- nttfprd <- nsbasic_brc <- nsbrecv <- nioqrc
<- opikndf2 <- kpnxbicbk <- ttcGetSendInfo <- ttcacs <- ttcdrv
<- nioqwa <- upirtrc <- kpurcsc <- kpuexec <- kpnexe
<- opiexe <- kpoal8 <- opiodr <- ttcpip <- opitsk
<- opiino <- opiodr <- opidrv <- sou2o <- opimai_real
<- ssthrdmain <- main <- libc_start_main <- start

Current Wait Stack:
0: waiting for 'SQL*Net more data from client' <=============
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=26222 seq_num=26223 snap_id=1
wait times: snap=2822 min 59 sec, exc=2822 min 59 sec, total=2822 min
59 sec
wait times: max=infinite, heur=2822 min 59 sec
wait counts: calls=0 os=0
in_wait=1 iflags=0x5a0
Wait State:
fixed_waits=0 flags=0x2a boundary=0xa926d1f8/0
Session Wait History:
elapsed time of 0.000012 sec since current wait
0: waited for 'SQL*Net message to dblink'

 

Changes

 Database upgraded to 12.1.0.2 including the environment/server is changed

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