Parallelism Enabled: ORA-12552: "TNS: Operation was Interrupted" (Doc ID 1296341.1)

Last updated on JULY 12, 2013

Applies to:

Oracle Net Services - Version 11.1.0.7 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 12-JUL-2013***

Symptoms

Connection to database fail, reporting ORA-12552: TNS:operation was interrupted, when parallelism is enabled. Disable parallelism and connections are fine

Oracle Net Client trace shows

[04-FEB-2011 04:22:52:857] nsprecv: 00 00 29 4F 52 41 2D 31 |..)ORA-1|
[04-FEB-2011 04:22:52:857] nsprecv: 32 35 35 32 3A 20 54 4E |2552:.TN|
[04-FEB-2011 04:22:52:857] nsprecv: 53 3A 6F 70 65 72 61 74 |S:operat|
[04-FEB-2011 04:22:52:857] nsprecv: 69 6F 6E 20 77 61 73 20 |ion.was.|
[04-FEB-2011 04:22:52:857] nsprecv: 69 6E 74 65 72 72 75 70 |interrup|
[04-FEB-2011 04:22:52:857] nsprecv: 74 65 64 0A |ted. |
[04-FEB-2011 04:22:52:857] nsprecv: normal exit


Matching Server trace shows the following stack

2011-02-04 04:23:03.078953 : ntt2err:entry
2011-02-04 04:23:03.078980 : ntt2err:soc 24 error - operation=6, ntresnt[0]=522, ntresnt[1]=4, ntresnt[2]=0
2011-02-04 04:23:03.078997 : ntt2err:exit
2011-02-04 04:23:03.079020 : nserror:entry
2011-02-04 04:23:03.079040 : nserror:nsres: id=0, op=67, ns=12552, ns2=12560; nt[0]=522, nt[1]=4, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
2011-02-04 04:23:03.079061 : nsbasic_bsd:exit (-1)
2011-02-04 04:23:03.079093 : nioqsn:send failed: bl = 97, nicbl = 113
2011-02-04 04:23:03.079112 : nioqper: error from nioqsn
2011-02-04 04:23:03.079131 : nioqper: ns main err code: 12552
2011-02-04 04:23:03.079149 : nioqper: ns (2) err code: 12560
2011-02-04 04:23:03.079178 : nioqper: nt main err code: 522
2011-02-04 04:23:03.079194 : nioqper: nt (2) err code: 4
2011-02-04 04:23:03.079211 : nioqper: nt OS err code: 0
2011-02-04 04:23:03.079231 : nioqer:entry
2011-02-04 04:23:03.079248 : nioqer: incoming err = 12150

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