Multi-threaded Pro*C Application Connections May Fail With ORA-12570 Error on Red Hat Linux (Doc ID 762277.1)

Last updated on OCTOBER 12, 2016

Applies to:

Oracle Net Services - Version: 10.2.0.1.0
Linux x86-64
PRO*C Application that makes multiple connections within the same process may fail with ORA-12570 errors when executed on Red Hat Linux version 5

Symptoms

Oracle Net trace will show one of the open connections failing abnormally with the following error stack.

(1157642560) [02-SEP-2008 17:37:53:561] nsprecv: reading from transport... 
(1157642560) [02-SEP-2008 17:37:53:561] nttrd: entry 
(1157642560) [02-SEP-2008 17:37:53:568] ntt2err: entry 
(1157642560) [02-SEP-2008 17:37:53:568] ntt2err: soc 29 error - operation=5, ntresnt[0]=530, ntresnt[1]=512, ntresnt[2]=0 
(1157642560) [02-SEP-2008 17:37:53:568] ntt2err: exit

Strace of the failing application process shows the following for the terminated process

22312 17:37:56.635810 read(30, <unfinished ...> 
22312 17:37:56.687596 <... read resumed> 0x2aaab405a176, 2064) = ? ERESTARTSYS (To be restarted) 
22312 17:37:56.687635 --- SIGCHLD (Child exited) @ 0 (0) --- 
22312 17:37:56.687674 read(30, <unfinished ...>

Changes

This would likely be a new implementation of the application or a new installation of Red Hat Linux version 5. 

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