My Oracle Support Banner

SQL Hangs When Using Database Link (Doc ID 551117.1)

Last updated on MARCH 15, 2017

Applies to:

Oracle Net Services - Version 9.2.0.1 to 12.1.0.2 [Release 9.2 to 12.1]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

Certain SQL statement over database link hangs. No error code is shown for the session.A typical example is that a select statement can run with no errors, where as a insert statement fails. Both SQL statement use the same databases and database link.

On server tracing the failure, you may see a error stack similar to the following

[10-JAN-2008 16:27:37:314] nsdo: error exit 
[10-JAN-2008 16:27:37:314] nioqrc:  wanted 1 got 0, type 0 
[10-JAN-2008 16:27:37:314] nioqper:  error from nioqrc 
[10-JAN-2008 16:27:37:314] nioqper:    nr err code: 0 
[10-JAN-2008 16:27:37:314] nioqper:    ns main err code: 12547 
[10-JAN-2008 16:27:37:314] nioqper:    ns (2)  err code: 12560 
[10-JAN-2008 16:27:37:314] nioqper:    nt main err code: 517 
[10-JAN-2008 16:27:37:314] nioqper:    nt (2)  err code: 54 
[10-JAN-2008 16:27:37:314] nioqper:    nt OS   err code: 0 
[10-JAN-2008 16:27:37:314] nioqer: entry 
[10-JAN-2008 16:27:37:314] nioqer:  incoming err = 12151 
[10-JAN-2008 16:27:37:314] nioqce: entry 
[10-JAN-2008 16:27:37:314] nioqce: exit 
[10-JAN-2008 16:27:37:314] nioqer:  returning err = 3113

 



Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.